If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Dashboards in Cognos 11 based on Dynamic cubes- possible?

Started by DeeEss, 03 Mar 2016 06:25:56 AM

Previous topic - Next topic

DeeEss

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!

MFGF

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.
Meep!

MFGF

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.
Meep!

DeeEss

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 ! :-[ :-\

MFGF

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.
Meep!

mrcool

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

MFGF

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.
Meep!

mrcool

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


mrcool

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

MFGF

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.
Meep!