TM1 Forum

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

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.

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

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.

Hello Wim Gielis,

Thank you for your valuable suggestion.