tag:blogger.com,1999:blog-23955210553220074902024-03-14T07:34:22.648+02:00A fiew tricks and tips about Oracle BInicolaeancutabihttp://www.blogger.com/profile/04638057018584654427noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-2395521055322007490.post-89232691680681897692010-05-04T15:18:00.000+03:002010-05-13T17:19:33.865+03:00View selector in view selector in Oracle BI<span style="font-family:lucida grande;">Here are the steps to add a view selector in another view selector.</span><br /><span style="font-family:lucida grande;">First of all you have to create the views (tables, charts, pivottable...) that you want to view them using view selectors. I will create two charts and two pivottables and put the charts in a view selector, the two pivots in another view selector and at the end those two viewselectors in one view selector..</span><br /><br /><span style="font-family:lucida grande;">1. First step add columns that you want in report.</span><br /><a href="http://1.bp.blogspot.com/_mxg_GM2OScA/S-wBcjk4IWI/AAAAAAAABUs/msoJe7RQBDU/s1600/1.Criteria.jpg"><span style="font-family:lucida grande;"><img style="TEXT-ALIGN: center; MARGIN: 0px auto 10px; WIDTH: 288px; DISPLAY: block; HEIGHT: 213px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5470749237446189410" border="0" alt="" src="http://1.bp.blogspot.com/_mxg_GM2OScA/S-wBcjk4IWI/AAAAAAAABUs/msoJe7RQBDU/s320/1.Criteria.jpg" /></span></a><span style="font-family:lucida grande;"> 2. Create one chart and add it in compund layout...<br /></span><a href="http://4.bp.blogspot.com/_mxg_GM2OScA/S-wBHUFgAYI/AAAAAAAABUk/fwwq5vx1Yew/s1600/2.Chart1.jpg"><span style="font-family:lucida grande;"><img style="TEXT-ALIGN: center; MARGIN: 0px auto 10px; WIDTH: 320px; DISPLAY: block; HEIGHT: 218px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5470748872510800258" border="0" alt="" src="http://4.bp.blogspot.com/_mxg_GM2OScA/S-wBHUFgAYI/AAAAAAAABUk/fwwq5vx1Yew/s320/2.Chart1.jpg" /></span></a><span style="font-family:lucida grande;"> 3. Add another chart into compound layout (this will create chart2)<br /></span><a href="http://3.bp.blogspot.com/_mxg_GM2OScA/S-wBhRk32BI/AAAAAAAABU0/GKkulokwzJE/s1600/3.Chart2.jpg"><span style="font-family:lucida grande;"><img style="TEXT-ALIGN: center; MARGIN: 0px auto 10px; WIDTH: 320px; DISPLAY: block; HEIGHT: 218px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5470749318513678354" border="0" alt="" src="http://3.bp.blogspot.com/_mxg_GM2OScA/S-wBhRk32BI/AAAAAAAABU0/GKkulokwzJE/s320/3.Chart2.jpg" /></span></a><span style="font-family:lucida grande;"> 4. Add pivot table in compound layout (it will create pivottable 1)<br /></span><a href="http://3.bp.blogspot.com/_mxg_GM2OScA/S-wCbUi3tqI/AAAAAAAABU8/c15wgwchiF4/s1600/4.Pivot1.jpg"><span style="font-family:lucida grande;"><img style="TEXT-ALIGN: center; MARGIN: 0px auto 10px; WIDTH: 320px; DISPLAY: block; HEIGHT: 256px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5470750315743000226" border="0" alt="" src="http://3.bp.blogspot.com/_mxg_GM2OScA/S-wCbUi3tqI/AAAAAAAABU8/c15wgwchiF4/s320/4.Pivot1.jpg" /></span></a><span style="font-family:lucida grande;">5. Add another pivot table in compound layout (it will create pivottable 2)<br /></span><a href="http://1.bp.blogspot.com/_mxg_GM2OScA/S-wCfJSGq4I/AAAAAAAABVE/YaYxHnnc1Wg/s1600/5.Pivot2.jpg"><span style="font-family:lucida grande;"><img style="TEXT-ALIGN: center; MARGIN: 0px auto 10px; WIDTH: 258px; DISPLAY: block; HEIGHT: 320px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5470750381439363970" border="0" alt="" src="http://1.bp.blogspot.com/_mxg_GM2OScA/S-wCfJSGq4I/AAAAAAAABVE/YaYxHnnc1Wg/s320/5.Pivot2.jpg" /></span></a><span style="font-family:lucida grande;"> 6. Add view selector into compound layout (it will create view selector 1). Add those two charts in it. Modify the caption to indicate each chart what represents.<br /></span><a href="http://2.bp.blogspot.com/_mxg_GM2OScA/S-wDChVRZQI/AAAAAAAABVM/ql-AMIcqyyo/s1600/6.ViewSelector1.jpg"><span style="font-family:lucida grande;"><img style="TEXT-ALIGN: center; MARGIN: 0px auto 10px; WIDTH: 263px; DISPLAY: block; HEIGHT: 320px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5470750989190522114" border="0" alt="" src="http://2.bp.blogspot.com/_mxg_GM2OScA/S-wDChVRZQI/AAAAAAAABVM/ql-AMIcqyyo/s320/6.ViewSelector1.jpg" /></span></a><span style="font-family:lucida grande;">7. Add another view selector into compound layout (it will create view selector 2). Add those two pivots in it. Modify the caption to indicate each pivot what represents.<br /></span><a href="http://4.bp.blogspot.com/_mxg_GM2OScA/S-wDKf3MPrI/AAAAAAAABVU/Vq8mS3v5bJc/s1600/7.ViewSelector2.jpg"><span style="font-family:lucida grande;"><img style="TEXT-ALIGN: center; MARGIN: 0px auto 10px; WIDTH: 282px; DISPLAY: block; HEIGHT: 320px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5470751126234873522" border="0" alt="" src="http://4.bp.blogspot.com/_mxg_GM2OScA/S-wDKf3MPrI/AAAAAAAABVU/Vq8mS3v5bJc/s320/7.ViewSelector2.jpg" /></span></a><span style="font-family:lucida grande;">8. Add another view selector into compound layout (it will create view selector 3). Don't add anything in it...<br /></span><a href="http://1.bp.blogspot.com/_mxg_GM2OScA/S-wDNks4NGI/AAAAAAAABVc/roEbVBg1Wb0/s1600/8.ViewSelector3.jpg"><span style="font-family:lucida grande;"><img style="TEXT-ALIGN: center; MARGIN: 0px auto 10px; WIDTH: 320px; DISPLAY: block; HEIGHT: 300px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5470751179073401954" border="0" alt="" src="http://1.bp.blogspot.com/_mxg_GM2OScA/S-wDNks4NGI/AAAAAAAABVc/roEbVBg1Wb0/s320/8.ViewSelector3.jpg" /></span></a>9. Go to compound layout and remove the charts and pivot tables, let just the view selectors.<span style="font-family:lucida grande;"><br /></span><a href="http://3.bp.blogspot.com/_mxg_GM2OScA/S-wDQnuCVmI/AAAAAAAABVk/scopkCiA1j8/s1600/9.Compound1.jpg"><span style="font-family:lucida grande;"><img style="TEXT-ALIGN: center; MARGIN: 0px auto 10px; WIDTH: 203px; DISPLAY: block; HEIGHT: 320px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5470751231423174242" border="0" alt="" src="http://3.bp.blogspot.com/_mxg_GM2OScA/S-wDQnuCVmI/AAAAAAAABVk/scopkCiA1j8/s320/9.Compound1.jpg" /></span></a><span style="font-family:lucida grande;"> 10. Go to Advanced tab and search for the "saw: view .... viewselector3..." you will see that tag viewList is empty...<br /></span><a href="http://3.bp.blogspot.com/_mxg_GM2OScA/S-wDVDGkgqI/AAAAAAAABVs/4oFbvl9hP5Y/s1600/10.AdvancedTab1.jpg"><span style="font-family:lucida grande;"><img style="TEXT-ALIGN: center; MARGIN: 0px auto 10px; WIDTH: 320px; DISPLAY: block; HEIGHT: 155px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5470751307493311138" border="0" alt="" src="http://3.bp.blogspot.com/_mxg_GM2OScA/S-wDVDGkgqI/AAAAAAAABVs/4oFbvl9hP5Y/s320/10.AdvancedTab1.jpg" /></span></a><span style="font-family:lucida grande;"> 11. Modify the tag by adding tw0 lines with our 2 view selectors as shown below... And press SetXML button.<br /></span><a href="http://3.bp.blogspot.com/_mxg_GM2OScA/S-wDXoN6GXI/AAAAAAAABV0/CWmIwSbxzcg/s1600/11.AdvancedTab2.jpg"><span style="font-family:lucida grande;"><img style="TEXT-ALIGN: center; MARGIN: 0px auto 10px; WIDTH: 320px; DISPLAY: block; HEIGHT: 153px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5470751351815936370" border="0" alt="" src="http://3.bp.blogspot.com/_mxg_GM2OScA/S-wDXoN6GXI/AAAAAAAABV0/CWmIwSbxzcg/s320/11.AdvancedTab2.jpg" /></span></a><span style="font-family:lucida grande;"> 12. Go to Results tab and see that view selector 3 contains 2 view selectors. Edit view selector to set captions for view selectors to tell users what it represents...<br /></span><a href="http://2.bp.blogspot.com/_mxg_GM2OScA/S-wDbnI9nVI/AAAAAAAABV8/ql99rR_adkc/s1600/12.Compound2.jpg"><span style="font-family:lucida grande;"><img style="TEXT-ALIGN: center; MARGIN: 0px auto 10px; WIDTH: 320px; DISPLAY: block; HEIGHT: 277px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5470751420246236498" border="0" alt="" src="http://2.bp.blogspot.com/_mxg_GM2OScA/S-wDbnI9nVI/AAAAAAAABV8/ql99rR_adkc/s320/12.Compound2.jpg" /></span></a><span style="font-family:lucida grande;"> And at the end remove from compound layout first 2 viewselectors...<br /></span><a href="http://1.bp.blogspot.com/_mxg_GM2OScA/S-wDeD2ybGI/AAAAAAAABWE/FPL8pMJOIPk/s1600/13.Compound3Final.jpg"><span style="font-family:lucida grande;"><img style="TEXT-ALIGN: center; MARGIN: 0px auto 10px; WIDTH: 244px; DISPLAY: block; HEIGHT: 320px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5470751462314372194" border="0" alt="" src="http://1.bp.blogspot.com/_mxg_GM2OScA/S-wDeD2ybGI/AAAAAAAABWE/FPL8pMJOIPk/s320/13.Compound3Final.jpg" /></span></a><span style="font-family:lucida grande;"> </span><br />See you next time...<br /><br />Regards<br />Nicolae Ancutanicolaeancutabihttp://www.blogger.com/profile/04638057018584654427noreply@blogger.com5