How can i run the same query as "paginated" with different parameters? If i run it for too many years, it returns an error from SAP BW about memory issues.
Below is a partial code from the query. I provide a parameter as "0CALYEAR" 2023
How can i run this query with year as parameter and then get the data for multiple year in the same query?
let
Source = SapBusinessWarehouse.Cubes("HIDDEN", "HIDDEN", "HIDDEN", "HIDDEN", [Implementation="2.0", LanguageCode="EN"]),
GFIARM03 = Source{[Name="GFIARM03"]}[Data],
#"GFIARM03/GFIAR_M03_Q0003" = GFIARM03{[Id="GFIARM03/GFIAR_M03_Q0003"]}[Data],
#"Added Items" = Cube.Transform(#"GFIARM03/GFIAR_M03_Q0003",
{
{Cube.ApplyParameter, "[!V000001]", {{"[0CALYEAR].[2023]"}}
I have looked at this blog, but he doesn't specify how he managed to do it, and the comments also show that others are struggling with the same.
https://businessintelligist.com/2018/03/24/how-to-overcome-sap-bw-memory-overflow-issue/
