Hi!
Is it possible to export data from several cubes into one single ascii file?
Regards!
Ascii export
-
Alan Kirk
- Site Admin
- Posts: 6667
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Ascii export
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.kastellu wrote:Hi!
Is it possible to export data from several cubes into one single ascii file?
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
kastellu
- Posts: 29
- Joined: Thu May 26, 2011 5:38 pm
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2008
Re: Ascii export
Tnx!
-
AmbPin
- Regular Participant
- Posts: 173
- Joined: Sat Mar 20, 2010 3:03 pm
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2007-10
Re: Ascii export
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?
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?
- Capture.PNG (6.65 KiB) Viewed 3069 times