cancel
Showing results for 
Search instead for 
Did you mean: 

Obtain content of a cell in a crosstab

Former Member
0 Kudos

Post Author: konanking

CA Forum: WebIntelligence Reporting

Hi Friends,

Is there some way to obtain the value of a particular cell in a crosstab using a function or some other means while the report is being rendered. We have a particular requirement where in we need to pass the value of a particular cell as a parameter to the linked report.

So for instance if cell (row:1, column:1) has the specific value, how can that value be obtained to pass to the linked report.

Any suggestions would be appreciated.

Thanks, Saikat

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Post Author: amr_foci

CA Forum: WebIntelligence Reporting

look fo "where" operator in Webi

lets say u r dividing "Amout" measure in tow different Dimension "ID" ,"Year"

if you want a specific value of "Amount"

you can say "[Amount] where ([ID]=10 and [Year]=2008)"

just look for "where" and you will get help

good luck

Former Member
0 Kudos

Post Author: PrabhatKumar

CA Forum: WebIntelligence Reporting

1. You can do this by using some javascript/vbscript.

2. Create one free independent cell , have its properties to READ AS HTML, get its border white, text white and background white....Insert the javascript to run the Scripts hidden in it. In the CrossTab create OnMouseOver Event on Cells.

Example

3. You can directly write ="<a href="http://....../businessobjects..../OpenDocument.jsp?parameters"&#91;Value&#93;">"&#91;Value&#93;"</a>" as the cell content to directly have the value passed to the target report.

Prabhat