TM1 Forum

Hello,

I have a cube that stores a date as string. Contract Expiration Date "1/25/2013"

I have the following dimension that contains customers and contracts

All Contracts
Contract 1
Customer 1
Customer 2
Customer 3

A second dim that contains the service

Service A
Service B


Customer Dim Service Dim Con Expiration Date
All Contracts
Contract1 A '.' ----> Consolidated element 1
Contract1 B '.' ---> Consolidated element 2
Customer1-Contract1 A '.'
Customer1-Contract1 B 1/25/2013
Customer2-Contract1 A '.'
Customer2-Contract1 B 1/25/2013

I would like to set up a rule that populates the the Contract Expiration date at the consolidated level.


Customer Dim Service Dim Con Expiration Date
All Contracts
Contract1 A 1/25/2013 ----> Consolidated element 1
Contract1 B 1/25/2013 ----> Consolidated element 1
Customer1-Contract1 A '.'
Customer1-Contract1 B 1/25/2013
Customer2-Contract1 A '.'
Customer2-Contract1 B 1/25/2013


Assign the date assigned the the child to the parent. The dates associated with the contract will always be the same. So if we find one row that has a date, we can use that date for the consolidated elemement "contract1")

thanks,

Walt

CiskoWalt wrote:I would like to set up a rule that populates the the Contract Expiration date at the consolidated level.

I think this must be around the 10th post I've seen just this year about assigning leaf strings to their parent's! Do a quick search on "strings to consolidated node". There has been plenty of discussion about this already. No need to rehash all your options.

I'm not sure whether it's 10, but I agree that it comes up frequently enough to warrant it being FAQed.

This is the thread that I've given the honour of being the designated FAQ one since it seems to cover things quite well.

Thank your for your help.

Have found that we need to add the 'S:' before the IF. If there is no S: nothing is returned.

Best,

Walt

___________________________________________________________________________________________________

['Start Date'] =
IF(
ELLEV('Month', !Month) <> 0),
DB('YourCube', ... , ELCOMP('Month', !Month, 1), ...),
CONTINUE
);

____________________________________________________________________________________________________


FEEDSTRINGS;
SKIPCHECK;

['Contract Expiration'] =
S: IF(
ELLEV('Affiliate Code', !Affiliate Code) <> 0,
DB('AFFAttr',!entity, ELCOMP('Affiliate Code', !Affiliate Code, 1), !PlanYear, 'ACTUAL', !TIME, 'Contract Expiration'),
CONTINUE
);

FEEDERS;
['Contract Expiration']=>['Contract Expiration'];


_____________________________________________________________________________________________________