display records of when no data

[Former Member]

Dear Experts,

Is it possible to display data when no data is applicable? For example, in a Bex query, it would show no data. How can it be possible to display the whole struture of chars and KF columns as in the case when there is data? That means, when there is no data, this is shown:

Char1 Char2 KF1 KF2

ABC DEF 0 0

or in this format

Char1 Char2 KF1 KF2

ABC DEF 'no data' 'no data'

Many thanks,

Suzie

[Former Member · Accepted solution]

Hi Suzie,

create a multicube on cube & infoobject & use char from infoobjects when creating queries.

hope it helps

regards

Vikash

[Former Member · Accepted solution]

Hi Gurus,

Am i right to say that only when All KF's of a cube are blank will the report not display such a record?

And as long as any of a cube's KFs has any value, the record will be shown even if some KFs are '0' where upon, that KF will be shown as it is, '0'.

Thanks,

Suzie

[Former Member · Accepted solution]

Hi Suzie,

The problem is that in a Cube you only find the records related to a transaction/movement (invoice, PO, ...). If the Master Data, for example Customer Fernando, has never bought something you will never find Fernando in your Cube.

A Cube only see what happens from the point of view of Transaction and Movement.

Ciao.

Riccardo.

[Former Member · Accepted solution]

Dear Gurus,

I went through the guides you provided. Very interesting but I'm still not sure to which result does your solution refer to :

Output Scenario A:

=====================

Char1 Char2 KF1 KF2

ABC DEF 0 0

or in this format

Output Scenario B:

====================

Char1 Char2 KF1 KF2

ABC DEF 'no data' 'no data'

Seems like by using master data, the suggested solution is to enable scenario B where KF is shown as Text. Can I say its possible because of constant selection?

Assuming scenario B, does it mean I must set for char1 and char2 in order display above?

Many thanks,

Suzie

[edwin_harpino]

hi Suzie,

check the scenario in this doc

'slow moving item'

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/11291595-0501-0010-c881-e02...

or

http://help.sap.com/saphelp_nw2004s/helpdata/en/3a/d1603d13b5c72ee10000000a114084/frameset.htm

hope this helps.

[Former Member]

Hi Suzie,

I think the only way to obtain this is to introduce in a Multicube the Cube and the Master Data (IO translated in an Inforovider) corresponding. Logically it is possible only if you have few Master Data to introduce in the query and in the Multicube.

If the different Master Data are related you can try to build an ODS feeded with the corresponding MD and ut this ODS in the Multicube.

Ciao.

Riccardo.