If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Cascade tree prompt to different dimensions

Started by oscarca, 13 Aug 2018 07:20:44 AM

Previous topic - Next topic

oscarca

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!