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