Open a link several consecutive times even if the trigger cell does not change

[Former Member]

Hello,

I have a chart that I want to use to drill down in a Webi report, and I want the user to be able to click on a single data point repeatedly and have the report open up every time. The scenario might be an executive talking in a presentation, clicks the chart to open a report, discusses the report and closes it, someone asks a question about the report, executive clicks the same data point in the chart (important: the executive has performed no other action or change in the dashboard since the first time he clicked the chart) and discusses the report again, closes the report, someone else asks about the report, executive becomes irritated but clicks the chart anyway to open the report again, etc.

I can set a URL button and a trigger cell and it works fine, but triggering the URL requires that the value in the cell change somehow. Otherwise any clicks on a data point beyond the first click, if the trigger cell hasn't changed its value, will produce no effect. Is there a way to make a link get triggered based solely on clicks, regardless of whether the value in the trigger cell changed or not?

Thanks.

[Former Member]

Here’s an idea . . .

Add a History control and map the destination to the same cell that you are using for the chart insertion.

When you click on the chart, the data is inserted into the destination (trigger) cell.  The History control then overwrites the data in the destination cell thereby “re-initializing” the destination (trigger) cell.

The trigger cell should contain the trigger value just long enough to trigger you URL button.

[Former Member]

The only way is to add a push button (make it invisible) on top of the data point where the user will click.

Use this tutorial in order to move the push button dynamically, to ensure that it's always on top of the right data point:

http://scn.sap.com/docs/DOC-43390

[Former Member]

Hi Alex,

Thanks for your post "[HOW TO] Dynamic Positioning of Objects in Xcelsius / Dashboards (In 2 easy steps!)". I am still wondering how it will work as your suggestion in this post. If I assume that we are using a scorecard component and inserting its position on excel to trigger URL, how can we move push button up an down and insert position using push button?

Please provide example, click on a single data point repeatedly(on any selector or chart component) will help a lot of users/developers.

Thanks in Advance

Kumar