cancel
Showing results for 
Search instead for 
Did you mean: 

Loading 0CALYEAR to BPS Cube based on 0CALMONTH

Former Member
0 Kudos

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,

Ralph

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Ralh,

I think you can use the Tab Characteristic Rel. in Planning Area definition.

Here you can use Attributes, Exits, Reference Data, Hier.

Ciao.

Riccardo.