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

[Former Member]

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

[Former Member]

solved by using selections

[former_member213877]

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:

Hope this helps you..!

-Pradnya

[Former Member]

Hello Pradnya.

Thanks for quick reply, actually i need to export the entire query to BO, i need some three years of data to analyse the things. but, variables present will not allow me to see all the three years data at same time. what i need is a query which displays the previous year, present year as well as current years data if we put variable as current year.

thanks

Prashanth

[Former Member]

correction: previous, present and future year if we choose current year in variable

[purvang_zinzuwadia]

hi,

why dont you change your variable to include all three years at same time

regards,

purvang

[Former Member]

Hi

Think of writing user exit to acheive the same

JP JP

[Former Member]

Thanks guys for your helpfull replies...

JP,

I would try user exit for bex variable to execute the previous and planned year data, when user enters current year. But, could you please letme know about writing user exits for bex variable. do u have any documents reagrding user exits.

[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