Unable to find my cube in BEx that has a Non Cumulative Key Figure

[Former Member]

Hi all of you,

I have created a cube STOK_MVMT, which has a char StorLocation and a Non cumulative key figure Stock which has 2 cumulative key figures Inflow and Outflow.

For this Stock non cumulative key figure under Aggregation tab under the section Cumulative/Non-cumulative values I chose the radio button Ncum. Value with in- and out- flow and accordingly selected Inflow key figure for Inflow and Outflow key figure for outflow

The exception aggregation that got selected by default is Average (weighted with the number of days)

Now my problem is

I am unable to find this cube STOK_MVMT when I open my BEx to create reports. I am able to find 2 other cubes from the same info area but not this cube which has a Non Cumulative Key Figure.

I had selected the radio button Generate Initial Status under Update tab while creating the info package as I was dealing with the stock. So is it something got to do with this because earlier I always used to select only Full update when my cube had only cumulative key figures. Why is it so? Can any one please explain?

Thank you.

TR.

[Former Member · Accepted solution]

First of all check if the cube is active.

Second in BEX you choose create query? Otherwise you'll see only cube that already have query!

Hope it helps.

Regards