cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
NPPCTL Occasional Visitor
Occasional Visitor

SAP BW Apply Parameter to Measure

Good afternoon!

 

I am trying to filter my query to only retrieve rows from SAP BW with a measure value greater than 0. For example, if the query originally pulls:

  • 0units|1 red|springfield
  • 2units|1 red|California

I would only want the query to retrieve:

  • 2units|1 red|California

The dataset consists of over 2 million rows therefore the query must limit the data retrieved as opposed to filtering after retrieval. I have copied below the current query from Advanced Editor and bold and underlined the measure that I would want to apply the greater than 0 parameter. I would greatly appreciate support on this!

 

let
    Source = SapBusinessWarehouse.Cubes("Web URL", "___", "___", "__", [Implementation="2.0"]),
    SourceA = Source{[Name="SourceA"]}[Data],
    #"SourceA/SourceA_Transaction" = SourceA{[Id="SourceA/SourceA_Transaction"]}[Data],
    #"Added Items" = Cube.Transform(#"SourceA/SourceA_Transaction",
        {
            {Cube.ApplyParameter, "[YGTHH12]", {{"[0Column1].[1777]", "[0Column1].[1555]"}}},
            {Cube.AddMeasureColumn, "Measure1", "[Measures].[222222222]"},
            {Cube.AddMeasureColumn, "Measure2", "[Measures].[333333333]"},
            {Cube.AddAndExpandDimensionColumn, "[0Column1]", {"[0Column1].[LEVEL01]"}, {"Column1._____ Level 01"}},
            {Cube.AddAndExpandDimensionColumn, "[0Column2]", {"[0Column1].[LEVEL01]"}, {"Column2.___ Level 01"}}
        }),


    in
 _____

 

Thanks,

Tom