Skip to Content

Cascading filters and the corresponding measure value to a AdvancedKPItile

Mar 08, 2017 at 03:13 PM


avatar image

Hi All,

Thanks for the below blog for providing solution for cascading filters when UNX as data source. I could able to get the desired filteration but am not able to show the narrow down measure value to a "AdvancedKPItile". Please suggest here.


Vishal P

10 |10000 characters needed characters left characters exceeded


Can you be more specific? Which "Advanced KPI Tile" are you talking about?

Can you provide a screenshot of your data source initial view, indicating which measure value you are trying to assign to the KPI tile?


Hi Mustafa,

To give more insight, please find the attached screenshot. initial-view.jpg

As I am using DS 1.6 SP3 and created a "AdvancedKPITile" and at the "Advancedproperty"-> "LayoutDesign" -> Selected a type: KPI -> Datatype: Dynamic -> value: have selected one sales value from the initial view.

I ran the application, and then when I see the KPI value assigned to the tile showing the text "Couldn't find member "US" of dimension "346646464***" in selection "{" Keyfigures ":" --------" along the background value.

Please suggest here.


Vishal P.

initial-view.jpg (32.8 kB)

Hi Vishal,

Can you also post a screenshot of the Additional Property Sheet of the KPI tile component you are using?


Hi Mustafa, PFA of the same.

kpitile1.jpg kpitile2.jpg

During assignment of a value to the KPI am selecting a random value(sales) in the table.

And at runtime it should pick & display the value dynamically when there is a change in the dropdowns, say as per my previous screenshot, If I select country dropdown value as "US" & state as "Texas" then the KPI should display "43" and similarly to other selections.

kpitile1.jpg (63.4 kB)
kpitile2.jpg (56.0 kB)

Hi Vishal,

From the screenshots of the APS, it looks like you are using the Advanced KPI Tile from the Visual BI Extensions. You should therefore raise your related questions directly with Visual BI Support rather than posting them on the SCN.



* Please Login or Register to Answer, Follow or Comment.

0 Answers