For Conditional Rules

[appleglaze28]

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.

[ajain86]

do you mind posting a sample if statement?

I am not sure I understood what you are trying to do.