Hi Guys.
I have a report where i am using the DMR model. The report is cross tab report.
Column1 Columns2
Raw (Age Category) Cost Revenue
Age Category Members (Adult, Oldage, Pediatry etc..), When drill down on any age category, it show Male and Female Category.
Now i have created the Drill Through on Cost to Target report. and i have created the slicer in Target report with expression
Heairarchy-AgeCategory(All)-AgeCategory->?AgeCat?, and on parent report i passed the DataElement(Age Category) for AgeCat this works fine and give target report output fine when i click on cost on any age category like Adult or Oldage. But when i first Drill down the Parent report on lets say 'Adult' category to see Male and Female and then i click to see Target report Cost for Female, then either it displays the wrong result or after making few changes, it shows error to enable local processing on FM level (which i dont want to do).
Please sugggest, how can i achieve the target report output correct, no matter from which level i Drill through to target report.
When a drill through is clicked, Cognos will pass member values for the intersection (lowest level). So if you have nested items, Cognos will pass the values of the inner most nested items.
You can create package-based drill throughs and specify what gets passed. The user will have to right click to access the drill through, but in my opinion that's OK for this scenario. A drill through takes precedence over a drill down when clicked, and that could be confusing to the user. It's better to have all functionality as 'right-click' for the specific scenario.
Another alternative is to only set drill through at certain levels within the hierarchy. @MFGF posted a great solution here:
http://www.cognoise.com/index.php/topic,19458.msg76382.html#msg76382