Hi GUys
i have a daily cash flow having day and month grain which i started from Oct 1 2018.
I have another cube which is month expense allocation which before daily cash flow cube was my entry on the monthly level and the information is populated since Jan 2017.
i am designing a new solution and on the daily cube i created a load via cube view from my daily cube and it is ok.
created a second view by month from my allocation cube from jan 2017 to Sep 2018 to populate my new month cube.
is that possible now going forward via rule add all daily values from my month level (daily cube entry) to my new month cube > Sep 2018 ? i don't want to create each rule for each month.
Example.
Daily cube
Feeders;
['Service A','Actual']=>DB('Cube_Monthly Expenses Allocation','Services A',ELPAR('Dim_Date for Daily Cash Flow',!Dim_Date for Daily Cash Flow,1),'Actual');
Month cube
Rule
['Service A','Actual']=N:DB('Cube_Daily Entry for Cash Flow','Service A',!Time,'Actual');
Something like if Month >Sep 2018, populate month cube going forward otherwise, no change (mean values from historical cube doesn't change <=Sep 2018.
Kind Regards
i have seen some function but as my skill is still under development, i need some guidance.
There is an Index value for each element and in my case, my daily cube, the month index for Sep 2018 is 17 and for my month cube my index for Sep 2018 is 24. There are two time dimension, ( for daily, day and month as grain) and for month level another time dimension for Month and Year grain.
Another example on my model and that is the reason for my question.
Feeders; for daily cube.
['Service A','Sep 2018','Actual']=>DB('Cube_Monthly Expenses Allocation','Services A',ELPAR('Dim_Date for Daily Cash Flow',!Dim_Date for Daily Cash Flow,1),'Actual');
Rules on month cube
['Services A','Oct 2018','Actual']=N:DB('Cube_Daily Entry for Cash Flow','Car Services','Oct 2018','Actual');
------------------------------
Kleber Vieira
------------------------------
#PlanningAnalyticswithWatson