Set Dimension Hierarchy on EP


I need to write a query to set dimension hierarchy for Financial Dimensions.

These hierarchies are defined in the table DimensionSetCombination.

I have to use the method DataSetLookup at the dataset level.

Please let me know how to use a query in this case?

Thanks & Regards,