Custom Account Hierarchy Report
How to built the custom Hierarchy report through OBIEE, Please let me know any sample sql query is available.
Structure : ___________Corporate Account__________
____ACC_LEVE1________ACC_LEVE2____ ____ACC_LEVE3____ ____ACC_LEVE4____
All Account level should be available when drill down any of the account but when you click the ultimate Parent only Child and Grand Child level will be available, Please let me know how to achieve this requirement either OBIEE or OTBI.