Display of data in Bex?

[Former Member]

Expert's,

This is related to the display of the data.In Bex after execution of the query for some query we are getting' 0 ' and in some queries we are getting '$0'.This is very strange.Can any of u people suggest the reason?

Points will be definitely awarded for the right answers.

Thanks,

Vasu.

[Former Member · Accepted solution]

Vasu,

This is related to currency. Display with no $ means, they might be a NODIM() function used in those queries. Well in queries where $ is being displayed they might have no used NODIM() function. Just go to display mode of the query and check it.

[Former Member · Accepted solution]

Thanks,

But I am no where using the fucntion NODIM.Actually I have written one formula which will make the blank field as a ' 0 '.But the data which is coming from cube as ' 0 ' is displaying correctly like' $0'.Hope I am clear with this details.

[Former Member · Accepted solution]

Hello ,

In the query properties go to display tab , there you have a option called display scaling factors for key figures, if you tick that option then you will not get $ symbol being displayed , in your case infew queries that is being checked and in few queries that is not being checked.

hope it is clear

assign points if useful

[Former Member · Accepted solution]

Thanks Karthik,

I checked that inspite of that also I am getting $ symbol.

But I should not get $ symbol for the ' 0 ' but I should get the $ for other than ' 0 '.

[edwin_harpino · Accepted solution]

hi Vasu,

are they same key figures ?

if different key figure, both has currency unit ?

check the infoobjects, RSD2, both has currency unit ? or fix ?

hope this helps.

[Former Member · Accepted solution]

Hi,

Are you any sort subtraction formulas in the report where you are getting sign for 0.

With rgds,

Anil Kumar Sharma .P

[Former Member · Accepted solution]

No Anil,Formula just makes that field as a '0' whenever there is a blank.Ie I am using a formula to get this.It goes like this NOERR ( 'X1' * 1 )where X1 is structure.Hope I am clear.For the '0' which I am getting from cube the $ symbol appears automatically.But for this forced manipulation of the blank to the '0' I am not getting $ symbol.

[Former Member]

If it is for same key figure, check if NODIM is used in the query definition for the key figure ..

Regards.