Matching an element in attribute with element in dimension

Post Reply
mithun.mistry11
Posts: 10
Joined: Sun Sep 07, 2014 9:18 pm
OLAP Product: tm1
Version: 10.2
Excel Version: 2010

Matching an element in attribute with element in dimension

Post by mithun.mistry11 »

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
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: Matching an element in attribute with element in dimensi

Post by jim wood »

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
uchow10
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

Post by uchow10 »

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
Post Reply