Hi,
again we have a question:
We have to CUBES in our model. CUBE1 consist out of values on consolidated level by Family (group of articles) & region (group of customers) and CUBE2 consist out of values on N: level by Article & Customer.
We want to push the values of CUBE1 to CUBE2 by using a rule based calculation. The rule should push all values from CUBE1 to CUBE2 untill N:level.
Example:
CUBE1
Family: 1
Region: NL
Value: 1,50
CUBE2
Family: 1 = Value 1,50
↓
- Category A = Value 1,50
↓
- PL: B = Value 1,50
↓
- Article A = Value 1,50
- Artice B
- Article C
Is there a function available? Information should be real-time.
Thanks for your reply again!
Regards,
Barbara
Push parent values to childeren
-
- MVP
- Posts: 2832
- 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: Push parent values to childeren
If you don't already have, and it's not clear from your info, you need two "Family" dimensions. One with all the elements, both the leaf elements and the hierarchy, let's call it Family_Full, and then one with just the parents called Family_Parents. Family_Parents would go in Cube1 and Family_Full would go in Cube2. Now all you need is an intercube reference rule to pull the values from Cube2 into Cube1. An intercube reference rule works like a JOIN. Only the values from Cube2 that are parents will be moved to Cube1 because that will be the only time there is a match between Family_Full and Family_Parents. The trick is that the dim reference in the rule will need to point to the other Family dimension. Like this:bmeer31 wrote:We have to CUBES in our model. CUBE1 consist out of values on consolidated level by Family (group of articles) & region (group of customers) and CUBE2 consist out of values on N: level by Article & Customer.
We want to push the values of CUBE1 to CUBE2 by using a rule based calculation. The rule should push all values from CUBE1 to CUBE2 untill N:level.
The rule in Cube1:
[]=N:DB(Cube2,!Family_Parents,!DIm2,!Dim3,etc.)