L00 and L01 in BW Query based Universe for Characteristics

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

Good explanation - Thanks