View in a flat file format

[Ajay]

Hi All

I'm trying to mimic a flat file by using a view.

Imagine a cube with two dimesions, one for P&L Account, and one for month.

At the moment when produce a view, and run an extract into *cma for it, I get the following output:

Profit, Jul, 10
Profit, Aug, 20

What i'd like to do is having the following:

Profit, 10, 20

My exisiting TI would know that column two is Jul, and that column three is Aug.

Looking at the help screens it would seem that i could use ViewColumnDimensionSet on the month dimension, but i have tried this without success.

Any help from you all would be very welcome.

Thanks
Ajay

[Catherine]

Hi,

What I would do is build my export in a TI process:
-Build your datasource view with "total year" element regarding Time dimension
-In data, write two CellGetN formula to get July and August values
-Write an asciioutput formula to export 3 fields: P&L account, July value, August value

[paulsimon]

Ajay

If you need to automate this via TI then Catherine's suggestion is good. However, if you just want a simple extract in that format, the easiest way is to configure a View with periods across and then snapshot the view to Excel and save as a CSV file. You can automate that via Macros eg VUSLICE etc.

Regards


Paul Simon