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 » Fri Nov 10, 2017 6:43 am

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
Posts: 12
Joined: Fri Feb 15, 2013 5:49 pm
OLAP Product: TM1
Version: 11.2
Excel Version: 2016

Re: Export Data from Cube View to File

Post by ascheevel » Fri Nov 10, 2017 6:50 am

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 » Fri Nov 10, 2017 6:55 am

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: 1569
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0
Excel Version: 2016
Location: Brussels, Belgium
Contact:

Re: Export Data from Cube View to File

Post by Wim Gielis » Fri Nov 10, 2017 7:41 am

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

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 104 TM1 articles and a lot of custom code
Newest blog article: Delete a cube and its dimensions

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 » Fri Nov 10, 2017 8:18 am

Hello Wim Gielis,

Thank you for your valuable suggestion.

Post Reply