Drill Assignment Rule Question - Multiple Rules
Posted: Tue Mar 13, 2012 2:12 pm
Hello,
I have been quite successful so far with the Drill Through process and getting it to work properly (thanks to people who have offered advice so far). For the first cube that I had to accomplish this for, I only needed to make sure that field to drill on is a leaf. For the next cube that I need to get Drill Through working, I have a couple of pieces that all must be met and I am not sure how to accomplish this or get started.
Here are the rules:
Version Dimension = Actual
Planning Measures Dimension = Value
Cell must be a leaf.
Would the ELLEV function be used? Here is the sample code that I wrote up (havent been able to test just yet):
[] = S:IF( (ELLEV('Version','Actual') = 0 ) &
{ELLEV('Planning Measures', 'Value') = 0 ) &
(ISLEAF = 1), '<CubeName>', '');
I have been quite successful so far with the Drill Through process and getting it to work properly (thanks to people who have offered advice so far). For the first cube that I had to accomplish this for, I only needed to make sure that field to drill on is a leaf. For the next cube that I need to get Drill Through working, I have a couple of pieces that all must be met and I am not sure how to accomplish this or get started.
Here are the rules:
Version Dimension = Actual
Planning Measures Dimension = Value
Cell must be a leaf.
Would the ELLEV function be used? Here is the sample code that I wrote up (havent been able to test just yet):
[] = S:IF( (ELLEV('Version','Actual') = 0 ) &
{ELLEV('Planning Measures', 'Value') = 0 ) &
(ISLEAF = 1), '<CubeName>', '');