Managing Access tables within Analyst

[Teamkenji]

I'm struggling to create a D-cube of which I can then export to a .txt file, to then use to import into an App within Cognos Planning administration.

When I export, I end up with an additional column of data which is redundant.

What I'm asking is: Is this actually possible? so I dont waste anymore time.

Cheers

[StuartS]

Persevere. 

I have several models that have many access tables that have their imported txt file produced and controlled by a series of cubes and macros in Cognos Analyst.

If you have an additional column of data that is redundant is it due to a dimension in your D-Cube that you do not want in the txt file?  You can when exporting a D-Cube, either, manually, or through an analyst macro, hide dimensions.

Regards

Stuart

[moocher]

Also, there is a check box to export as single or multiple columns. You may need to play around with this.

But, yes, the same as the poster above, I use dcubes to create access table files all the time. Once you have cracked it they work very well.

[jan.herout]

You will find this one interesting:

http://support.cognos.com/supported/tti/public/docs/cognos_pp_modeling_managing_access_tables_in_analyst.pdf?lid=cognos_pp_modeling_managing_access_tables_in_analyst

As a rule of thumb, if a access table content will change in time, you really should use this technigue to maintain it. Manual maintenance in CAC will produce errors. For more complex models it may even be impossible to prepare access table manually.

Hope this helps.

[CognosPaul]

Hi HelenJames,

Please prove to me that you're human by solving the following problem: integrate x^2 sin^3 x dx

I'll need you to show your work. You may use a calculator.