Cognos Analytics

Hi,

#CognosAnalytics 

In a list report using an embedded graphic of type Charts, there is a possibility to use a master detail relationship between the query used in the list and the query used for the embedded chart.

I'm searching the same functionality with the 11.1 visualizations and didn't find it (even not on Cognos 12

Where can I find this property on Visualization 11.1 graphics ?

Thanks!

Regards,

Jean-Pierre

Hi Jean-Pierre,

as far as I know this feature does not exist with the 11.1 visualizations. If you want to have MDR you have to swap to "Charts".

Hi,

#CognosAnalytics 

In a list report using an embedded graphic of type Charts, there is a possibility to use a master detail relationship between the query used in the list and the query used for the embedded chart.

I'm searching the same functionality with the 11.1 visualizations and didn't find it (even not on Cognos 12

Where can I find this property on Visualization 11.1 graphics ?

Thanks!

Regards,

Jean-Pierre

Unfortunately I can confirm this

Hi Jean-Pierre,

as far as I know this feature does not exist with the 11.1 visualizations. If you want to have MDR you have to swap to "Charts".

Hi,

#CognosAnalytics 

In a list report using an embedded graphic of type Charts, there is a possibility to use a master detail relationship between the query used in the list and the query used for the embedded chart.

I'm searching the same functionality with the 11.1 visualizations and didn't find it (even not on Cognos 12

Where can I find this property on Visualization 11.1 graphics ?

Thanks!

Regards,

Jean-Pierre

Hi Philipp, Robert,

Thanks for your message, I knew already the answer

I posted to get reaction from IBM ;) 

To understand why they didn't add it  (even not in Cognos 12)

Is it because these visualisations are shared with the dashboard and that it's not possible to have different properties between dashboard and reports ?

Regards,

Jean-Pierre

Unfortunately I can confirm this

Hi Jean-Pierre,

as far as I know this feature does not exist with the 11.1 visualizations. If you want to have MDR you have to swap to "Charts".

Hi,

#CognosAnalytics 

In a list report using an embedded graphic of type Charts, there is a possibility to use a master detail relationship between the query used in the list and the query used for the embedded chart.

I'm searching the same functionality with the 11.1 visualizations and didn't find it (even not on Cognos 12

Where can I find this property on Visualization 11.1 graphics ?

Thanks!

Regards,

Jean-Pierre

Hey Jean-Pierre,

actually I find it too easy by IBM to tell us that this is the problem here. Look at the dashboard's visualizations: they support repeater for columns/rows. That's very similar to MDR. Why not link this feature to the repeaters?

Hi Philipp, Robert,

Thanks for your message, I knew already the answer

I posted to get reaction from IBM ;) 

To understand why they didn't add it  (even not in Cognos 12)

Is it because these visualisations are shared with the dashboard and that it's not possible to have different properties between dashboard and reports ?

Regards,

Jean-Pierre

Unfortunately I can confirm this

Hi Jean-Pierre,

as far as I know this feature does not exist with the 11.1 visualizations. If you want to have MDR you have to swap to "Charts".

Hi,

#CognosAnalytics 

In a list report using an embedded graphic of type Charts, there is a possibility to use a master detail relationship between the query used in the list and the query used for the embedded chart.

I'm searching the same functionality with the 11.1 visualizations and didn't find it (even not on Cognos 12

Where can I find this property on Visualization 11.1 graphics ?

Thanks!

Regards,

Jean-Pierre

It would sure be terrible if someone figured out how to enable the visualization row and column repeating in Report Studio.

It's not officially supported of course. You certainly shouldn't run the following JavaScript from the console in the browser developer toolbar:

var rsVal     = localStorage['RSValue'];if(!rsVal) {  localStorage['RSValue'] = '<userData saveTime="0"><settings><setting name="ShowVidaHiddenProperties" value="true"/><setting name="VidaSmallMultiples" value="true"/></settings></userData>';}else {  var parser  = new DOMParser()    , serial  = new XMLSerializer()    , rsXML   = parser.parseFromString(rsVal,"text/xml")    , nSet    = rsXML.createElement("setting")    , nSet2   = rsXML.createElement("setting")  ;      if(!rsXML.querySelector('setting[name=VidaSmallMultiples]')) {    nSet.setAttribute("name","VidaSmallMultiples")      nSet.setAttribute("value","true")      rsXML.querySelector('settings').appendChild(nSet);  }  if(!rsXML.querySelector('setting[name=ShowVidaHiddenProperties]')) {    nSet2.setAttribute("name","ShowVidaHiddenProperties")      nSet2.setAttribute("value","true")      rsXML.querySelector('settings').appendChild(nSet2);  }  localStorage['RSValue'] = serial.serializeToString(rsXML)}console.log('Small Multiples and Hidden Properties Enabled');

If you do run that, which you shouldn't, you absolutely shouldn't close and reopen report studio to force the changes to take affect. 

Hey Jean-Pierre,

actually I find it too easy by IBM to tell us that this is the problem here. Look at the dashboard's visualizations: they support repeater for columns/rows. That's very similar to MDR. Why not link this feature to the repeaters?

Hi Philipp, Robert,

Thanks for your message, I knew already the answer

I posted to get reaction from IBM ;) 

To understand why they didn't add it  (even not in Cognos 12)

Is it because these visualisations are shared with the dashboard and that it's not possible to have different properties between dashboard and reports ?

Regards,

Jean-Pierre

Unfortunately I can confirm this

Hi Jean-Pierre,

as far as I know this feature does not exist with the 11.1 visualizations. If you want to have MDR you have to swap to "Charts".

Hi,

#CognosAnalytics 

In a list report using an embedded graphic of type Charts, there is a possibility to use a master detail relationship between the query used in the list and the query used for the embedded chart.

I'm searching the same functionality with the 11.1 visualizations and didn't find it (even not on Cognos 12

Where can I find this property on Visualization 11.1 graphics ?

Thanks!

Regards,

Jean-Pierre

oh frustrating - it looks like it only works if Small Multiples is enabled for the user. Saving the report and running it as a different user without the settings fails. Looking for a workaround...

It would sure be terrible if someone figured out how to enable the visualization row and column repeating in Report Studio.

It's not officially supported of course. You certainly shouldn't run the following JavaScript from the console in the browser developer toolbar:

var rsVal     = localStorage['RSValue'];if(!rsVal) {  localStorage['RSValue'] = '<userData saveTime="0"><settings><setting name="ShowVidaHiddenProperties" value="true"/><setting name="VidaSmallMultiples" value="true"/></settings></userData>';}else {  var parser  = new DOMParser()    , serial  = new XMLSerializer()    , rsXML   = parser.parseFromString(rsVal,"text/xml")    , nSet    = rsXML.createElement("setting")    , nSet2   = rsXML.createElement("setting")  ;      if(!rsXML.querySelector('setting[name=VidaSmallMultiples]')) {    nSet.setAttribute("name","VidaSmallMultiples")      nSet.setAttribute("value","true")      rsXML.querySelector('settings').appendChild(nSet);  }  if(!rsXML.querySelector('setting[name=ShowVidaHiddenProperties]')) {    nSet2.setAttribute("name","ShowVidaHiddenProperties")      nSet2.setAttribute("value","true")      rsXML.querySelector('settings').appendChild(nSet2);  }  localStorage['RSValue'] = serial.serializeToString(rsXML)}console.log('Small Multiples and Hidden Properties Enabled');

If you do run that, which you shouldn't, you absolutely shouldn't close and reopen report studio to force the changes to take affect. 

Hey Jean-Pierre,

actually I find it too easy by IBM to tell us that this is the problem here. Look at the dashboard's visualizations: they support repeater for columns/rows. That's very similar to MDR. Why not link this feature to the repeaters?

Hi Philipp, Robert,

Thanks for your message, I knew already the answer

I posted to get reaction from IBM ;) 

To understand why they didn't add it  (even not in Cognos 12)

Is it because these visualisations are shared with the dashboard and that it's not possible to have different properties between dashboard and reports ?

Regards,

Jean-Pierre

Unfortunately I can confirm this

Hi Jean-Pierre,

as far as I know this feature does not exist with the 11.1 visualizations. If you want to have MDR you have to swap to "Charts".

Hi,

#CognosAnalytics 

In a list report using an embedded graphic of type Charts, there is a possibility to use a master detail relationship between the query used in the list and the query used for the embedded chart.

I'm searching the same functionality with the 11.1 visualizations and didn't find it (even not on Cognos 12

Where can I find this property on Visualization 11.1 graphics ?

Thanks!

Regards,

Jean-Pierre

Hi Paul

Thank you for your time !

In fact, is it normal that you are searching and spending time to recreate something available for years ???

I'm still a big fan of Cognos, Dashboard is improving with each release (and that's a good news) but for me the added value and the strength of Cognos is his professional reporting capabilities !!

That is the difference with other players in this competitive market !

Cognos users since 1996

Regards,

Jean-Pierre

oh frustrating - it looks like it only works if Small Multiples is enabled for the user. Saving the report and running it as a different user without the settings fails. Looking for a workaround...

It would sure be terrible if someone figured out how to enable the visualization row and column repeating in Report Studio.

It's not officially supported of course. You certainly shouldn't run the following JavaScript from the console in the browser developer toolbar:

var rsVal     = localStorage['RSValue'];if(!rsVal) {  localStorage['RSValue'] = '<userData saveTime="0"><settings><setting name="ShowVidaHiddenProperties" value="true"/><setting name="VidaSmallMultiples" value="true"/></settings></userData>';}else {  var parser  = new DOMParser()    , serial  = new XMLSerializer()    , rsXML   = parser.parseFromString(rsVal,"text/xml")    , nSet    = rsXML.createElement("setting")    , nSet2   = rsXML.createElement("setting")  ;      if(!rsXML.querySelector('setting[name=VidaSmallMultiples]')) {    nSet.setAttribute("name","VidaSmallMultiples")      nSet.setAttribute("value","true")      rsXML.querySelector('settings').appendChild(nSet);  }  if(!rsXML.querySelector('setting[name=ShowVidaHiddenProperties]')) {    nSet2.setAttribute("name","ShowVidaHiddenProperties")      nSet2.setAttribute("value","true")      rsXML.querySelector('settings').appendChild(nSet2);  }  localStorage['RSValue'] = serial.serializeToString(rsXML)}console.log('Small Multiples and Hidden Properties Enabled');

If you do run that, which you shouldn't, you absolutely shouldn't close and reopen report studio to force the changes to take affect. 

Hey Jean-Pierre,

actually I find it too easy by IBM to tell us that this is the problem here. Look at the dashboard's visualizations: they support repeater for columns/rows. That's very similar to MDR. Why not link this feature to the repeaters?

Hi Philipp, Robert,

Thanks for your message, I knew already the answer

I posted to get reaction from IBM ;) 

To understand why they didn't add it  (even not in Cognos 12)

Is it because these visualisations are shared with the dashboard and that it's not possible to have different properties between dashboard and reports ?

Regards,

Jean-Pierre

Unfortunately I can confirm this

Hi Jean-Pierre,

as far as I know this feature does not exist with the 11.1 visualizations. If you want to have MDR you have to swap to "Charts".

Hi,

#CognosAnalytics 

In a list report using an embedded graphic of type Charts, there is a possibility to use a master detail relationship between the query used in the list and the query used for the embedded chart.

I'm searching the same functionality with the 11.1 visualizations and didn't find it (even not on Cognos 12

Where can I find this property on Visualization 11.1 graphics ?

Thanks!

Regards,

Jean-Pierre

Hi Philipp, Robert,

Thanks for your message, I knew already the answer

I posted to get reaction from IBM ;) 

To understand why they didn't add it  (even not in Cognos 12)

Is it because these visualisations are shared with the dashboard and that it's not possible to have different properties between dashboard and reports ?

Regards,

Jean-Pierre

Unfortunately I can confirm this

Hi Jean-Pierre,

as far as I know this feature does not exist with the 11.1 visualizations. If you want to have MDR you have to swap to "Charts".

Hi,

#CognosAnalytics 

In a list report using an embedded graphic of type Charts, there is a possibility to use a master detail relationship between the query used in the list and the query used for the embedded chart.

I'm searching the same functionality with the 11.1 visualizations and didn't find it (even not on Cognos 12

Where can I find this property on Visualization 11.1 graphics ?

Thanks!

Regards,

Jean-Pierre