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

Removing $ signs from query

Hi Gurus,

Just need some basin instructions on removing the $ signs from showing up in the resulting query run. Any help is appreciated.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 28, 2006 at 07:45 PM

    Hi Toja,

    Get into Query Properties, under display tab, you will have the options to discard that sign.

    Hope it helps,

    Thanks

    Rafi

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Toja,

      another alternative is this

      In ODS, there are records having a value BLANK/EMPTY for some of the fields. EX: Field: `Creation Date' and there is no value for some of the records.

      For the same, when I execute the query in Analyzer, the value `#' is displaying in place of `BLANK' value for DATE and other Characteristic fields. Here, I want to show it as `BLANK/SPACE' instead of `#'. How to do this?

      I had a similar problem and our client didn't want to see # signs in the report. And this is what I did. I created a marco in Workbook as SAPBEXonRefresh and run my code in Visual Basic editor. You can run same code in query also as when you will refresh query this # sign will be taken care. You can see similar code in SAP market place.

      I will still suggest not to take out # sign as this represent no value in DataMart. And this is SAP standard. I did convince my client for this and later they were OK with it.

      The codes are below:

      Sub SAPBEXonRefresh(queryID As String, resultArea As Range)

      If queryID = "SAPBEXq0001" Then

      resultArea.Select

      'Remove '#'

      Selection.Cells.Replace What:="#", Replacement:="", LookAt:=xlWhole, _ SearchOrder:=xlByRows, MatchCase:=False, MatchByte:=True

      'Remove 'Not assigned'

      Selection.Cells.Replace What:="Not assigned", Replacement:="", LookAt:=xlWhole, _ SearchOrder:=xlByRows, MatchCase:=False, MatchByte:=True

      End If

      ' Set focus back to top of results

      resultArea(1, 1).Select

      End Sub

      Source:

      http://sap-img.com/business/removing-hex-sign-in-analyzer-report.htm

      Hope It Helps

      Regards,

      Chris

  • Posted on Aug 28, 2006 at 04:58 PM

    Hi Toja,

    If you are <BW 3.5, this goes away when you set the scaling factors for the KF. You can do this in the query definition, or also in the workbook.

    Else you would need to create a new key figure (formula) using NO DIM() function.

    Hope this helps...

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Toja

      Easiet way to do this is ->

      Create a new calculated key figures on your original key figure (let's say it is Amount)-> In formula select NoDIm function and put Amount so that your formula looks like NODIM(Amount) -> Save it and use this key figure. Now this new ke figure will not show currencyt sign $. Hide your original key figure.

      Regards

      Pradip

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.