TM1 Forum

i have one cube A which contains, lets say, 4 dimensions: name, location, amount, sum total. and other cube b: location, currency, exchange rates.

Now i want that if user inputs something in cube A according to the location , then TM1 must take the corresponding exchange rates from cube B , multiples the amount(from cube A) with exchange rate(from cube B) and gives the sum total in cube A.

What all rules and links can i apply for this.. need some help..

Thanks in advance.

This forum is not a substitute for training on your part.

I think what our friend above is trying to say is: while we welcome beginners to this forum and try to help out where we can, we do look for any user to have at least a grasp of the basics. IBM run training courses through 3rd party vendors like Global Knowledge. The TM1 user and developer courses will answer your question and will also help you achieve your desired results quicker,

Jim.

As mentioned above, please go through Developer guides or IBM training.

You could learn writing code for your scenario by going through this specific topic here:
http://www.ibm.com/support/knowledgecen ... 6B?lang=en

talsam wrote:i have one cube A which contains, lets say, 4 dimensions: name, location, amount, sum total. and other cube b: location, currency, exchange rates.

Now i want that if user inputs something in cube A according to the location , then TM1 must take the corresponding exchange rates from cube B , multiples the amount(from cube A) with exchange rate(from cube B) and gives the sum total in cube A.

What all rules and links can i apply for this.. need some help..

Thanks in advance.

So basically you want an intercube rule. That kind of information can be found in the TM1 Manual, I don't want to be harsh but while this forum is a well-known source for knowledge, it's for more specific technical questions, and it is not a substitute from reading the manuals. I suggest you first take a couple of hours reviewing the manuals you can find online or with your version of TM1 and then post here any more specific doubts you have.

Have a great day!