Dashboards with transformer cubes

[cognos05]

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.

[adam_mc]

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.