Submitted by Craig Taylor, BI Solutions Architect and Product Advisor
Users would like to select a value/member from a prompt and display the children of that member in a report or another prompt (cascading prompt). However, in some cases, the member may not have any children as is the case with ragged hierarchies. In this case, they wish to then display the value/member selected in the prompt instead.
In this example there is a Regions dimension with a structure of Countries -> States / Provinces -> Cities; it has a ragged... [Continue Reading]