For Conditional Rules
Posted: Tue Nov 10, 2009 10:23 am
Does anyone has an advise on how to do something like for example you have a assumption cube that has the following Dimensions:
Assumptions Cubes:
1. Year
2. Month
3. Day (Legal, Regular, Special)
4. Position (Position1, Position2, etc...)
5. Hours (1st 8 hours, 9 hours, etc...)
6. Version
7. Measure (Rate)
Destination Cubes:
1. Year
2. Days (Jan 1 - Dec 31)
3. Version
4. Measures (S: Hours, Position, Day) (N: Cost, Amount & Number of Person)
Is there any way to ease the writing of the rules rather than doing tons of IF statements for each 3 dimension elements combinations (e.g "Legal", "Position1","1st 8 hours"). Since for Cognos Planning its easier to create a model like such.
I would greatly appreciate any advice on doing such. Thanks a bunch.
Assumptions Cubes:
1. Year
2. Month
3. Day (Legal, Regular, Special)
4. Position (Position1, Position2, etc...)
5. Hours (1st 8 hours, 9 hours, etc...)
6. Version
7. Measure (Rate)
Destination Cubes:
1. Year
2. Days (Jan 1 - Dec 31)
3. Version
4. Measures (S: Hours, Position, Day) (N: Cost, Amount & Number of Person)
Is there any way to ease the writing of the rules rather than doing tons of IF statements for each 3 dimension elements combinations (e.g "Legal", "Position1","1st 8 hours"). Since for Cognos Planning its easier to create a model like such.
I would greatly appreciate any advice on doing such. Thanks a bunch.