Skip to Content
0
Former Member
Mar 09, 2015 at 09:25 AM

weekly bex to monthly bex at quarter end

15 Views

Hi,

we a Webi report which is build on 7 bex queries. data in the cubes is loaded every week (on sunday).

webi is running fine and showing data if we run on monday because data is loaded on sunday. our problem is if user want to run report

at the end of the quarter. let us say Q1-2015(mar-15) ends on Tuesday(31st mar). two days data is not available as the data is loaded on

every sunday.

for this we have created a bex query which loads the date on month ending (31st mar). if user runs webi report on 1st april-15. webi report should

change the weekly bex to monthly bex.

how can I achieve this? if I change the bex query source from weekly to monthly bex. is it works. pls guide me its urgent requirement

thanks in advance