Hi All,
Data source: Relational and Cognos 10.2.2 version with fix pack 3.
I have a requirement to use Product dimension in the series of a line chart, by default when nothing is selected then all the products has to be displayed, and when some specific product is selected then the line chart has to be filtered on the selected product member of the tree prompt.
The problem here I am facing is filtering is not working as expected.
Product Regular Dimension design structure in FM as below.
All
Department - _bussinessKey, _memberCaption Product Level 1
Sub Department - _bussinessKey, _memberCaption Product Level 2
Category - _bussinessKey, _memberCaption Product Level 3
Sub Cateogry - _bussinessKey, _memberCaption Product Level 4
Product - _bussinessKey, _memberCaption Product Level 5
Unique Level is checked for all the above levels.
When I try to pull the Product Hierarchy in the detail filter section of the query in the report studio, when tree prompt product dimension is prompted, whatever selection I make in any level filtering is not happening all the members are displayed in the chart. I tried options like using set function in the slicer but, it is making the prompt as mandatory, where I wanted the Product tree prompt to be optional. The other option I tried is, I dragged and dropped individual levels in the query of the line chart, if I select anything in the tree prompt filtering is happening, when I check the tabular data.
Can you guys, please let me know, where am I doing wrong?
Thanks & Regards,
XYZ
You say you have a relational package, but are referencing dimensional attributes. DMR?
If you are trying to use detail filters with DMR, don't. You need to use slicers, for prompting purposes you probably want to check out the filter() function.