Wednesday, October 30, 2013

Creating Simple Dashboard Buttons

Blog Index


In versions of OBIEE prior to 11g, the Reset button associated with a dashboard prompt could only roll back to the most recently applied value, not the original default.  We used the method described below to add a true Reset button to the dashboard.  This button reset all prompts back to their default values. 


That same method could also be used to create a button to launch almost any website.  An example of that is shown below as well.


Dashboard Prompt Reset Button


   1.        Add a Text object to the dashboard page.


   2.        Add this code for the Text object.


<div class="XUIPromptEntry minibuttonOn"><a href="#" onclick="return PersonalizationEditor.removeDefaultSelection(false ) ">Reset Prompts</a></div>


   3.        Click the Contains HTML Markup checkbox.


   4.        Click OK to save the Text object.


   5.        Add a dashboard prompt to the page.


   6.        Save and run the dashboard page, make a prompt selection click Apply.


   7.        Click the Reset Prompts button to test the reset functionality.


Website Launch Button


We can use the same technique to navigate to a website (in this example,


   1.        Add another Text object to the dashboard page.


   2.        Add and save this code (don't forget the HTML Markup checkbox).


<div class="XUIPromptEntry minibuttonOn"><a href="" target="_blank" >Oracle</a></div>


Note: The target="_blank" tag opens the content in a new browser window or tab.


   3.        Run the dashboard page and test the button.

Friday, October 25, 2013

OBIEEWanderings Blog Index

Copy Sections between Dashboard Pages

Blog Index

Have you ever wanted to copy or move a section from one dashboard page to another, or even move a section or column into a different dashboard? The information below will show you how.
   1.        Open Catalog Manager.
   2.        Attach in Offline Mode to the catalog containing the dashboard that contains the section or column that is to be moved or copied. 
   3.        Drill down to find the dashboard containing the source object.  Note that dashboards are stored under the _portal folder.  In this example, my dashboard is called Class Links, stored in the Training folder.
   4.        The section that I want to move is currently located on the OBI291 page of the Class Links dashboard.  Double-click the OBI291 page icon on the right side of the screen.
   5.        On the Properties dialog that appears, click the Edit XML button near the top right.
   6.        Now you need to find the XML for the section that you want to copy.  The XML tag that begins a section is <sawd:dashboardSection>.  Scroll through the XML until you find that tag at the beginning of the section you want to copy. 
(The similar tag for an entire column is <sawd:dashboardColumn>.)
   7.        Highlight everything starting with <sawd:dashboardSection> and ending with the subsequent </sawd:dashboardSection> ending tag.  (If you want to move two or more adjacent sections, just highlight more XML, but be sure to end with one of the </sawd:dashboardSection> tags.
Helpful hint: I find it easier to just copy/paste the entire XML into Notepad then highlight what I want.
   8.        Copy the highlighted XML to the Windows clipboard (right-click + copy, or ctrl-c).
   9.        Click Cancel twice to close the dialog boxes.
10.        Double-click the receiving dashboard page.  It may be a page in any dashboard.
11.        Click the Edit XML button.
12.        Click the Edit button below the XML.  This will allow you to edit the XML for the dashboard page.
13.        Find an existing occurrence of a section ending tag (or, if you are copying a column, find a column ending tag).  A section ending tag is </sawd:dashboardSection>.
14.        Immediately following the existing section ending tag, hit the Enter key to insert a blank row.
15.        On the blank row, right-click + Paste to paste the XML that you copied to the clipboard earlier.
16.        One last thing: Look at the top of the XML you just pasted.  It will start with something like this:
<sawd:dashboardSection name="Section 9"
If two sections on the same page have the same name, both sections will appear in the dashboard, but they will share the same set of editing icons in the dashboard editor, which is probably not a good thing.  Change this name= parameter to some other number that isn't used on this dashboard page.
17.        Click OK twice to close the dialogs.  The process is complete.
18.        Access your modifed dashboard page to see the copied section.