BW Report requirement (Trend Analysis Report (Project Systems))

41 Views

Hello, BW experts

I need some help.

This requirement is for Trend Analysis Report (Project Systems)

I am loading data from ODS to Cube as a Delta Upload

ODS is getting data from R/3 data source as a full upload (no delta in the Datasource)

I added one custom field in the cube (0PS_C04) and that custom field (Date field) is going to pick current date (Sys date) through formula in the update rules.

When I am loading data from ODS to Cube, if the value is coming to the amount field, then the current date field is going to get the current date to the cube

If there is no record is updated in R/3, then delta is not going to update any record to the Cube.

If no record is updated to the cube to the particular project number, then Date field is not going to get any data from update rules.

But I need to see all dates in the cube even though there is no update in the R/3 for that project.

Example:

Proj---day1 2 3 4 5 6

-XYZ--- 10 5 -- 3 -- 2

In the report now I am able to see some thing like this

Project day1 2 4 6

XYZ 10 5 3 2

But I am expecting some thing like this

Project day1 2 3 4 5 6

XYZ 10 15 15 18 18 20

Can anyone please help me in this..

Any input is strongly appreciated

Thanks,

Rajesh