Skip to Content
0
Former Member
May 19, 2011 at 07:28 AM

Xcelsius reset button / push button not working

34 Views

Hi

Please suggest on the use case scenario:

I've live office connections getting data in excel Sheet1. Sheet2 has forumales (serving what-if analysis) referenching Sheet1.

Dashboard shows sheet2 data.

Use Case: User Opens dashboard > Clicks on Connection Refresh Button to get latest data > Does What-if analysis using Slideres > Use Reset function that will reset the what-if and show the data that was brought back after connection was refreshed

I used Reset component but this resets the model to the stale excel data that resided in the underlying excel at the time the dashboard was developed and published

I also tried Push component, by mapping its source and destination, both, to sheet1 data but it does nothing (which I presume is because it only supports single-cell value insert?)

Please suggest on how this functionality can be achieved?

Thanks

Deep