Dynamic tooltips using dimensional source (SSAS)

[LDJB81]

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?

[pricter]

You should use tha SPAN tag in HTML item.

For Example insert before an HTML item as

Code Select Expand

<SPAN Title= "your mouse over information">
and after another HTML item

Code Select Expand

</span>

[LDJB81]

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

[pricter]

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

Code Select Expand

<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

Code Select Expand

">

Then the title would be dynamic

[Rahul Ganguli]

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.