Troubleshooting
Problem
Developer has a dimensional report with a tree prompt in it. She wishes to implement a cascading list value prompt based on the business key value selected from any level in the tree prompt.
Resolving The Problem
When you define a cascading prompt, Cognos 8 will attempt to automatically apply a filter to the child prompt query based on the value selected in the parent prompt. However, this doesn't always work as expected against a dimensional data source. This is due to the way in which data is stored and retrieved from the cube. Typically, a prompt query against a cube will only reference the dimension. The "filter" applied against this query is a "slicer" type of filter, which only works to remove "fact" data from the set. So in order to see the results of the filter, we have to have some fact information in the query.
In the attached report, built against our sample Great Outdoors Company powercube, I am able to accomplish this by using a filter function on the dimensional data item to filter the list of choices based on the [quantity] fact value. I choose [quantity] becuase that is the measure I'm using in the crosstab in the report itself.
- 1034536_1.zipHistorical Number
1034536
Was this topic helpful?
Document Information
Modified date:
28 November 2022
UID
swg21371011