COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: LDJB81 on 27 Jul 2012 07:31:25 AM

Title: Dynamic tooltips using dimensional source (SSAS)
Post by: LDJB81 on 27 Jul 2012 07:31:25 AM
Hi

A client has a requirement where if they hover over a calculation measure on a report, a tooltip pops up displaying the numerator and denominator that make up the calculation.

In the report I have:

Measure 1 = tuple(Measure,Dimension1)
Measure 2 = tuple(Measure,Dimension2)
Measure 3 = tuple(Measure,Dimension3)

The calculation in the report is as follows:

tuple(Measure,Dimension1) / tuple(Measure,Dimension2) + tuple(Measure,Dimension3))

I would now like to display the numerator and denominator in a tooltip, any ideas?


Title: Re: Dynamic tooltips using dimensional source (SSAS)
Post by: pricter on 27 Jul 2012 07:46:15 AM
You should use tha SPAN tag in HTML item.

For Example insert before an HTML item as
<SPAN Title= "your mouse over information">
and after another HTML item
</span>
Title: Re: Dynamic tooltips using dimensional source (SSAS)
Post by: LDJB81 on 30 Jul 2012 03:43:27 AM
that isn't dynamic though? Thats just code for a normal tooltip.

I need to be able to return the value of the intersections in the cube
Title: Re: Dynamic tooltips using dimensional source (SSAS)
Post by: pricter on 30 Jul 2012 06:32:52 AM
If you play a little with HTML item you can make it dynamically.

For example if you use an HTML item with the following code
<SPAN Title= "

and the place an HTML item which its source would a data item ( you could do that on the properties of the HTML item)

and then HTML item with the following code
">

Then the title would be dynamic
Title: Re: Dynamic tooltips using dimensional source (SSAS)
Post by: Rahul Ganguli on 01 Aug 2012 02:18:50 AM
You have to use JavaScript for doing all these.
Charts are rendered as image map in Cognos, they have hotspots defined.

You have to make use of <Area> tag and traverse through the image map and set the tooltips accordingly.