Skip to Content
author's profile photo Former Member
Former Member

Display of data in Bex?

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 29, 2007 at 12:10 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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.

  • author's profile photo Former Member
    Former Member
    Posted on Jun 29, 2007 at 12:07 PM

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

    Regards.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.