weekly bex to monthly bex at quarter end

[Former Member]

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

[sateesh_kumar1]

Hi Santhu ,

It is not good practice to have multiple redundant cubes .

Is weekly cube and monthly cube holds different aggregated data ? If not use only one cube and load data based on event .A event which has to trigger every day and will call/Initiate process chain if it is Sunday or first day of next month else it will terminate.