Page 1 of 1
Export Data from Cube View to File
Posted: Fri Nov 10, 2017 6:43 am
by rajeshdayaneni
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
Re: Export Data from Cube View to File
Posted: Fri Nov 10, 2017 6:50 am
by ascheevel
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.
Re: Export Data from Cube View to File
Posted: Fri Nov 10, 2017 6:55 am
by rajeshdayaneni
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
Re: Export Data from Cube View to File
Posted: Fri Nov 10, 2017 7:41 am
by Wim Gielis
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.
Re: Export Data from Cube View to File
Posted: Fri Nov 10, 2017 8:18 am
by rajeshdayaneni
Hello Wim Gielis,
Thank you for your valuable suggestion.