Skip to Content
avatar image
Former Member

Actual Date for BO reports

Hi, we have deployed our BI system and an upper BO layer for reporting. We created some universes based on InfoCubes to test the integration kit, but we cannot figure out how to get an actual date value for filtering while reporting.

Has anyone experienced this before ?

The thing is that if we want to get data for this and last year we cannot do it because the universe cannot be edited in BO and therefore it cannot be calculated.

Any suggestion will be very welcomed !

Regards,

Santiago

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Sep 18, 2008 at 01:40 PM

    You can solve this by creating a query with data for this and last year. BO is able to translate the variable if you use this for this query into a prompt.

    Kind regards,

    Luc

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      If you want to define Universes on InfoCube level, you will not be able to use some nice BW-OLAP features like currency and unit conversions, restricted and calculated key figures, exception aggregation, ...

      So I would say, if you want to use this, you have to create one "big" query once, which could serve as a basis for the universe.

      Luc