TM1 Forum

talsam wrote: what should I do ?

Either change your delimiter or as suggested encapsulate your columns with single quote and in properties change the Quote char = ' and preview your data it should work

In Tm1 Elements are numeric or string type If you want to store string data make the element as string and make sure it should be the last dimension of your cube other wise it wont work. eg. If you want to store comment Make an element comment in last dimension and then you can input any string on t...

Hi,

You have to drag values for (Total product of value and weight) and Weight
Create one more element or variable
V1= Value * Weight
Weighted Average = V1/Weight

It will work!!!!

Thanks for the insight.....

Thanks for the reply....
I am using Link in Performance Modeller as 'Rule' ( Implementation type). Since , it throws an validation error link does not get executed as rule.
Can you tell me where I can change in Rule to get it move the data to consolidated level.

Hi , I need some guidance. I want to apply break back feature in TM1. Break-back was one of the famous features in Cognos Enterprise Planning, it allowed data input in a calculated cell and system would adjust all the participating elements to match the new result. I want to load the data from anoth...

Thanks Alan for your reply.

Hi Jim, Can you help me in building validation in cubes it will be of great help. I am using TM1 10.2.2
My requirement is I have to restrict the user to input values with in range for eg between 0 and 1.

Hi ,

Can anyone guide me I am stuck with classic editor in TM1 10.2.2. IBM told me that it is no more valid and I have to struggle with basic editor only .
Since it does not support 64 bit architect.

How one anyone work in basic editor and that too in latest version???

Thanks for reply.By web sheet do you mean perspective (excel -addin) or TM1 Application (Contributor) . Can we apply same validation like excel in TM1 application once deployed on web.

Do we have data validation checks in TM1 same as EP or do we need to do some tweak in getting that. I mean is it straightforward or we have to apply rule function. eg : Restrict the user to enter the input within range 0 and 9 or do we need to apply rule. if yes , can someone give me example how to ...