Passing value from a filter to dashboard

Hi there,


I have a question about passing filter value to dashboard.


There is a filter called 'AreaName' containing 3 values from the drop down list. These values come from a small DimArea table with key and name columns.


AreaName AreaKey

SQM 1

SQFT 2

TSU 3


The dashboard is based on s data cube that has a param called AreaKey. If a user selected SQM from the filter, the AreaKey = 1, the actual area measure will be multiplied by area measure unit exchange rate.


Is there a simple way to pass this value?


Thanks and regards,

Helen

Hi Helen,

Can you provide a few more details in regards to the use case at hand. There are many possible options depending on what you are trying to achieve but first I would like to make sure we are on the same page. When you mention you want to pass the filter value to a dashboard - can you specify where is the filter value coming from? is the filter value coming from a drop down list placed on a different dashboard or a different web application outside of Dundas BI? It would be great if you could describe the entire flow and missing parts you are unsure about at the moment. If this information is confidential you can also contact our support team directly and share more details via phone or email to support@dundas.com.