Skip to Content
Technical Articles

SAP Analytics Cloud – Using BW Variables as Story Filter

For those of you that use SAP Analytics Cloud in combination BW queries, you might be familiar with the scenario, that your BW query has variables, and that the user is getting prompted to provide input values to those variables.

If so, I am sure you are familiar with the screen similar to the one shown below.

 

The user has the option then to provide the values to the variables. After the user has filled those variables with values, the option for the user to change the values typically would mean to re-prompt for the values and it might not always be exactly what you are looking for as user experience.

In addition to the re-prompting, you now also have the option to re-use your existing variables in form of Story Filters.

The Story Designer can simply create a new story filter…

.. and as part of this process the story designer can now simply choose, which variable would be exposed as story filter.

After configuring it, the consumer of the story, can simply click on the Story Filter and will receive the exact same UI that the user already knows from the variable prompting screen and can configure the variable values without the need to “re-prompt” in form of a popup screen.

8 Comments
You must be Logged on to comment or reply to a post.
  •  

    Hi Ingo,

    in general I like this new feature and it’s works as it should in our test stories.

    At least if there is only one modell in the story. What about the case if you have several live models in one story? Then it would be nice, if there is the same variable in those models, to merge the prompts for this variable. Then the whole story can be filtered with the enter of the value in just one variable and not into the variable for every model.

    Or do i miss something?

     

    Regards

    Kjell

    • Hello Kjell,

      If you have multiple models in the same story which uses the same variables, you can actually link those variables and then you need to have just one story filter for one variable.

       

      • Hi Akash,

         

        I also entered a question on this topic and got the answer there. I just did not see this point or just searched in the wrong area.

         

        Merging prompts works very well.

         

        Regards

        Kjell

  • Hi Ingo,

    This option not available in BW(import) connection to SAC currently. Is there any possible ideal way to get Bex variables to SAC in import connection?

    Thanks,