Unable to create Dashboards in Cognos Analytics

[raj_aries81]

Hi,

I'm getting below error while creating a new dashboard using an existing Relational Package in Cognos 11.0.8

'An error occurred while loading the tree'

I can open the Package in Report Studio. Please let me know if anyone has encountered this issue before

Regards
Raj

[Redrichmond]

Upgrade to 11.0.9 and try that.

If not try and replicate the issue with Go sales(match your query subjects the same and the same number of dataitems - so if theres 20 data items in your query subject make sure the go sales has the same) and then log a ticket to IBM and send them your go sales FM model. I have found a bug around dimensional cubes and that's with development in ottawa and found another bug this week. Keep logging the tickets so they fix them (or not)

[raj_aries81]

Thanks Redrichmond.

Sure. I will try to replicate the issue with GO Sales. I will log a ticket to IBM and will keep the forum posted.

Regards
Raj

[MFGF]

Hi,

I'm getting below error while creating a new dashboard using an existing Relational Package in Cognos 11.0.8

'An error occurred while loading the tree'

I can open the Package in Report Studio. Please let me know if anyone has encountered this issue before

Regards
Raj

Is your package published in Dynamic Query Mode?

MF.

[raj_aries81]

Is your package published in Dynamic Query Mode?

MF.

Hi MF,

No its using CQM

Regards
Raj

[raj_aries81]

Hi MF,

Thanks for pointing me in the right direction, that answers my question. I found the below information on the IBM website and realized it works only with DQM

https://www.ibm.com/communities/analytics/cognos-analytics-blog/whats-new-in-dashboarding-in-cognos-analytics-11-0-5/

One important point to note is that these relational packages must be published as either as DQM or connect to a JDBC datasource. Meaning that for CQM packages,
your admin will need to add a JDBC connection to the datasource in order for the dashboard to be able to use it.

Regards
Raj

[MFGF]

Hi MF,

Thanks for pointing me in the right direction, that answers my question. I found the below information on the IBM website and realized it works only with DQM

https://www.ibm.com/communities/analytics/cognos-analytics-blog/whats-new-in-dashboarding-in-cognos-analytics-11-0-5/

One important point to note is that these relational packages must be published as either as DQM or connect to a JDBC datasource. Meaning that for CQM packages,
your admin will need to add a JDBC connection to the datasource in order for the dashboard to be able to use it.

Regards
Raj

Aha - that explains it. :)

Cheers!

MF.