Tuesday, May 4, 2010

View selector in view selector in Oracle BI

Here are the steps to add a view selector in another view selector.
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..

1. First step add columns that you want in report.
2. Create one chart and add it in compund layout...
3. Add another chart into compound layout (this will create chart2)
4. Add pivot table in compound layout (it will create pivottable 1)
5. Add another pivot table in compound layout (it will create pivottable 2)
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.
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.
8. Add another view selector into compound layout (it will create view selector 3). Don't add anything in it...
9. Go to compound layout and remove the charts and pivot tables, let just the view selectors.
10. Go to Advanced tab and search for the "saw: view .... viewselector3..." you will see that tag viewList is empty...
11. Modify the tag by adding tw0 lines with our 2 view selectors as shown below... And press SetXML button.
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...
And at the end remove from compound layout first 2 viewselectors...

See you next time...

Regards
Nicolae Ancuta

5 comments:

  1. Nice one Nicolae!

    Keep up the good work!

    Regards

    John
    http://obiee101.blogspot.com/

    ReplyDelete
  2. Thank you John

    for your good thoughts and first of all for what I've learned from your blog and posts to oracle's forum...

    I can promise that I will try...

    Regards
    Nicolae

    ReplyDelete
  3. good one nicolae..

    but im seeing the web page in different language. letters are in english but words are different. english please. :)

    ReplyDelete
  4. Sorry Kart... missed that part...
    That was romanian language...

    Regards
    Nicolae

    ReplyDelete
  5. Hi Nicolae
    After renaming the pivot tables in view selector, How could we know the selected view coming from the which pivot table like pivot 1 or pivot 2 or pivot 3?


    thanks
    Aravind

    ReplyDelete