Skip to Content
0
Former Member
Sep 10, 2007 at 10:51 AM

Update rule in an Infocube

16 Views

Hello,

The data flow for Opportunity planning from CRM to BW is as follows:

CRM -> Transactional Cube (TC) -> Reporting Cube (RC)

A key figure (NetValue) is wrongly loaded/computed from CRM into TC. We have not been able to pinpoint why/where the wrong computation happens before it is loaded in TC. This data subsequently moves in RC, giving wrong info in the reports.

As a temporary workaround, i want to COMPUTE the NetValue in update rule of RC instead of directly mapping from TC. All the key figures of formula are available in the RC.

This is how data looks in the RC.

HdrGuid ItemGuid HdrQty ItemQty Price NetValue

XXXXX 11111 --> HDR REC

XXXXX YYYYY 99999 99999 --> ITEM REC

XXXXX ZZZZZ 99999 99999 --> ITEM REC

The formula for computation of NetValue for a given record is :

NetValue = HdrQty * ItemQty * Price

NetValue is to be computed for records where ItemGuid is not NULL (ITEM REC).

What is the problem then : In the update rule of KF - NetValue, the communication structure of ITEM REC will have KF's ItemQty, Price but no HdrQty. So, how do i retrieve the HdrQty (11111) for the item level records.

Thanks for your answers,

Nagendra.