Skip to Content
0
Former Member
Apr 05, 2011 at 10:23 AM

Adhoc DTP filter

59 Views

Hi all,

I have searched the forum and cannot find a straight answer to this so decided to post the question.

In BW 3.5 to copy a request in a cube to another cube, I would create an AdHoc InfoPackage and put in the specific calendar day used to select a request and it would copy over no problem providing the transfer rules etc were all set up.

We have now upgraded to BI 7.0 and to copy from one cube to another I have to create the transfer rules, and a DTP.

However, the filter on the DTP doesn't seem to be variable.

The reaosn for needing this, we may get a call to copy a certain calday to an archive cube as it gets deleted from the original cube after two weeks.

Does anyone know of a way of achieving this, points will be awarded with gratitude.

Thanks,

Shane.