I have to create a financial report with the general ledger numbers in the rows, followed by the measures budget, actual and difference. The columns consist of the month numbers (1 to 12). This works fine.
Now I want to create a summary footer with the parent totals like in Analysis Studio, which should contain the parent group of the general ledgers numbers again followed by the measures budget, actual and difference. This works until I drill down on the general ledger; the details drill down but the parent group in the summary footer does not. How can I get this to work?
Found a great solution on IT Toolbox to solve my problem: http://businessintelligence.ittoolbox.com/groups/technical-functional/cognos8-l/with-a-dmr-drilldown-crosstab-how-do-i-show-the-hierarchy-current-location-2732606