Loading 0CALYEAR to BPS Cube based on 0CALMONTH
How can I ensure that 0CALYEAR is also loaded to the cube (based on the values that are enterred for 0CALMONTH)?, without having to provide the user with an extra field to fill in the calander year.
I have built a planning cube, levels, packages and layout. In this layout users can fill in planning data per 0CALMONTH. I have built a query on top of the BPS cube and want to filter on 0CALYEAR. However, this value is not filled in the BPS Cube.
Thanks in advance,
Try a characteristic relationship of type exit and use function module UPX_DATES_DERIVE. Make sure 0CALYEAR is not in the planning level.