Skip to Content
avatar image
Former Member

Can BICS not be loaded when dashboard is executed?

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jul 03, 2017 at 01:16 PM

    HI,

    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.

    -Abhilasha

    Add comment
    10|10000 characters needed characters exceeded