COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Dashboards => Topic started by: raj_aries81 on 05 Feb 2018 11:00:32 PM

Title: Unable to create Dashboards in Cognos Analytics
Post by: raj_aries81 on 05 Feb 2018 11:00:32 PM
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

Title: Re: Unable to create Dashboards in Cognos Analytics
Post by: Redrichmond on 06 Feb 2018 04:51:06 AM
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)

Title: Re: Unable to create Dashboards in Cognos Analytics
Post by: raj_aries81 on 06 Feb 2018 02:46:14 PM
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
Title: Re: Unable to create Dashboards in Cognos Analytics
Post by: MFGF on 07 Feb 2018 03:41:17 AM
Quote from: raj_aries81 on 05 Feb 2018 11:00:32 PM
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.
Title: Re: Unable to create Dashboards in Cognos Analytics
Post by: raj_aries81 on 07 Feb 2018 03:55:49 PM
Quote from: MFGF on 07 Feb 2018 03:41:17 AM
Is your package published in Dynamic Query Mode?

MF.

Hi MF,

No its using CQM

Regards
Raj
Title: Re: Unable to create Dashboards in Cognos Analytics
Post by: raj_aries81 on 07 Feb 2018 06:37:35 PM
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


Title: Re: Unable to create Dashboards in Cognos Analytics
Post by: MFGF on 08 Feb 2018 02:18:55 AM
Quote from: raj_aries81 on 07 Feb 2018 06:37:35 PM
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.