Tuesday, December 3, 2013
Monday, December 2, 2013
I had a need to do something in Excel today that I had not done before.
I have this string:
There are five "nodes" in that string, separated by colons. I need to extract the third node (Appliances).
Using only the MID function is possible, of course, but that would require finding each successive occurrence of the colon. If I needed the 17th colon instead of the 3rd, using MID by itself would result in a very cumbersome formula.
So let's put that string in cell A1 and see if we can extract all of the characters between the 2nd and 3rd colons.
This formula has changed the 3RD occurrence of ':' to ']', and the 2nd occurrence of ':' to '['.
There is nothing special about using '[' and ']'. I picked characters that I was pretty sure wouldn't be in the original string. You can use any ASCII character, such as char(7) which is the Bell ding, or char(177) which is the plus/minus character. For example, we could use SUBSTITUTE(A1,":",CHAR(177),2) to replace the second colon with the plus/minus sign.
This extracts all characters between "[" and "]".
If desired, we can combine it together into one cell, replacing all references to cell A2 with the formula from cell A2:
Wednesday, November 20, 2013
OBIEE 11g features a new ability to create custom groupings of attribute column members, and there are two separate mechanisms that may be used: Groups and Calculated Items. What is the difference between them?
Wednesday, October 30, 2013
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, Oracle.com).
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="http://www.oracle.com/" 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
May 26, 2014
January 6, 2014
December 3, 2013
December 2, 2013
November 20, 2013
October 30, 2013
October 25, 2013
August 15, 2011
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.