update rules.

[Former Member]

Hi Guys,

I am uploading the data from actual cube to plan cube using the update rules.

In actual headcount cube, the record is created for each time when the data is uploaded to the cube based on calendar day and BEx reports are prepared based on latest record using the exception desegregation. When I am loading the data to plan cube I just want to load latest record but not all the records. Please let me know how can I achieve this.

Thanks,

Raj.

[Former Member]

Will the delta option work?

[Former Member]

Hi Sandhya,

I don't think this can be achieved using Delta option. The data that I am planning to transfer is the data from HR actual cube. This actual cube is loaded every week and record type H for each employee is created for every load with that specific date. If I want to report head count for particular month, and I don't use exception desegregation(ED) with calday, I will get headcount as four for single employee so I am using ED for reports. But when I want to transfer this data for plan cube and use the headcount for each month , I just want one record to be transferred from actual's cube for the month which has latest value for that month.

Hope This helps to provide some ideas.

Sekhar

[Former Member]

Hi alessandro

I just want to get latest record for each calender month from actual cube to plan cube instead of getting the all the records of latest update.

[Former Member]

Raj,

when you load the infocube in your data_package you can delete all the records you don't want.

alessandro

[Former Member]

Raj,

in your update rule, in your start routine, loop at data_packake. for each record read the source cube with the function RSDRI_INFOPROV_READ.

if in the cube there is a date Great than the date of your data_package record delete the data_package

alessandro

[Former Member]

Will the delta option work?