Opening a webi or .xlf file using drill option in graph

other Xcelsius - Crystal Dashboard Design
1

Hi ,
Is it possible to open a .xlf or webi report from a drill through option in the graph of xcelsius dashboard?

bluecarbon :india: (BOB member since 2008-11-08)

2

You can open a webI report or a .swf file by passing the value selected from the chart.
:+1:

SSM :india: (BOB member since 2009-09-23)

3

Wow!!!
Can you please elucidate the process.

bluecarbon :india: (BOB member since 2008-11-08)

4

Map cells in the excel sheet to insert the selected value from the chart by setting the drill down property of the chart.

Concatenate the selected value to the URL of the drill down dashboard (or use opendoc function which ever is apt) to pass the same to the drill down.

Put a URL button in the dashboard and point the URL to the cell in the excel sheet, where the complete URL is present.

Also set the trigger in the URL properties so that whenever the value is inserted, the URL should be triggered.

All the best :+1:

SSM :india: (BOB member since 2009-09-23)

5

Thanks…Let me try it out…

bluecarbon :india: (BOB member since 2008-11-08)

6

I tired this out and the webi opens successfully. But my prompt values are not passed :frowning: . The prompt values are passed when they are hardcoded but when they are referred to a cell they are not passed.

Example: &lsMId=1;2;3 work fine but ="…&lsM="&$B$5 doesn’t works. The value in $B$5 is 1;2;3

bluecarbon :india: (BOB member since 2008-11-08)

7

Have a look at this post:

Don’t know if it will help but the problem looked similar to yours.

debbie

Debbie :uk: (BOB member since 2005-03-01)

8

Thanks for the help and my dashboard links very well with my webi report.
But now i m facing another problem… The problem is I have a column bar chart and while drilling this chart a webi report is opened for that particular values. In order to achieve this i have used the trigger option in url button and have set the trigger when my chart’s drilled column value changes(ex:Jan,Feb…Dec) in the excel.
While clicking any month say Apr in the graph the webi report is opened for the month of Jan because this is set a default selection in the graph’s drill property. And when i click any other month in graph say Dec , the webi report is triggered for Apr ( this one is the last selected value). Like this my webi report is always triggered for the last selected value.
Please help me finding a solution for this…

Guys atleast help me how the trigger behavior works in the URL button

bluecarbon :india: (BOB member since 2008-11-08)

9

Can someone explain how “Trigger when value changes” works???

bluecarbon :india: (BOB member since 2008-11-08)

10

As far as I have experienced,

Triger on insert: the URL will be triggered if there is any insert of value in the cell(It will trigger even if tou select/click the same value again).
Trigger when value change: URL will be triggered only if there is any change in the inserted value.

Thanks,
SSM

SSM :india: (BOB member since 2009-09-23)

11

Thanks for responding…
Have you came across a problem like Trigger when the value changes in URL fetching the last selected value :frowning:

bluecarbon :india: (BOB member since 2008-11-08)

12

Can you please tell me, which cell you are pointing for triggering the URL?

Please use the URL cell itself, where the inserted value is getting concatenated with the URL, and check?

Thanks,
SSM
:+1:

SSM :india: (BOB member since 2009-09-23)

13

Hi,

If you are interested in drilling in Xcelsius, this might also suit your needs: Xcelsius Drillbar and DrillChart.

Regards,

Marton.Horvath :hungary: (BOB member since 2008-11-18)