BI Publisher (MOSC)

MOSC Banner

How to Display data in tree format

edited May 29, 2012 5:40AM in BI Publisher (MOSC) 2 commentsAnswered

Hi Friends,
I am working on a wired client requirement on BI Publisher report.  I am supposed to come up with a BIP report which should display the data in a tree format.  For example, if there is a region hierarchy (which has Region --> Country --> Division --> Market --> Office), I have to show the data in a hierarchical manner.

The below screenshot (which was taken from a simillar OBIEE report) depicts my actual requirement. 
KB5gf27QKB5gf27QKB767Ecglgz0/SlBo3h4YOSTGjSKB9ifGzSKhxz2W36xHorT5gdgv4f/2//lX18QiHtG0LlMAE4A9oP78j97lYCNkNG3KgAAAABJRU5ErkJggg==" loading="lazy" srcset="https://community.oracle.com/cdn-cgi/image/quality=80,format=auto,fit=scale-down,height=300,width=300/moscdenied:data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAP8AAAFfCAIAAAAOAY3HAAAVmklEQVR4nO2dPY7kOBJG6yBr7iXKrLrWeIvGnCCt9ecac4Q2x2mgnDHGWCzaLJNr5LRWzfhhkEFJEdT3EGioKIpSkk8UU1SqXwrht98/aCIA6/FCk2A/uAmwH9wX2A/uC+wH9wX2g/sC+8F9gf3gvrTtf/z7gUAsGSb7P//zCyJUoFGm1B7sTxlolCm1B/tTBhplSu3B/pQRrVFeXl5eXl4siREC9ueO/7ffz0wpfKAo2I84Lyr76fLJAfsR54XFfvaaQBOlFKVwvRDjJlLiqbUH+zNG0/6mzZZsUoF084FyzpeeqT3YnzGa4/4Xwqdsv5LNUji7CV1gN7nkHID9uYP2/ayg1VaS/Uo26qguOpsoKX7VCQD7c0fXyGeLAfv1P532K8dwUu3B/ozB2v8pd9vNvnyfqNuvbMKWbNnkstqD/RkDjTKl9mB/ykCjTKk92J8y0ChTag/2pww0ypTag/0pY6BRLvl+GTNG7Ge/16MBLomBRolT+ewBn3kLaNz+aFV5zxholHOabOwkPFmtyfY3z+YXwxS6vRtDGGe7etfqjai0dRXKWnaVdJyH157ffnZZT7Rvgmi0n2DtFmz16muVTbraSNljdcBp7KcV/UJo1ibsn9Z+qkN6i9jbS29rPdgSlB2d0PSuvr86PvZwYf9J7WeuyYHKl+w3HuSAGL278Nbe3JGP8UNGqILUEdx+JVuEpvfazx7xhpQorVXqBdFoP67muypf98/SrPuwNFzzgM+rPbv9wwGVpwemIKfU3oH2n3k23y1g/5Taw5MOKQONMqX2YH/KQKNMqT3YnzLQKFNqD/anjEPf5bZ8wP7cgUcP59Qe7M8YvZMw0lop59oB+3OHxX6ayNp/H+mZ2oP9GeOgN5pc/rnOrj3YnzGa9ncNcu52Aoj2//cf/0SkDsl4eoZUAfthf/qobJZ6ejbb5V7CfoQr9Ia/leWw/3YB+2H/feNyt+KH1f6C/6s9fFRNdvnxJAqT/fSuKLiWfaPQJgM6W+3B/pTAfg+wPzew38OI/V9+/UUKfWcvLy/bv2AKsN/DoP2fn9/Lj/j88S+1/3lbbf9ngf1TiWb/Nl9W/VmZQLeSSmBT6CqawXIMbvvLJ+y/kFD207aW1lbpe1Or/HqZyt7ZMisG7S/lk0ZlP9097J9OFvsV9QunCruJ/eohlVkx3ve/v73ug/b9sP8EUtsvGcIuGzt+dkEaOw3a//37XzRg//mEsr8Iquljnn3+4bGTUqZSwqD9f/35QWNv/wuhwP4DiGb/hn28Xgx9v16OfmFREgft//j2dR9/fPv68e1rZT/dK+yfTkz7eyVW7GeLMl5YmpmPut8P+88hmv10vNFl/1ZCM0UpzVLmE8z15iaa/Rb83d+sDhT25yad/XHUL7A/O+nsD0Wf/YjIUTXZ5ceTKND3p+SBvt/BAyOf1MB+D7A/N7Dfw7H2D/8SIBrSLerL5y5gv4fD7W/+EkB/MONQ2FmV0jNBY5nD7/10XZUA+y1cM9u1t//5HChrf2+xs5DsZ3OyKfYnWLqOyp4Z9jeZ/KSDnf0vAd7fXtlfAjTnvQtRrTqV2c7V0t3SwqUdSSnSISmfjs1clWm/UMD+Jlfa3/wlAGtYdbjNtc0UFt1++46U3bFnplKsfsAU2N/kSvu3p//f317ZXwLo/aWulyKlrl1VVLUwYL+0O73vp+e2tIkE7G9ypf3b0//vb6/SLwGahztgv+XwJtrf3IVy/Nty18E/gf1NrrS/95cA7OF67KeKN3c9d+TT/HTKXtgS9sD+Jlfab/klAB020LFB9XmUzGweWoiSopQsHRjdXdenYw9eOsg9sN+C1DorzPXqfvRmiwbsP4672L+k+gX2+1jB/jsD+z3A/tzAfg/X2M9+BQEDwH4PZ9jfvPeipwMF2O8hkP1gANjv4XD76X1rer9cv3cu3awFBfb7uMb+/doqXbEcJwAF9nu43v5qWZ8uHTiAtYH9Ho61/4VQOu3HFwYd2O/hcPvpn7B/IrDfQzj7i+0hNvAE9nvAXG9uYL8H2J8b2O8B9ucG9nvosx8ROaomu/x4EgX6/pQ80Pc7eGDkkxrY7wH25wb2ezjW/rG32OK+vh3Y7+Fw+wfeYjtg/5S5sIxnXTT7lZlK4/OLNLOyuVK+5RhOtL98svZXx1qusz8joezXG1FqoOpsqfLbxaAnTHOrw+3f3ly7j6b9vR0AXdhfSZRy9lXMbs7uutmZnUYW+xX1C9eC7CZKhSunzZX2N99iKx09+0nYD8Pazy6wJSt52B1FkH4jtf1Ke9FlY8evdIW0hMPt395cu48B+5XP0GV/VY5+pm3p1SZxToBQ9hf5ut3M3NXNKelGVZ4cbv/25tp9ePp+uqFSidT+5n6rPMqBRTgHotm/YbGfZvDb35V4uP3Nt9jSw9KNVOyk+RX7jX2/fdeXENP+XokV+9mijBeWZuYo9/t1+8uuj1c2LC37aTmWfdELS5COv8Szn9ZMl/2Fq142RSnNUuYTzPXmJpr9Fvwdx6yuB/bnJp39cdQvsD876ewPRZ/9iMhRNdnlx5Mo0Pen5IG+38EDI5/UwH4PsD83sN/D9faP/QZgCkHu2XuA/R5C2N/8DcDfh/jzrJMf2H8EdLar2WTsxGI1tygVwq5qzpc9iWX/8wlQ1v4jTIX90xmblN3bT9fqu6PLymRztSqE/dtz/+9vr+xvAPSKY3sOKQ+bbe4l5Uyi2V8MD63QzBPt10uIaH/zNwBNL+knl2rBkicRwe0vas9CpVc6Jr2EsmtfWoJ0bCHs3577f397ZX8D0Oz7FbMH8iQiuP3NvkapeWPf5GnfEPZvz/2/v72yvwGwn/dTUhKR2n59ldH+am3zfNv/GcJ+y28A9E8C+0se+5WmNLZOVwnSnyWI/fbfAFTXr7GrniUlC9Hsp9XIptCthkugrSaVQI/2evuBh2j2W/B3MbM6Kdifm3T2x1G/wP7spLM/FH32IyJH1WSXH0+iQN+fkgf6fgcPjHxSA/s9wP7cwH4P19t/4fP9HoLMDMB+DyHst7zjf7+JcZZqYA7riJyHEs1+y1zVQH5LE1MrmscQzH7hHf+s/bp/Y3bCfg90OlaaoO3Kr1T1cJlPQtjffMd/r/3GnkbvNqq90JxDH3cyoezfM8v+3j4un/29z/cr1zg2P0201LVytZV2cT4x7Wf7CIupxdBDVSUovVIO+5vv+Jfst2co3Bixq6aUbS8koP1SHVr07WoRab/NMjdC2N98x/8s+5UUvab0nBcSzX6lISzuTrHfXkII+5vP9/fa30zprWvYb8FS53o2Y4so+S1lboSw33K/nx3hVSkVyibbn/vM+zyFq03penoh0exv1nlpfbli8zdL6C3zyfX2Aw+h7Dfi7zhmdT2wPzfp7I+jfoH92Ulnfyj67EdEjqrJLj+eRIG+PyUP9P0OHhj5pAb2e4D9uYH9HnLYn/Q3ABJH3LUosL+fNPZbfgPQnP+qULL1FqWXNpyzSXz7lWqUmoxm1huCnVxrlllS2m/7DYAFaZMxO2E/pek0uwmdqTXuwl7mkzT29/4GYEtUps3Zbkk5JaQ+hi15XxTNOVILHMHt32O0v7TOGX+ZG2nst/wGgLV5W1vM/YSeSItiU+yH4SGF/UptNDugZrM2eyVa5kYa+3t/A7AlVl1ys19plmO0Xz8M6ydvkcL+J/Ze3LLsX1sS2d/7G4CiVqJioTHRbr+e0wnsH15bEtnf+xuAon543cIx12E/ha0HutC7rJRgP3NKIvub9/vp4KRK3P9ZbUX3qBS1/bnPXJVGT7bqMLw18oPg9hehzvW1lhRnCU9y2A8k4ttP8Z/8s7oP2J+bdPbHUb/A/uyksz8UsD83sN9DYvsnXgHzAvs9ZLJ/7M7J2icJ7PeQxn4qMewvsN9HDvulW/KF3PrdFqR7/Oxt+7xnCOz3sKD9dKZJWWYnQRIB+z2saX9zXrD3y0NYYL+HBe3flvUMSsmJgP0ecthfZHEVuZunB1tsLmC/hzT2F/mOJ02ngx/9W29eYL+HTPYDCuz3APtzA/s9wP7cwH4PffYjIkfVZJcfT6JA35+SB/p+Bw+MfFID+z3A/tzAfg/r2L/Ym26NwH4PS9nffNPtk7FHfTzzYvrTFh4WsJ+dmtRT6OZjJSxqv/Cm23LR5O5xO81uP/twyn7Z/piWlF8pYSn7h990W7gX+JSf+wwpW3NDtpxZpLZfrwrddZpyd/stb7qlG1pqzZhNah49j4fs9ktjElr5Stvtl+9r//Cbbsts+6t2hf0sUrVIVSQ1X/NqLJ1mS9k/8KbbcoD9vdcHD+vZr9TP3JFSWcz+5ptuS8/gBPYfTbPO2TzNbPaUpew33u9nhyX6AEbJZhn5bCkF9v+MMkRhW2FLqUqgZeopT9ax/55kt3+MWT0I7M/NDe2fePGE/bm5of0Tgf25gf0e7m7/3O+g5wP7PaxjP70tYDG7mSf46QH7PcB+2H9flrKf/bdwN5XZPFJm44l0CbDfwy3sp3nYM6Ha5IjJqenAfg+r2S8t7LtwZYBE5xph/8Ksb7/enSt9v5QSCtjvYUH7qxSL/cbMAYH9Hta3v7RGPtUy/ZqLb72rso799wT2e4D9uYH9HmB/bmC/hz77EZGjarLLjydRoO9PyQN9v4MHRj6pgf0eYH9uYL+He9m/3ptuYb+H29m/2JtuF7BfetRKSaGbj5VwY/uXeNNtdvurT218LKUrv1LC7exf7E23qe3XP6buOk2B/Q3We9NtdvulMQmtWKVd9suwX2S9N91mt7+5LOXfJzavtNJpdjv7F3vT7Xr2K5997kip3ND+xd50u5j9uq/KGTKWcjv7F3vTbWr7i/zVn03cb1WVQMvUU57cy/71yG7/GPbeQQf25+aG9s9Sv8D+7NzQ/onA/tzAfg+w/2/Yb5/xgf0e7mh/8x4CuxwT2O/hdvY37x/HN34P7PdwL/uVaaz9vXZ63715B/oqYL8H2K/Ns7JzT6EuFLDfA+wfsZ/OR14F7PcA+119/+XAfg/3sr90fuvFyGdtbmd/GbrjiW+9S3JH+1cC9nuA/bmB/R5gf25gv4c++xGRo2qyy48nUaDvT8kDfb+DB0Y+qYH9HmB/bmC/B9ifG9jvAfbzVE/yGCe2PPNfY1PIC9hPZx6bKXTzsRJgP8Mlk7hjO81uf/MpEr1TsORXSoD9NayFWz3q/YqUrbkhW46F1PbrH1N3nabA/gno9ispxmxSE+p5JLLbL41JaMUq7bJfhv0uTrO/anulkSRFSn77m8tS/n1i80ornWawv+Yc+3uvDxLr2a989rkjpQL7WeyDE9jvoVmfbJ5mNnsK7OdhhyX6AEbJZhn5bCnlNvYX+as/m7jfqiqBlqmnPIH9uclu/xj23kEH9ufmhvbPUr/A/uzc0P6JwP7cwH4PsD83sN8D7Gdo3ohgb01ImS27Gz5U2O8B9tfo9ytpHvuqiZtswH4PsF9jlv3sHWt6JRk4QtjvAfaLsCMfKWW/lWIzezqh778K2M8jGdm8Duh9/76zb+7LAuz3APsZugY2Tfsl0fcnw/Chwn4PsL/Goq/Sc9vtZ0vrBfZ7gP017C1L/WurffP9yIe9DvQC+z3A/tzAfg+wPzew3wPszw3s9wD7cwP7PcD+DqSvuZcczBPY7wH219CbNvpdTt1+tqiJwH4PsL9GEnTA/hMuFLDfA+yvkZSVbtjTu/t6UcO39llgvwfYX+MZ+TR1R98fCthfo/T9bJ6uURDsDwXsr4H99wH215xpv/9kgP0eYH+Nxf4iPJ/M5qm+5s79GgD7PcD+3MB+D7A/N7DfA+zPDez30Gc/InJUTXb58SQK9P0peaDvd/DAyCc1sN8D7M8N7Pewjv1ffv1FCn1Dz033sW3xlFsQlrL/8/N7+RGfP/6l9rMPsY0B+5voj7XSpwDpFGFXCfv0Zp417X9/e5Xs16upF9iv03wAtrl2rARpQr0qYSn7S/l8xvvb67a8t5/VTupj2FqT8ih92L4QvRsbILj9e/RPXa21uCuVUJ02d7H/8/P7+9vrPqq+X7Gf1lFvSu+2U8hiv/KRh8ctbH5lgR7GUvZ///7XM97fXrdlu/20b6a9SJVH6uxh/x7L55Xqx1Jv0gW2WfNL2f/Xnx/PeH973ZYH+n5plaenv639xg87bH/zlLiL/R/fvu7jj29fP759NX7r7a39/VawX0L3la2TahM9jz6gUkp4spT9xvv9zdFLlZndtlprudpWeaYQ3376qdmByj5FKoTmYcu37OXJOvbfk+D2s/hP/lndB+zPTTr746hfYH920tkfCtifG9jv4b72j11Ae7eaeJlmgf0eYH+dqN+Wgf0rAfu1FMtWc/P3Avs9LGU/va/M3ipu3h7WyyzkXnKVTT8G/b5170eG/R6Wsn9DcbRKkf6kifsSlJIt54mS0gvs97CU/VVHm8j+4RMA9ntYx/7eXjaO/dsyRj4nA/v5EvQyj7CfPYAmsN/DOvYXw8iH5tFL2Kfo5Sj2093RbYcHP7Dfw1L23xDY7wH25wb2e4D9uYH9HmB/bmC/h7vbP3yjPQiw38M69rP3VSxbOTNcC+z3APth/31Zyn7236I+qabcyGf/jAbs93AL+2ke9kyoNpEKCQXs97Ca/dICOy9bCj9ekjIHBPZ7WN9+vTtX+n4pJRSw38OC9lcpFvuNmQMC+z2sb3+xPf1WdrqP3T66BNjvYR377wns9wD7cwP7PcD+3MB+D332IyJH1WSXH0+iQN+fkgf6fgcPjHxSA/s9wP7cwH4PVvsR6eJ0l/IB+5eN013qhj5VtaWzmfWi9D/ZKUvYv2y03LseyXJ22l6xX5+bV84r2L9sNNQLgCQ025HrmfW+X0qH/cuG5Fwc2GFPUR9DpCWwa41jJ9H+Uspvv3+wWWNi/L/aq+puPvfWfCSumWJZO0zwRrGjN4E0cLd/c2Breyn7B/6vdouUW83C/uNo1oxeXXrfL227lP3N/6t9zH4lG+z3YPxuaslgGTtRlrK/+X+1K7VWDYc2WWk6vcjuE2kzSGthf5F/TaH73VwrtVq14Tr2B2eK65R7NsqsyoT9xyL1ZLO4YaNMrEzYnxs0igfYnxs0ioe723/cmOQclmyU01jHfvbWgWUrZ4ZrCd4owYH9sP++LGU/+2/hbgCzeaTMh960cRK8UYJzC/tpHvZMqDaRCglF8EYJzmr2SwvKhCs7TchmDkjwRgnO+vbr3bnS90spoQjeKMFZ0P4qxWK/MXNAgjdKcNa3v5gfNdt/Kxi4fXQJwRslOOvYf0/Q

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center