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
String Measure of Chid row Applied to Parent
-
- 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: String Measure of Chid row Applied to Parent
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.CiskoWalt wrote:I would like to set up a rule that populates the the Contract Expiration date at the consolidated level.
- Alan Kirk
- Site Admin
- Posts: 6606
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: String Measure of Chid row Applied to Parent
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.
This is the thread that I've given the honour of being the designated FAQ one since it seems to cover things quite well.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
Re: String Measure of Chid row Applied to Parent
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'];
_____________________________________________________________________________________________________
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'];
_____________________________________________________________________________________________________