COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => COGNOS Planning => Topic started by: Cognos_World on 26 Oct 2011 06:43:24 PM

Title: Automating Allocation relationship in the central columns.
Post by: Cognos_World on 26 Oct 2011 06:43:24 PM
Hello,

Is there any way to automate the Allocation relationship in the central columns?
I have an Allocation table which has a D-List as its source and Target. I have used a macro to update the D-List from ODBC. And I want to automate the Allocation relationship as well. Is there any way to do it?

The macro @AtabOpen and @AtabRefresh takes me half way thru the process.
Any ideas will be appreciated.

Thanks,
Title: Re: Automating Allocation relationship in the central columns.
Post by: StuartS on 31 Oct 2011 06:00:20 AM
Try exporting your D-Cube to csv--> item1, item2.  Then import to an A Table in a macro. The comma in the export file is the clue on the relationship.

Stuart