Skip to Content

Can BICS not be loaded when dashboard is executed?

Jun 20, 2017 at 03:48 AM


avatar image
Former Member

Dear Gurus,

I have a dashboard using several BICS datasources, hence with about 10 mandatory variables to input when dashboard is executed.

Now I want to add another BICS datasource, while this bex query should be loaded only when users press the specific button. So while the dashboard is executed, this new one's variables should not be shown. In fact, I want this new query read cells inside the dashboard, so it should not appear in the variable.

Is there anyway to do this?? Please help. Thanks in advance.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Jul 03, 2017 at 01:16 PM


I believe that you have set the 10 bex queries to refresh before components are loaded.

But for the other bex query you could add a toggle button and map it to a cell. So when you press it, it will insert 0,1.
And this cell will again be mapped to the refresh on trigger. Select when value changes. So whenever the button is pressed the query will refresh.

And for prompt, you can map it to a certain cell in excel instead of using the query prompt selector.


10 |10000 characters needed characters left characters exceeded