Skip to Content

We had a requirement where prompt value should be displayed to the users based on their access. For ex: If user has access to 1, 2, and 3, then he should see only those in the prompt values.

 

This is not achievable in Web Intelligence report as the prompt value gets data from master or transaction posted data.

 

To overcome this issue we have introduced Xcelsius to perform the task.

 

Step 1: Create a BEx query and have the characteristic in the row for which prompt should be created.

Step 2: Restrict the query based on Authorization variable

 

Note: we need at least one key figure in the columns.

1

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Step 3: Create a Netweaver connection in Xcelsius dashboard and connect the BEx query.

Step 4: Store the data which is coming out of query and make it available in the combo box.

Step 5: Add a URL button, and assign the row A6 of Final URL sheet.

 

Concatenation formula is written in A6 to join A2, B1, B2, C2, D2, E2, F2, and G2. It will generate the required URL and will pass the value to Web Intelligence report prompt.

 

When user selects the value from combo box, selected value is getting stored in B2 of Final URL sheet.

  2

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Note: B1 is the definition of prompt which is available in Web Intelligence report, it should be as same as Web Intelligence report prompt as shown below.

 3

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Step 6: Created an iView in SAP Enterprise Portal for the Xcelsius dashboard

 

Values are getting populated in the combo box from SAP BEx Query for which the user has access.

 4

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Select the value from combo box and click on Submit button

 5

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Once you hit the Submit button, it will open the Web Intelligence report in a separate window and it will start refreshing for the selected value.

 6

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Now you have the Web Intelligence report refreshed for selected value which is passed from dashboard to Web Intelligence report prompt

 7

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Web Intelligence report prompt screen with the values passed from dashboard.

 8

To report this post you need to login first.

5 Comments

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

  1. Ingo Hilgefort
    Hi,

    here your comment:

    ———————————————
    We had a requirement where prompt value should be displayed to the users based on their access. For ex: If user has access to 1, 2, and 3, then he should see only those in the prompt values.

    This is not achievable in Web Intelligence report as the prompt value gets data from master or transaction posted data
    ———————————————

    Sorry to say but that statement is wrong.

    Web Intelligence does support Authorization Variables and you can also configure Authorization Variables to be “Ready for Input” which is exactly what you were looking for and there is no need for adding a Xcelsius Dashboard for prompting.

    regards
    Ingo Hilgefort

    (0) 
      1. Ingo Hilgefort
        Hi,
        authorization variables are part of the BEx query design and Web Intelligence will then simply leverage it as part of the underlying BEx query

        Ingo

        (0) 
    1. Muiz Ahmed Chinghani Post author
      Hi Ingo,

      Thanks for your valuable comments.

      When we use authorization variable and by disabling “Ready for Input”, it will get us the results for all the values which user has access.

      But we wanted to show those values in “List Of Values” to user for which he has access to, so that user can choose the value to execute the BusinessObjects Web Intelligence report.

      Please let us know if we have any other option to acheive this requirement.

      Thanks in advance,
      Muiz Ahmed

      (0) 
      1. Ingo Hilgefort
        Hi,

        if you configure the authorization variable as “ready for input” the authorization variable automatically becomes a prompt for the Web Intelligence report with the list of values based on the data level security and the user can select the value that he would like to see.

        regards
        Ingo Hilgefort

        (0) 

Leave a Reply