Hey Cognos people,
I am wondering if it is possible to cascade from one dimension to another dimension using tree prompt? The main goal of the prompt is to cascade on Profit center to show all the related customers for that Profit center. Customer and Profit Center are different dimensions with their own hierarchies:
[CBI Sales].[Profit Center].[Profit Center Functional]
[CBI Sales].[Customer].[Statistics Customer]
The tree prompt are using these values:
descendants([CBI Sales].[Customer].[Statistics Customer].[(All)]->:[M16].[Customer].[Statistics Customer].[All],2)
descendants([CBI Sales].[Profit Center].[Profit Center Functional].[Profit Center Functional Level 5]->:[M16].[[Profit Center]].[Profit Center Functional]].[Profit Center Functional Level 5]].&[11 BUSINESS UNIT]]],1)
Maybe this can be done with somekind of filter expression in the second treeprompt ?
Thanks in advanced!