linking cubes

Post Reply
talsam
Posts: 11
Joined: Thu Mar 31, 2016 5:42 am
OLAP Product: TM1
Version: 10.0
Excel Version: 2013

linking cubes

Post by talsam »

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.
tomok
MVP
Posts: 2836
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: linking cubes

Post by tomok »

This forum is not a substitute for training on your part.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
User avatar
jim wood
Site Admin
Posts: 3958
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: linking cubes

Post by jim wood »

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.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Karthik1710
Posts: 21
Joined: Fri Oct 31, 2014 3:25 am
OLAP Product: Cognos TM1
Version: 10.2
Excel Version: 2007

Re: linking cubes

Post by Karthik1710 »

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
bmrizzuti
Posts: 9
Joined: Fri May 11, 2012 1:38 pm
OLAP Product: TM1
Version: 10.1
Excel Version: 2007

Re: linking cubes

Post by bmrizzuti »

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! :)
Post Reply