How to hide a row characteristics in query if this char. value is # ?

[Former Member]

You guys maybe know that InfoObject 0REVERSEDOC is used in BW to indicate if the record is canceled or deleted in R3. We would like to include this InfoObject in one of our row characteristics in a query to tell us if the record was canceled or deleted already on R3. This InfoObject has got three values:

"#"

"R"

"X"

We know that the value "R" means the record has been deleted on R3, and guess "#" means null value, and "X" means what?

When we run the query, find that this row characteristic (show as a column when running query) all show "#" for non canceled/deleted records which are ugly that we decide to hide this column data if the record is neither canceled nor deleted. How to do this?

Thanks

Message was edited by: Kevin Smith

[Former Member · Accepted solution]

Hai Kevin,

I am not sure if thats completely possible to display bank field. I guess SAP is correcting this in the next version with a service pack.

But there is an alternative for you. Instead of blank, you can display a dot(.). In a report, if the field(0REVERSEDOC) is empty, its by default filled up with #.

Include this in your update rules as formula for the object(0REVERSEDOC) you don't want # to appear.

IF( IS_INITIAL( /BI0/0REVERSEDOC ), '.', /BI0/0REVERSEDOC )

Hope this helps.

[Former Member · Accepted solution]

hi Visu,

There is no such IS_INITIAL in formula and the InfoObj. should be called REVERSEDOC other than /BI0/0REVERSEDOC. Eventually the correct syntax formula code is as below:

IF( REVERSEDOC = '#', '.', REVERSEDOC )

After change the update rule with the above code for REVERSEDOC, delete data from the cube and then reload the data, run query, but find the values of the REVERSEDOC still shows '#'!

Any idea?

Thanks

[former_member184494 · Accepted solution]

Kevin ,

you should be checking for reversedoc IS Initial and not reversedoc='#'.

the value is null in the tables and is shown as '#' in the query.

[Former Member · Accepted solution]

hi Arun,

We changed the formula to:

IF( REVERSEDOC = '', '', REVERSEDOC )

But query still show the reversedoc as #!

Any idea?

Thanks

[former_member184494]

Kevin ,

what vishno had proposed was exactly what you wanted ... show only cancelled or reversed documents and not show the '#' . If you could give a layout of the report as it comes right now and how you want it to be , it would be of help. Also give us your BW version and Patch levels.

Arun

[Former Member]

hi Arun,

We drag over the value "#" to the right frame and right click to select "exclue from selection", but get no data since all records in our system currently contains no canceled or deleted data that REVERSEDOC is always "#" and the restrict selection would restric the whole record to show up if we do this restrict selection for value "#", therefore both you and Vishno are not correct, sorry!

[Former Member]

Kevin,

Right click on 0REVERSEDOC column and Restrict.

Use 'R' & 'X' as Include values or

Use '#' as Exclude value.

Hope this helps...

[Former Member]

hi Vishno,

Your option does not work either since this will block all records show up when running the query if Use '#' as Exclude value.

We would get "No Applicable Data Found." when running the query.

Thanks

[Former Member]

Hi Kevin,

Try this. Goto the Query Designer -> Properties -> Display blank as ..

Bye

Dinesh

[Former Member]

hi Dinesh,

Recently you seem to answer my post wrong! In Query design property, there is no any "Display blank as ..." option!

Thanks