Skip to Content
0
Former Member
Jan 14, 2012 at 11:57 AM

Data load between cubes using Request ID filter

504 Views

Hi All,

I have seen some threads on this but no one had posted a solution.

Now, I am stuck up with such an issue where only one request has to be loaded to a reporting cube.

The source cube is a history cube which loads all sales data everyday, but the request on the last reporting day is to be loaded to the next layer.

There is no option in the DTP filter to select this or any option to filter this in the start routine.

Using expert routine for this is complex and cannot confirm consistency too. Please let me know if anyone had come across this requirement before. Thanks in advance.

Gau