TM1 Forum

OK, Thanks a lot.

Thanks Adam and Wim,

I really like this idea, can both of you tell or share a step by step process or a link to do this, I totally dont know VBS and Powershell, so please guide me to do this. I only know Cognos.

Thank you so much for your reply

but can we take excel and convert it into csv by TI process, and then can we upload csv into tm1?

Is there anything similar we can do?

Hello All,

What are the different method to input the data into tm1 Cube?

I'm particularly interested in understanding if it's possible to input data into a TM1 Cube directly from an Excel file(not .csv and not .cma) using a process. Has anyone attempted this?

Thanks!!!

Thanks all for the reply, ['at_PBBU'] = S: If( (DB('}ElementAttribute_Cpg_hierarchy', ATTRS('Product', !Product ,'at_CPG'), 'att_PPBU') @= 'Y'), DB('}ElementAttribute_Cpg_hierarchy', ATTRS('Product', !Product ,'at_CPG'), 'att_PPBU'), ' ' ); This rule is working now. I wanted to put Y flag in the pro...

Hi MarenC, Thank you so much for your reply, but I tried this, this isnt working. And I am writing the rule in product attribute cube only. 2 rules I tried:- 1.) ['at_PBBU'] = S: If( (DB('}ElementAttribute_Cpg_hierarchy', ATTRS('Product', !Product ,'at_CPG'), 'att_PPBU') @= 'Y') , 'Y' , '' ); 2.) ['...

Common man, thanks for your advice on the previous reply,
That really helped me alot. And I apologies for not replying @WimGielis.
Now lets discuss this Wim.

Hello, I'm seeking assistance with creating a TM1 rule to dynamically propagate values between dimensions in IBM TM1. There are 2 dim Product & CPG, Half of Product dimension is in CPG. For eg, Product dimension is, 'Total Company' parent of 'PC' and 'HC', 'PC' splits in 'CPG1' and 'CPG2', 'HC'...

Hello TM1 Team,

@WimGielis please help with this TI, if similar TI available please send.

@AkashGautam Thanks for posting this question I am also having the same challenge.

Thanks & Regards