Skip to Content
author's profile photo Former Member
Former Member

one quary, one workbook need to refresh 3 times in same place?

Hello Experts,

I am a new entry into BI world. I have a requirement from client . Here we have a quary, which feeds data to BO. The problem is we are refreshing the quary 3 times with different variable settings to get the exact data which needs to be proceesed furthur. Is there any chance so that the quary refershes 3 times and displays data in same work book across. Please do help me. Points will be assigned for any small clues.

thanks

Prashanth

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Aug 07, 2009 at 04:38 AM

    Hi Prashanth,

    Is it really required to refresh the query thrice to get the correct data?

    Anyways, you can write a macro to achieve the same.

    Refer to this thread for the same:

    bex-query-refresh-macro

    Hope this helps you..!

    -Pradnya

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi ,

      I didn't get how user exit will help for this.

      user exit variable value will be the value calculated by the user using abap code. Generally people will calculate it based on user input for another variable or system date or some lookups & FMs.

      so i don't understand how it is going to help for ur requirement.

      I am not sure.. may be i am missing some way of doing it.

      In EHP1 sap has provided the option to refresh individual queries in the workbook.

      Document says

      "Refresh individual queries within a workbook -

      A single DataProvider refresh is possible, vs. a global refresh of all the

      queries in the workbook"

      refer the link -

      https://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/8025072f-8f55-2b10-16ae-fa8d1162ad0f

      create 3 views on the query and try to refresh them seperatly by keeping those 3 views in workbook.

      I didn't check how this works on views but it might help.

      Other way is change your query to accept multiple years as input.

      or read single year and offset on that to get all three years

      and get the result of the query at a single place(in one analysis grid)in the workbook.

      regards,

      Raghu

  • author's profile photo Former Member
    Former Member
    Posted on Sep 08, 2009 at 11:16 PM

    solved by using selections

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.