OBIEE10G & 11G Knowledge Sharing: January 2014

Custom Sign Out Text in OBIEE 11g

For Sign out text the changes to be done in productmessages.xml file.

D:\MiddlewareHome\Oracle_BI1\bifoundation\web\msgdb\l_en\messages

Search and replace FROM name="kmsgProductGeneral"><TEXT>ORACLE BUSINESS INTELLIGENCE</TEXT><HTML>ORACLE BUSINESS INTELLIGENCE</HTML>

To your custom text as below name="kmsgProductGeneral"><TEXT>SBL BUSINESS INTELLIGENCE</TEXT><HTML>SBL BUSINESS INTELLIGENCE</HTML>

Text has been replaced in both the tags to display at sign page

Thanks,

Shanmugha Bharathy G B

Hope It Helps!!

Custom logo for Login and Home Page of OBIEE 11g

1. The changes of the image are done in the below two folder paths.

Copy your image and paste in below mentioned two folders.

D:\MiddlewareHome\user_projects\domains\bifoundation_domain\servers\bi_server1\tmp\_WL_user\analytics_11.1.1\7dezjl\war\res\sk_blafp\b_mozilla_4\ oracle_logo.png
D:\MiddlewareHome\Oracle_BI1\bifoundation\web\app\res\sk_blafp\b_mozilla_4\ oracle_logo.png

2. After the replacement of the images cache from Administrative tool should be removed.

Manage>cache>Edit>select all>purge

3. Then go to Presentation services and clear the cache and reload server metadata.

Administration>Manage Sessions>Cancel Running Request and Close all Cursors>back>Reload files and Metadata.

4. Clear all browser history and cache.

5. Size of logo has to be w:119*h:25 and if the size changes image size conflicts. All the below search bar, Advanced, Administration button etc.. all are integrated into a single template, size and format are called in different css class file which changing may conflict with many files resulting blank display sometimes.

Thanks,

Shanmugha Bharathy G B

Hope It Helps!!

Display TopN Revenue Every Year by Customer in Obiee11g

Display TopN Revenue Every Year by Customer in Obiee11g:

Hi All,

I had a requirement to generate topN Constituents Revenue based on every year. In this blog i am going to explain how to display top 10 constituents revenue for 2012;2013 etc...

1. Create a new analysis with your required columns
Here i have used the following columns and the last column displays our business scenario.

2. For Revenue By TopN column goto>edit formula> and select f(..) formula button, expand aggregate icon and select TOPN function which will look like below screenshot.

3. Then select variable button >presentation variable and type COUNT as Variable Expression and Default Value as 10 like below screenshot.

4. After entering all the values the edit formula value passing pane should look like below screenshot and select ascending to this column.

5. Now we go to to create two prompts for our analysis.

6. Select the “Prompts” tab and click on the ” + ” symbol to create a new prompt, select the “Column Prompt” -> “Time”.”Year”.

7. Keep the default values and make sure these are checked: “Enable user to select multiple values”, “Enable user to type values”, “Require user input”.

8. For the “Default selection” select “Specific Values” and use the ” + ” icon to open the “Select Values” window.

9. In the “Select Value” window select 2013 and 2012 and move them to the “Selected” side and click the OK button.

Refer and make sure the values are correct as per below screenshot:

10. Create One More Prompt:

Add one more prompt by select the ” + ” icon on the “Definition” window.
Select the “Variable Prompt”.
On the “New Prompt” window for “Prompt for” select “Presentation Variable” and on the side box enter “Count”.
For the “Label” enter “Number of Ranks”.
For the “User Input” select “Text Field”.
For the “Variable Data Type” select “Number”
Check the “Require user input” checkbox.
For the “Default selection” select “Specific Value” and enter “10″.
Then finally click the OK button.

make sure it is as below screenshot:

11. Once all done Save the analysis as TOPN Constituents Revenue By Year.

12. The Result look like

13. Select ok and run the analysis.

Hope it Helps!!

Thanks,

Shanmugha Bharathy G B