topic Re: How to take Delta for SAP BI Cube in QlikView

How to take Delta for SAP BI Cube

Sat, 14 Jan 2012 08:09:19 GMT

Dear Experts,

I am working on Qlikview project where my data is coming from SAP BI cube. I have done the extraction and modelling.

But i want to take daily delta from Fact table and Dimension tables of cube.

I can not take Full load b'coz its a Inventory cube where there are around 4 Cr. of data in E Fact table.

Plz suggest on this.

Any help will be greatly appreciated.

Regards,

Vaibhav.

How to take Delta for SAP BI Cube

disqr_rm — Sun, 15 Jan 2012 02:54:55 GMT

Hope this helps:

http://community.qlik.com/docs/DOC-1588

How to take Delta for SAP BI Cube

Thu, 19 Jan 2012 09:39:20 GMT

Hi,

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.

Help would be highly appreciable.

Regards,

Neha Tank

Re: How to take Delta for SAP BI Cube

Tue, 29 Jul 2014 17:23:08 GMT

Hi Vaibhav,

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.

[$0SD_C03]:

Load *;

Select PseudoMDX D (

Dimensions (

[0CALYEAR] (),

[0FISCPER] ()),

Slices (

[0CALYEAR].[2013]),

From ($0SD_C03));

i hope that this solve your problem.

Regards,

Alejandro Urrego.