Skip to Content
avatar image
Former Member

L00 and L01 in BW Query based Universe for Characteristics

Hi All,

While creating a universe based upon an SAP BW query, the BW characteristics seem to be doubled as dimensions, with one group markeded L00 and the other as L01.

Why are they doubled?

Is one "better" than the other?

For what purpose?

They key value in L00 returns "all" and L01 returms the key, but all attributes seem to be the same.

Thanks for your help,

John Hawk

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Jan 06, 2010 at 07:15 AM

    Hi,

    From an OLAP point of view a characteristic is like a dimension, that means that it contains all the members (level L01) and the All member that aggregates the characteristic members (level L00);

    These metadata are provied by SAP BW when using OLAP drivers.

    For a characteristic, the level L00 is not necessary unless you want to use the All member.

    On the other hand, the level L00 is significant for hierarchies, hierarchy varaibles and structures because it contains members.

    We provide an option for the universe generation and the universe update that allows to generate or not the level L00.

    This option is available since BOE XI3.1 SP2.

    In SP3, we improved the L00 generataion to only impacts the characteristics and not hierarchies and structures.

    So the recommendation for characteristics is to not use L00.

    Regards,

    Didier

    Add comment
    10|10000 characters needed characters exceeded