TM1 Forum

Hi!

Is it possible to export data from several cubes into one single ascii file?

Regards!

kastellu wrote:Hi!
Is it possible to export data from several cubes into one single ascii file?

Sure. You just need to define an appropriate data source (which may be either a cube view or a dimension subset, though it may be no data source at all; you could in theory do all of your loops in the prolog) and use CellGetN or CellGetS functions to pull the values from the other cubes. After that you just combine the values that you retrieve into a single string and write it out to your file.

Tnx!

On a similar theme; is it possible to influence the order in which you encounter data using ascii export?
If for example we have customer & product dimensions and using a view to define output would it be possible to see the customers grouped by product or the products grouped by customer in the resultant text dependant on how the view is constructed?