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.
linking cubes
-
- 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
This forum is not a substitute for training on your part.
- 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
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.
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
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- Posts: 21
- Joined: Fri Oct 31, 2014 3:25 am
- OLAP Product: Cognos TM1
- Version: 10.2
- Excel Version: 2007
Re: linking cubes
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
You could learn writing code for your scenario by going through this specific topic here:
http://www.ibm.com/support/knowledgecen ... 6B?lang=en
-
- Posts: 9
- Joined: Fri May 11, 2012 1:38 pm
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2007
Re: linking cubes
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.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.
Have a great day!
