COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Dashboards => Topic started by: cognos05 on 01 Jan 2019 08:24:49 PM

Title: Dashboards with transformer cubes
Post by: cognos05 on 01 Jan 2019 08:24:49 PM
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.
Title: Re: Dashboards with transformer cubes
Post by: adam_mc on 02 Jan 2019 10:51:36 AM
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.