Skip to Content
0
Former Member
Dec 05, 2008 at 01:19 PM

How to filter on hierarchy nodes in DTP

898 Views

Hi all,

While loading DSO data to Cube InfoObject 0ORGUNIT will be handled. In the DTP I would like to filter 0ORGUNIT to a number of nodes of one of the hierarchies of 0ORGUNIT. I've seen a number of threads but none of them provides a complete solution. Is using a OLAP variable the best solution? Is it a variable of the type EXIT? How can the system determine which hierarchy should be used? Which OLAP variables does the system show when F4 is used in DTP?

Or is it better to take a routine as a filter in the DTP?

All tips are welcome.

Tnx in advance,

Henk.