Hello
Would I be able to get some assistence with the issue I have come across as I am still on a learning curve on tm1 if poss please?
The situation is:
I have CUBE.1 (INPUT CUBE), CUBE.2 (REPORTING CUBE) and also a control cube.
I am working on CUBE.2 at the moment. I have created an attribute in one of the dimensions, calling a (string:M02) from the control cube. That has worked. Now I need to use that (string:M02) from the attribute, look through all the elements in DIM1( dimension in CUBE.2), try find a match (M02) and if match found, all the numbers that ARE in those cells (DIM1.ELEMENT1, DIM2.DATE1) , I want to put them in (DIM1.ELEMENT7. DIM2.DATE1)?
Hopefully that makes sense. Can anyone help?
Thank you
Matching an element in attribute with element in dimension
-
- Posts: 10
- Joined: Sun Sep 07, 2014 9:18 pm
- OLAP Product: tm1
- Version: 10.2
- Excel Version: 2010
- 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: Matching an element in attribute with element in dimensi
Post moved as it was posted in the wrong forum.
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: 18
- Joined: Mon Aug 05, 2013 9:25 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2010
Re: Matching an element in attribute with element in dimensi
cant you write a TI that loops DIM1 and checks to see if there is a match? then do all the cellget and cellput at where you want