Cognos Gurus,
Can dynamic cubes not be used as a source for dashboards in cognos analytics?
Can it be somehow added to a data module?
I am able to use dynamic cube as source for reports, but not dashboards. Am i missing something?
Please treat this urgent!
[ I have been working on designing a dynamic cube for a few weeks using v10.2 but now everything is upgraded to 11 and I am kind of lost and need to update my client if it is such that dynamic cubes cannot be used for dashboards in cognos 11)
Thanks in advance!
Quote from: DeeEss on 03 Mar 2016 06:25:56 AM
Cognos Gurus,
Can dynamic cubes not be used as a source for dashboards in cognos analytics?
Can it be somehow added to a data module?
I am able to use dynamic cube as source for reports, but not dashboards. Am i missing something?
Please treat this urgent!
[ I have been working on designing a dynamic cube for a few weeks using v10.2 but now everything is upgraded to 11 and I am kind of lost and need to update my client if it is such that dynamic cubes cannot be used for dashboards in cognos 11)
Thanks in advance!
Hi,
Sadly you're not missing anything. Currently, dashboards can use uploaded files and / or data modules as data sources. Data Modules can be created based on uploaded files and / or relational data sources, but not OLAP sources currently. Bottom line is that as things stand with the current released version, you can't build dashboards over Dynamic Cubes.
Probably not what you wanted to hear...
MF.
It seems IBM have an open Enhancement Request to add packages in dashboards. Might be worth you adding your vote to this?
https://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=84064
Cheers!
MF.
Thanks MFGF.
definitely not what i wanted to hear but confirmation on this helps.
In this scenario, does the dynamic cube become obsolete or it does make sense to give all the business users a dynamic cube for reporting and for the leadership we design dashboards based on relational database.
Kindly lend approach suggestion if any?
Many thanks in advance ! :-[ :-\
Quote from: DeeEss on 03 Mar 2016 11:50:13 PM
Thanks MFGF.
definitely not what i wanted to hear but confirmation on this helps.
In this scenario, does the dynamic cube become obsolete or it does make sense to give all the business users a dynamic cube for reporting and for the leadership we design dashboards based on relational database.
Kindly lend approach suggestion if any?
Many thanks in advance ! :-[ :-\
Hi,
I really can't see Dynamic Cubes being classed as obsolete. They are (in my opinion) one of the kingpins in IBM's strategy for analysis over Big Data. I'd like to think that it will be possible to build dashboards based on OLAP sources at some future point - in fact if you look at IBM's Planning Analytics offering, they are including what appears to be the same dashboarding technology but based over TM1 (ie OLAP) as a data source. I'd like to think that if they can make it work with TM1 they can also make it work with Dynamic Cubes.
For now, it doesn't though, so you're currently limited to reports and workspaces for data from Dynamic Cubes. If you have aggregate tables already in place in your data warehouse, you could perhaps use these in a Data Module and see what performance you get in a dashboard (assuming the aggregate tables have much lower row counts than the main fact tables)? For now I'd use dashboards for smaller or more aggregated data, and see what happens when IBM release future versions.
Cheers!
MF.
It would have been good if IBM had come up with something similar to Tableau or qlikview to import data as extracts/qvds. Apart from interface IBM hasn't changed much from their previous releases. If we don't have well performed database there is no point in using Dashboards.
This is still putting IBM behind in data discovery space. My organization uses both cognos and Tableau and at present users are moving towards Tableau because we have performance issues with our datawarehouse where users are extracting the data as extracts and use it offline for data discovery and dashboarding.
We expected that IBM will come up with similar approach in Cognos analytics but it is a huge disappointment.
Cheers,
mc
Quote from: mrcool on 06 Mar 2016 06:07:34 AM
It would have been good if IBM had come up with something similar to Tableau or qlikview to import data as extracts/qvds. Apart from interface IBM hasn't changed much from their previous releases. If we don't have well performed database there is no point in using Dashboards.
This is still putting IBM behind in data discovery space. My organization uses both cognos and Tableau and at present users are moving towards Tableau because we have performance issues with our datawarehouse where users are extracting the data as extracts and use it offline for data discovery and dashboarding.
We expected that IBM will come up with similar approach in Cognos analytics but it is a huge disappointment.
Cheers,
mc
Hi,
If you create a Data Module, you can enable Snapshot mode, where the data is copied from the underlying database into the columnar data store. Is this what you mean? Sounds a lot like what you're describing here?
Cheers!
MF.
Thanks MF..Yes this is what I am looking for. Does Cognos analytics comes with db2 blu??or is this columnar data store something different.
Sent from my A0001 using Tapatalk
Quote from: MFGF on 07 Mar 2016 04:29:27 AM
Hi,
If you create a Data Module, you can enable Snapshot mode, where the data is copied from the underlying database into the columnar data store. Is this what you mean? Sounds a lot like what you're describing here?
Cheers!
MF.
Thank you so much MF. I have googled and found the answer to my question. I should try this in my environment. By any chance did you test the performance in snapshot mode?
Thanks,
mc
Quote from: mrcool on 07 Mar 2016 06:07:08 AM
Thanks MF..Yes this is what I am looking for. Does Cognos analytics comes with db2 blu??or is this columnar data store something different.
I believe Cognos BI still comes with bundled DB2 (BLU) entitlements, just like in 10.2.2, but the columnar store used for uploads and snapshots in Cognos Analytics is a different technology and is installed automatically with the BI Server component.
Quote from: mrcool on 07 Mar 2016 06:12:33 AM
Thank you so much MF. I have googled and found the answer to my question. I should try this in my environment. By any chance did you test the performance in snapshot mode?
I'd venture that performance is going to depend very much on data volumes. The uploads I have tried so far all seem to perform very well, but I haven't pushed the envelope in terms of data volume.
Cheers!
MF.