Show Star Schema of Cube in SAP BW

[Former Member]

Hello experts,

is ist possible in SAP BW to show the star schema of a Cube?

Thanx

Axel

[edwin_harpino · Accepted solution]

yes Axel, rsa1 then metadata repository,

click 'infocube' and find your infocube and click on it,

will come out the infocube info, click '...display as star schema'

hope this helps.

[Former Member · Accepted solution]

oh, these confusing SAP transactions rsa1 = AWB!

But there it is - fantastic !!

Full Points to you, Edwin.

Axel

[Former Member · Accepted solution]

Hello all,

if the link "display star schema" does not exist what must we do for displaying star schema ?

thank you in advance

[edwin_harpino]

hi Axel,

you can try display from metadata repository

rsa1-metadata repository, search your cube, and there is graphical display ...

to list related tables transaction LISTSCHEMA

hope this helps.

[Former Member]

Hi Edwin,

i am a newbe to SAP BW, so how do I access metadata repository? with /rsa1??

Axel

[Former Member]

Hi ,

Goto RSA1 -> in the left side you will find tabs like Modeling, Monitor etc, the last tab is meta data repository -> click it -> right side it will display the screen -> here select info cube it displays active cubes in your system find your info cube here under graphical display you will get 3 options select display as star schema.

[Former Member]

Hi,

There is one T.code Called LISTSCHEMA using this you can see the number of dimensions and tables in a cube.

Thanks