Current position:  Home > Default > RETRIEVE LOWEST LEVEL OF HIERARCHY (OMB+)

RETRIEVE LOWEST LEVEL OF HIERARCHY (OMB+)

Time:November 30
Advertisement
Hi all,
How can I get the name of lowest level in the primary hierarchy of a dimension through OMB+?
OMBRETRIEVE DIMENSION_TABLE 'SALES_REP' GET LEVELS
gives me following result:
LOCATION COUNTRY EMPLOYEE REGION DEPARTMENT
while the original hierarchy is like
REGION COUNTRY LOCATION DEPARTMENT EMPLOYEE
how can i retrieve 'EMPLOYEE' level?
regards,
Zahid Naseer
Advertisement
Hello Zahid,
You have to specify which hierarchy to use to get levels sorted top to bottom, eg:
OMBRETRIEVE DIMENSION_TABLE 'SALES_REP' HIERARCHY 'MY_HIER' GET LEVELS
will probably give you the expected result.
Regards, Hans Henrik