Delete values for 0CALMONTH in QDesigner

[Former Member]

Hi gurus..

I have a trouble in my Query designer.

When i try to select the values for 0CALMONTH, this show me a lot of values that i was load data for this cube.

I want to delete some values for this screen (for example 01.0000 or 02.0000), this items come from a wrong load data that i delete from the cube.

What´s the way for delete completly this kind of values?

Can you help us with this?

TY ...

Neo

[Former Member]

Hi Anil, I cann´t find the menu option in the Specific settings for the Infocube.

Can you help me again, please¿?

best regards

Message was edited by:

Neo

[Former Member]

are in 7.0 or 3.x?

[Former Member]

hi .. is BW 3.5 ..

Thanks

[Former Member]

do you know something about this topic??

[Former Member]

TY Anil, but i don know where is the Specific settings for the Infocube... explain me please...

[Former Member]

Hi,

I think,in BIW version < 7, you can find this setting in Edit screen of Infocube as part of one menu option(I guess that is <i>EXTRAS</i>).

In case of version 7,Double click on your Info cube on which you have this query, Right click on <i>Dimensions</i>,select<i> Provider-specific Infoobject Properties</i>.

with rgds,

Anil Kumar Sharma .P

[Former Member]

Thanks for both .. but i can confirm you that in the properties for CALMONTH we have setting that only show values in the infocube ...

Do you have another idea?

TY

[Former Member]

Hi,

Make this setting at infocube as I mentioned earlier.

With rhds,

Anil Kumar Sharma .P

[Former Member]

you can restrict the selection values at the char level too, go to the chat maintenance - bex tab -- query filter value selection - select only values in infoprovider.

this setting would restrict only values that are present in the cube rather than showing everything present in the master data table.

[Former Member]

Hi,

you can set this property in the <i>Info provider specific settings</i>.I.e you will set the F4 functionality to read from the infocube .So that it will shoe you only values for which there are entries in Info cube.

Refer <i>Structure-Specific Properties of the InfoObject</i>in the below link:

http://help.sap.com/saphelp_nw2004s/helpdata/en/80/1a644ce07211d2acb80000e829fbfe/frameset.htm

With rgds,

Anil Kumar Sharma .P

Message was edited by:

Anil Kumar Sharma