TM1 Forum

Hi I am trying to create a new cube and dimensions using a TI process and loading the data into the cube using CSV file. In the prolog : dimensiondestroy('m_intest'); dimensiondestroy('m_outtest'); dimensioncreate('m_intest'); dimensioncreate('m_outtest'); cubecreate('LKP_CC','m_intest','m_outtest')...

Hi Team,

I have extracted 3 CSV files from one cube using different views, Now i want to make a final CSV file using these 3 files using TI process.

how can i achive this in TM1.

Regards
Ashok

Hi , I am trying to export data from a cube and putting in a CSV file. To do this i am creating a view , In that view i need to export data for 2 measures. When i am creating the View in the subset for measure dimension i am wrinting as below. SubsetCreate('Measure',Subsetname); SubsetElementInsert(...

Hi All, I have TI process which is running correctly . My TI process : Test_TI and i renamed it to Test1_TI , In Test_TI iam creating the dimensions and cube and loading the file data into the cube. After that i am exporting the same data into the CSV file and deleting that cube and dimensions from ...

In source file they have two time stamped references & they want to connect both with Time Dimension. Let me give you some examples of why we have this business requirement: Case 1: In our SAP-bookings we consider two time stamps: date of transaction and date of the booking itself. It can happen...

Thanks guys for all your support.!!!!!

Ahhh... Got your point...

@Duncan - Your comment is completely understood..

Thanks Duncan and Steve Rowe. .....

@Duncan -- Thanks a lot for your expert comments.. It worked for us.. and now in output file we are getting single records. But, could you please explain it in little bit more detail. According to our understanding: While creating source view of the cube, we were using 2 elements of measure dimensio...

Hi

Yes, I am getting the BGTQTY and BGTAMT using CELLGETN

I am extracting this data from a cube, So there won't be any duplicates in the cube.

RGD's
Ashok

I tried - Not working still the rows are repeating: If(count=1); count = count+1; ASCIIoutput(v_output_file,'FISCAL PERIOD','PLANT','MATERIAL OUT','MATERIAL','ACTIVITY TYPE','COST CENTER','DEBIT CREDIT','CURRENCY','UoM','BUDGET AMOUNT','BUDGET QUANTITY'); Else; ASCIIoutput(v_output_file,v_fiscal_per...

sorry, I for got to include the important point, I am able to extract the data into the CSV file but the data is coming Tiwce (Each Row it is repeating)

Hi I am trying to Extract data from a cube view , When extracting to CSV file i have Print heading aswell in the CSV file, So i am trying to write the below mentioned code to print the values. If(count=1); ASCIIoutput(v_output_file,'FISCAL PERIOD','PLANT','MATERIAL OUT','MATERIAL','ACTIVITY TYPE','C...