Forum Discussion

ljilibert's avatar
ljilibert
Frequent Visitor
10 years ago

How to have bracket for negative values from SAP BW Queries

Hi All, When I load my SAP BW Queries in PowerBI, I loose the bracket for negative values. In my PowerBI source, I have no negative values but have some in SAP BW queries. Can people help me to loa...
petergmk's avatar
petergmk
Regular Visitor
10 years ago

Hi Lydia,

 

I experince the same issue with the negative signs (-) in BW (BEx) queries become lost when imported into Power BI, though the negative values appear intact when viewed in Excel. The signage is needed to aggregate values of multiple records extracted from BW correctly during report run time so it cannot be determined and formatted beforehand, as there is no way we can tell when the values should be negative or positive. The issue can stop potential customers on BW from considering and leveraging Power BI for reporting and analysis purposes. Is there a way to bring this up to the development team if it is a real bug?

 

Thank you.

 

Regards,

Peter

tristanstcyr's avatar
tristanstcyr
Icon for Helper I rankHelper I
10 years ago

Hi,

 

Measure values should be returned as numbers. What query are you using for importing the data? You can find this by going:

- PBI Desktop > Ribbon > Edit Queries

- Query Editor > View > Advanced Editor.

 

Thanks,

Tristan

  • ljilibert's avatar
    ljilibert
    Frequent Visitor
    10 years ago

    Hi,

     

    When using BW queries, advanced editor is containing source code as followed:

    let
        Source = SapBusinessWarehouse.Cubes("", "", "", [LanguageCode="EN"]),
        DPA19MCR = Source{[Name="src_name"]}[Data],
        #"query_name" = src_name{[Id="src_name/query_name"]}[Data],
        #"Added Items" = Cube.Transform(#"query_name", {{Cube.AddMeasureColumn, "field_measure", "[Measures].[00O2TIJFJX0OAX63QWHX6DAJ2]"}}

    in

    #

     

    So we can't specify the type of our measure. Data are arriving in "near real" number format and we are forced to change type as decimal number for being able to work with.