Skip to Content
avatar image
Former Member

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,

Ralph

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Jun 01, 2006 at 02:46 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 23, 2006 at 09:48 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded