Hi,
I would like to know , is it possible to create query calculations in dashboard .
Only my levels are shown to select . say if i wanted to filter by certain material in certain level , can i write a query calculation ?
how do you guys create dashboard , is it based on data module pr directly based on cube.
new to dashboarding so any suggestions is supported.
I have created Dashboards in 11.0.10 using Transformer Cubes as a source (I was able to use multiple cubes within a dashboard too!).
If I remember correctly - I have since switched jobs and I am back on 10.2.2 (moving directly to 11.1.1 within a few weeks) - you can drag the appropriate "level" within your cube directly in the chosen visualization into the filter section and then select the appropriate member to filter on.
Also, I think you can also drag the "level" directly into a table visualization and link this to another visualization to make this a selector if that is the preferred way for your dashboard to work.
As I said, this is from memory only.
Hope this helps.
Thanks in advance,
Adam.