Skip to Content
avatar image
Former Member

WEBI not recognising BW variable which is set to not ready for input

Hello, I am sure this is a known issue, but I am very new to WEBI and thought I would just ask this question before I start reinventing the wheel.

I have a BW query with a customer exit variable which is set to be not ready for input - when the user runs the query the variable retrieves their user name and filters the results of the query accordingly - the user is only allowed to see their own data. The query works fine on its own or in applications built using the Web Application Designer. But, when I build a WEBI report on top of it, the variable is being ignored, bringing all users' data in. Are there any known solutions to this issue?

Note, I do not want my user to be asked any prompts when they run the report, so for that reason I can't have a ready for input variable. I have tried bringing all data into WEBI and filter using a WEBI variable, but this is not feasible as retrieving data for all the users takes a very long time, even with query data cached.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Sep 25, 2017 at 02:38 PM

    Let me just add that I am using this variable in the Default filters area of the BW query - wonder if that might be the reason why it's being ignored by WEBI, as, if I understand correctly, when variables are used like this, the BW query retrieves all data first and then applies a filter.

    To test this theory, I used another query where my variable is not sitting in the Defaults filters area, but rather in one of the key figures within a structure. It seems that WEBI might be reading it correctly when it loads query components into the Query panel - I suspect that because a text variable used in that key figure's description is correctly populated so the key figure must have been correctly filtered. However, when I try to refresh the query in the Query panel, I am getting the following error:

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 25, 2017 at 01:44 PM

    Hi Agata,

    Can you confirm you're using the SSO authentication mode at the connection level ?

    Regards,

    Frederic

    Add comment
    10|10000 characters needed characters exceeded