Forum Discussion

AleksP's avatar
AleksP
Frequent Visitor
2 years ago

Data extract from BI Query date range not available

Hello Team, 

 

I have a BI query which in main variable filters has only one single selection of period. 

But I need to extract a range of periods. For Example last 12months .. and its not relevant to create 12 queries with different periods.
Is there any smarter solution on this?

 

 

 

let
Source = SapBusinessWarehouse.Cubes("****************", "11", "111", [Implementation="2.0"]),
123456 = Source{[Name="**************"]}[Data],
#"************************" = 123456{[Id="************************"]}[Data],
#"Added Items" = Cube.Transform(#"*******************************",
{
{Cube.ApplyParameter, "[!V000001]", {{"[0FISCPER].[A12023001]"}}},
{Cube.AddAndExpandDimensionColumn, "[0CALWEEK]", {"[0CALWEEK].[LEVEL01]"}, {"Cal Week/Year.Cal Week/Year Level 01"}},
{Cube.AddAndExpandDimensionColumn, "[0FISCPER]", {"[0FISCPER].[LEVEL01]"}, {"Fisc Period/Year.Fisc Period/Year Level 01"}},
{Cube.AddAndExpandDimensionColumn, "[0MATERIAL__ZPRODH2]", {"[0MATERIAL__ZPRODH2].[LEVEL01]"}, {"Category.Category Level 01"}},
{Cube.AddMeasureColumn, "GR #(cr)#(lf)Pallets", "[Measures].[4HQA6L7D8VFRHSJ883BZ88U1M]"}
})
in
#"Added Items"

 

 

 


 

1 Reply