Setting Up a Multiuser Development Environment by Using the Oracle BI 11g - (MUD)

If you want to implement MUD, Download below link and follow the steps.

Purpose : Multiple users to work with the same repository simultaneously.

http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/bi11115/mude/mude_11g.htm


Thanks and Regards 
Rp - rakeshpatil002@gmail.com

Types of SQL Statements

Below are the type of sql statement which will be most useful, while using sql. 

Thanks and Regards

Rp - rakeshpatil002@gmail.com

Remove Help and About Product link from sign in page

Today will see how to remove Help and About Product link from sign in page

File Name: logonmessages.xml
File Location: C:\OBIEE11g\Oracle_BI1\bifoundation\web\msgdb\l_en\messages\logonmessages.xml

Edit logonmessages.xml and do the change as per below syntax.
========================================================================
<WebMessage name="kmsgLogonAboutProduct"><TEXT>About Product</TEXT</WebMessage>
   Do changes as per below syntax.
<WebMessage name="kmsgLogonAboutProduct"><TEXT>RakeshPatil</TEXT></WebMessage>
========================================================================
<WebMessage name="kmsgLogonHelp"><TEXT>Help</TEXT></WebMessage>
  Do changes as per below syntax.
<WebMessage name="kmsgLogonHelp"><TEXT>RakeshPatil</TEXT></WebMessage>

Save the file and restart you BI Server.

Screen Shots for Logonmessages.xml

Sign In page after Removing Help and About Product line.

Thanks and Regards
Rp - rakeshpatil002@gmail.com

Edit Analysis and Navigate to Criteria Tab

Hello Friend,

Always when you edit the analysis, you would be navigated to the Results tab by default and then again you need to click on the Criteria tab, to edit.

There is an option to go to criteria tab when clicked on edit analysis.This feature is available now in 11.1.1.6/7 in 'My Account' section. 

Next time when you click on edit analysis, the system will take you to criteria tab

Thanks and Regards 
RP - rakeshpatil002@gmail.com

Change the column heading dynamically

Today will see how to change the column heading dynamically. Please follow below steps.

Log into the Business Intelligence analytics with the link.Click on New-> Dashboard Prompt and Select the column prompt -->Select the Column Calendar Date from Sample Sale Lite subject area --> Set the presentation variable Date and save it, Check Screen shots.

Then go for report creation click New--> Analysis --> Drag the column field to display on the reports
Click on right most button of field and select column property

On column properties dialog box navigate over column format and select check box Customize heading. Set the presentation variable @{Date} in column heading

Save the report and pulled it on Dashboard page and select the date from prompt.The column heading will change according to value select in the prompt

I hope you understand. Bye ! Take Care !
Thanks and Regards
Rakesh Patil