infoset and non-cumulative KF

[Former Member]

Hi,

I need to create an infoset between the 0IC_C03 and DSO ZZEKBE ( DSO is getting filled using the generic datasource over EKBE).

Now BI does not permit me to add a non-cumulative cube in an infoset.

But my requirement is to display for every material number in the 0IC_C03 cube, i need to find the matching entries with my DSO for that material number, and display the data in one single row. I am in SAP BI 7.3. Any ideas?

[former_member184494]

Actually - you can do this with a multiprovider ...

EKBE will have a line for every GR and IR and can be distinguished with the GR/IR Indicator.

0IC_C03 will have a reference document which will be the PO number in this case and Reference Item.

In the multiprovider - map the PO number and item from zzekbe to reference document and item in 0ic_c03 - you should get your match. You need not essentially do it using an infoset.

In the query - remove all lines which have a # so that material movements not tagged to a PO are removed.

[praneeth_nagalla]

Hello,

We cannot create Infoset with non-cumulative cubes.

Please see the below link.

http://help.sap.com/saphelp_nw73ehp1/helpdata/en/4a/0c090179291b42e10000000a42189c/frameset.htm

[Former Member]

Yes you are right. is there any work around for my requirement?

[Former Member]

pls confirm how u resolved this

[Former Member]

Hi,

Check this thread ::

http://scn.sap.com/thread/2096582

And also Note 1118492 - BW InfoSet: Using non-cumulative cube in InfoSet

BR,

Arpit

[Former Member]

i am really sorry harsha sai, the requirement was later droped and hence i did not proceed further.

[Former Member]

Any ideas gurus?