I work in SAP BI and I am co-ordinating with a team working in Qlikview.
Currently a dashboard is being designed in inventory which is based on 0IC_C03 cube.
The cube uses non-cumulative keyfigure for stock quantity and value which doesn't get stored in the cube.
In order to avoid the dependency on marker updates in the cube, I suggested to compute stock value and qty based on the Receipt and Issue fields which is present in cube.
Citing performance and difficulty in handling deltas in Qlikview, I have been asked to store month-on-month Inventory stock value and qty in a DSO in BI for the last 2 years so that Qlikview team can use it to perform computation.
Since the data volume is huge, storing data in a DSO through APD is a tedious process. The APD fails to execute.
I would like to know what is the general practice followed by the Qlikview developers. Would storing the cube data in Qlikview and then performing the calculations in Qlikview be a better solution ? Since I don't know much about Qlikview, I am unable to comment on same.
I use the extraction partial, for example: i have data of 5 years ago, but i need extract only the current year, then it is possible whether you add the line: Slices( [filed_name].[value]), how you can see below.
