Export Data from Cube View to File

Post Reply
rajeshdayaneni
Posts: 18
Joined: Fri Aug 11, 2017 6:24 am
OLAP Product: TM1
Version: 10.2
Excel Version: 7

Export Data from Cube View to File

Post 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
ascheevel
Community Contributor
Posts: 286
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

Post 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.
rajeshdayaneni
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

Post 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
Wim Gielis
MVP
Posts: 3105
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

Post 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.
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
rajeshdayaneni
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

Post by rajeshdayaneni »

Hello Wim Gielis,

Thank you for your valuable suggestion.
Post Reply