Hi,You can use the below two FMsDATE_GET_WEEKThis function module returns the week for the date passed.WEEK_GET_FIRST_DAYThis function module returns the first day of the week passed. (This is always a Monday, regardless of whether it is a working da...
Are the date fields mapped to the infosource? What is the source of your infosource? As everybody is saying you cannot have the date fields blank. Maybe you should create a separate transformation for your historical load where you put DATEFROM as to...
Then you cannot put a global filter (char restriction) in the query. As 0CALDAY is not present in the budget cube it returns no data. You need use a dummy KF for getting the date in the selection screen. Choose any one KF from your inventory cube and...
For time dependent MD you have to have the date fields filled. You cannot leave them blank. Maybe you can put some constant values for the first time load.