Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Currently I have multiple copies of my SAP BW query, at the moment splitting my data into annual chunks. I load 2010 from the 2010 query, then 2011, then 2012, etc. and Qlik Sense joins it all together neatly.
I am now looking at streamlining the process to avoid duplication of BW queries and am using WHERE {[0CALYEAR].[2010]} to load the data one year at a time, but I still have multiple copies of the MDX query in my Qlik Sense script.
Since the MDX doesn't change (apart from the year), is it possible to;
Thanks for any pointers.
Oh yes, it is!!!
For vYear = 2010 to 2015 //defines loop variable
Load
<Insert Load Script here, with definitions & MDX/query>
WHERE {[0CALYEAR].[$(vYear)]}; // This is where my variable is used
Next vYear // Loops round
Oh yes, it is!!!
For vYear = 2010 to 2015 //defines loop variable
Load
<Insert Load Script here, with definitions & MDX/query>
WHERE {[0CALYEAR].[$(vYear)]}; // This is where my variable is used
Next vYear // Loops round