Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Loading 0CALYEAR to BPS Cube based on 0CALMONTH

Hi all,

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,


Former Member
Former Member replied

Try a characteristic relationship of type exit and use function module UPX_DATES_DERIVE. Make sure 0CALYEAR is not in the planning level.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question