Hi,
I have to export data from TM1 Cube view to File (not all the records).we need to export specific set of records from the Cube View that satisfies the below condition .
IF(Upload_date >= Current_Date )
Please help me to achieve this requirement.
we are using Performance Modeler
Regards,
Rajesh
Export Data from Cube View to File
-
- Posts: 18
- Joined: Fri Aug 11, 2017 6:24 am
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 7
-
- Community Contributor
- Posts: 287
- Joined: Fri Feb 15, 2013 5:49 pm
- OLAP Product: TM1
- Version: PA 2.0.9.1
- Excel Version: 365
- Location: Minneapolis, USA
Re: Export Data from Cube View to File
A TI process that uses a time subset based on your criteria for the source view should work. Or if you wanted to be lazy, you could evaluate all time periods and then filter in the data tab what gets written to file.
-
- Posts: 18
- Joined: Fri Aug 11, 2017 6:24 am
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 7
Re: Export Data from Cube View to File
Hi ascheevel ,
thank you for your suggestion.
i am new to Tm1 .Could you please provide the code to do this in TI process .It will helps me a lot.
Regards,
Rajesh dayaneni
thank you for your suggestion.
i am new to Tm1 .Could you please provide the code to do this in TI process .It will helps me a lot.
Regards,
Rajesh dayaneni
-
- MVP
- Posts: 3113
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Export Data from Cube View to File
Hello
Rather than asking for a lot of code and copy/paste like a monkey would do, please have a look at the codes in the TM1 model. I bet that the model already contains such codes. Typically look for functions like SubsetCreate, ViewCreate, ViewSubsetAssign, ... in the Prolog tab. In the Data tab you need AsciiOutput. Browse the forum for examples if you don’t find them in your model.
Rather than asking for a lot of code and copy/paste like a monkey would do, please have a look at the codes in the TM1 model. I bet that the model already contains such codes. Typically look for functions like SubsetCreate, ViewCreate, ViewSubsetAssign, ... in the Prolog tab. In the Data tab you need AsciiOutput. Browse the forum for examples if you don’t find them in your model.
Best regards,
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
-
- Posts: 18
- Joined: Fri Aug 11, 2017 6:24 am
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 7
Re: Export Data from Cube View to File
Hello Wim Gielis,
Thank you for your valuable suggestion.
Thank you for your valuable suggestion.