So I have a dashboard (xyz) pointing to a transformer cube (ABC_mm). However the cube is refreshed every month and published separately (ABC_01, ABC_02, ABC_03, and so on for the 12 months).
I have the one dashboard (xyz) built against ABC_01. And I need the dashboard to dynamically point to the new cube once it is published each month.
Please note that all the 12 cubes are available to the user for the 12 months.
But I need to have the ONE dashboard point to the most recent cube.
How can I achieve this in Cognos ?
Thanks, D
Quote from: damzI on 06 Dec 2016 09:13:19 AM
So I have a dashboard (xyz) pointing to a transformer cube (ABC_mm). However the cube is refreshed every month and published separately (ABC_01, ABC_02, ABC_03, and so on for the 12 months).
I have the one dashboard (xyz) built against ABC_01. And I need the dashboard to dynamically point to the new cube once it is published each month.
Please note that all the 12 cubes are available to the user for the 12 months.
But I need to have the ONE dashboard point to the most recent cube.
How can I achieve this in Cognos ?
Thanks, D
You could publish a cube ABC_MostRecent in addition to the 01, 02, etc. versions. Point the dashboard over the generically named one.
Lynn,
Thank you for your quick response. I did consider having 2 cubes - however my cubes are large and have been partitioned and have security in them. If duplicating and renaming the original cube it does not, and I have to rebuild with the other names - am I missing something ?
Thanks, Damini