Regarding 0CSAL_C09 SAP BW CRM complaints infocube

[arun_purohit]

Hi BW Experts,

I am having issue with this cube.

Number of items 0CRM_NUMOFI are not getting updated in infocube though they are updated in DSO records.

This key figure is getting 0 value for all records.

Standard ETL used-

0CSAL_C09 Complaints Infocube

0CRM_COM Complaints DSO

0CRM_COM2 CRM Complaints (Items, lean extraction)

0CRM_COMPLAINTS_I CRM Complaints Item

Start Routine of this cube:

*  ***** Rework necessary: *********

* No fully conversion of DATA_PACKAGE processing possible,

* adjust manually into:

* -> LOOP AT source_package ASSIGNING <source_fields>

* -> with preconfigured field symbol <source_fields> as structure

* for the error handling: We don't want that faulty data reaches the

* cubes

     DELETE SOURCE_PACKAGE WHERE statecsys2 = '10'.

Please advise if any manual changes are required in start routine.

Thanks.

[MGrob]

Hi

Check what the value for statecsys2 is . If it's '10' for your records it gets deleted. That might lead to your keyfigure being 0.

hope it helps

Martin

[arun_purohit]

HI Martin,

Records with statecsys2 = 10, won't be present in cube because they are already deleted in start routine- source package.

Still no record of cube has value as 1 ...

[MGrob]

Thats what I meant but if your keyfigure is matching this statecsys2 = 10 it will also be deleted.

[arun_purohit]

That record itself will be deleted, right.

So If I look into cube, there won't be any record in cube with

statecsys2 = 10.

Hence I should get some records in cube for which 0CRM_NUMOFI = 1.

[MGrob]

0CRM_NUMOFI is not a keyfigure though. But yes all other records <> 10 should be in the cube..

But if the keyfigures are 0 for all other records you won't get any data.

[arun_purohit]

Hi Martin,

do we need to make any manual change in routine....?

As I am getting correct values in DSO (<>10) but in cube its all 0

by the way plz refer attached screenshot

[RamanKorrapati]

Hi Arun,

Please check at DTP levels,is there any filters, if yes then accordingly you can cross check data  source dso or psa.

You may get some clue.

Thanks

[arun_purohit]

Hi Rama,

There are no filters on DTP...

[RamanKorrapati]

Hi Arun,

Rather than routine, you can go with filter and exclude statecsys2 = '10'.

it will work without any code.

As my guess your code may causing this issue. if you have abap expert take his help and get rid of this.

Thanks

[arun_purohit]

Hi Rama,

We tried debugging it and continuing to do so....

we got some hint but note sure on what needs to be done to rectify it....

issue seems to be with standard code of transformation.....

will try this --- <> 10 filter in DTP

is it a good idea to re-install the standard transformation or shall we raise OSS note for it....

[RamanKorrapati]

Hi,

Means start routine was part of your business content transformations?

other wise just comment start routine, try to play with filters easily you will get required data.

Thanks

[arun_purohit]

yes, its BI content routine...

commenting it won't help I guess..

[RamanKorrapati]

My mean if we use dtp with required filters at that time need comment that code.

Ex: statecsys2 = 1 to 45(avilable values)

You can enter ranges like statecsys2 = 1 to 9

                                                 statecsys2 = 11 to 45.

Its easy one. Try with dtp.

If your motto is just deleting records where statecsys2= 10, above dtp options are useful.

Thanks