COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => COGNOS Planning => Topic started by: cogplan on 12 Jan 2011 05:33:33 AM

Title: multiple times data getting published in a single table
Post by: cogplan on 12 Jan 2011 05:33:33 AM
Hi techies
           I have a situation where in 5 times the data is getting repeated in database publish. from CAC through a macro I created or manually also if I publish its the same issue.its become a big escalation and finding it tough as data passed through etl and excel extracts are generated through it.. Can anyone please help me out on this

Steps I have undergone
1> Dropped the database and republished it
2> Created a new publish database and published it.. still the same..


regards
cogplan
Title: Re: multiple times data getting published in a single table
Post by: ericlfg on 12 Jan 2011 11:34:48 AM
Hi Cogplan,

Are you publishing roll-ups?  To confirm, head into your publish and click on the 'Options' tab.  Take a look and see if the Include roll-ups check box is selected, if it is try unchecking it and running your publish again.  Once it's completed look at your ETLs and Excel extracts.  This is usually where I see people getting incorrect data in publishes.

Hope this helps.
Eric