Skip to Content
avatar image
Former Member

How to Suppress the whole report /data of the report based on user input

Hi,

I have a scenario where in i want to hide the whole report or suppress the data of the report based on particular user input from report prompt.

for example if user enter value Nebraska in user prompt at report level then report should not show any data.

There is data for that prompt input in the database but we wish to suppress the data in report if the user enters a particular input or hide the complete report tab.

Can

Please help.

Thanks,

Charu Thareja

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Sep 27, 2017 at 08:39 AM

    Hi,

    A whole report is not possible I think, but the content you can set to hide

    table properties:

    Hide when empty can do the trick for you but if you a little bit more complex data you can use formula as well

    I create a variable [number of hits] that is no more than a count on the dimension you have set as input control ready.

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 27, 2017 at 11:20 AM

    Building on what Koen has said, you can use “Hide when following formula is true” in your table properties mixed with the UserReponse function, which would look something like

    =UserResponse(“Select a State”)=“Nebraska”

    Change the string to match your prompt name and set whatever equality comparison you would like.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 28, 2017 at 06:40 AM

    Thanks so much for the response , yes it does work in Web intelligence ,however my report is very complex and lots of table and chart and I do not want to go and set this property for every object. The report is also not sectioned on anything.

    1. I am looking to hide either by creating a dummy section , if it is possible to make a dummy section and hide the section completely when the condition is true.Can we do this?

    2. Can we achieve this with the help of row level restriction at universe level.?

    I know hiding a whole report tab /page is not available in SAP BI as of now.

    Thanks,

    Charu

    Add comment
    10|10000 characters needed characters exceeded