How to reset forgotten OBIEE 10G RPD password

How to reset forgotten OBIEE 10G RPD password

OBIEE 10G:

for 10g:

1. Open NQSConfig.INI file
2. Go to Security part and find AUTHENTICATION_TYPE = BYPASS_NQS;
3. Uncomment (remove #) the above statement.
4. Stop the BI Server service
5. Close Administration Tool, if opened. (Then only the changes are affecting to the Administration Tool)
6. Open Administration Tool, then rpd which needs password reset, in offline mode
7. Give any password, it accepts.
8. Now go to Manage > Security.
9. From here it’s the normal process how you change password.
10. Save the changes to rpd
11. Revert back the changes in NQSConfig.INI
12. Start BI Server and open rpd with new password.

The default Authentication type for OBIEE is NQS but when we uncomment AUTHENTICATION_TYPE=BYPASS_NQS by removing the # symbol,it bypasses the default authentication and enables the user to open the RPD without any password.It can also be used for resetting the password of the RPD then Restart the BI services.

Thanks,

Satya Ranki Reddy

Dimension Hierarchy 11.1.1.7.0

OBIEE 11G - Dimension Hierarchy (11.1.1.7.0)

When you’re building a hierarchy in the Administration Tool, follow these rules.

• A hierarchy should only have one grand total level
• All the columns in a hierarchy should come from one logical table.
• All hierarchies must have a common leaf level and a common root (all) level. If a hierarchy has multiple branches, all branches must have a common beginning point and a common end point.

Dimension hierarchical levels are used to perform the set up aggregate navigation, configure level-based measure calculations and drill down from one parent to a child level.

Creation of Time Dimensional hierarchy.

There are two methods of creating dimensional hierarchies.

1. Automatic

2. Manual

Automatic Method:

Right click on the dimension and click on Create Dimension. This will create two levels total and detail level by default. You can change it to any way you want.

 Once you select automatic method this will create two levels total and detail level by default as like below.

Manual Method:

We will create Time dimension

•  On offline & online mode, Right click on the business model and select, New Object – Dimension

Please select structure (Time).

Note: Year you can select ragged and skipped as well depends of on your requirement.

• Right click on the new dimension and select New Object – Logical Level, type as “Total” for the Name and check the option, Grand Total Level and save it.

•  Right click on the “Time Total” level, and select the option, New Object – Child Level, name as Year and save it and to the same for Half/Qtr/Month/Week/Day  .

•  Right click on the “Week” level, and select the option, New Object – Child Level, name as Time Detail and save it.

•  Drag year from logical table and drop it on Year level, drag Half from logical level and drop it on Qtr level and drop it on Week level on from logical table and drop it on Time detail level.

•  In the time hierarchy you have to define chronological key into lowest level means (details level nothing but day level here).

• Right click on the year logical column properties, on the Key tab, Type year column name then Primary key column will be appear then select the primary key column  then left side pencil symbol will be enable like below.

•  Select on Year/Half/Qtr/Month/Week/Day detail levels, select keys and add the same keys (check the option use for display option) for drill down purpose.

• You have to drag the hierarchy in presentation layer.

• You can check the consistency check then save it.

While you were saving the rpd you will get the below Waring.

 level has no defined key to uniquely identify members

Solution:

Presentation layer --> double click each level --> select display columns --> here you have to click ( + symbol) then select appropriate columns like bellow.

•  Save and check on answers.

Create report and check like below.

Good Luck !!!!

Thanks,

Satya Ranki Reddy

OBIEE 11.1.1.7.0 Waterfall chart.

Now create a new analysis and go to results tab. On the results tab, Click on New view ->Graph menu, there you will find this new “Waterfall” chart.

I created a sample report with Year and Policy Count columns using Waterfall chart. You can see how the data is scattered on graph with respect to the data we have in table.

The last bar in the graph represents a value. That will be called as ‘Total‘ value in waterfall chart.

 

OBIEE 11.1.1.6 Vesrsion:

“The waterfall chart was not introduced in 11.1.1.6.0. Rather, partially implemented work has been discovered via inspection of config files. This functionality is not going to work predictably, will not upgrade, and most importantly may yield incorrect data. It should not be used or promoted. A robust Waterfall chart is planned for our upcoming release. “

Oracle introduced one new graph called “Waterfall” chart in OBIEE 11.1.1.6.0.

A waterfall chart is a special type of floating-column chart. A typical waterfall chart shows how an initial value is increased and decreased by a series of intermediate values, leading to a final value. An invisible column keeps the increases and decreases linked to the heights of the previous columns.

By default this is not visible in our graph list and need to enable manually. To do that, add this tag in your instanceconfig.xml file between <Views> element.

<Charts>
<EnableWaterfall>true</EnableWaterfall>
</Charts>
</Views>

Save the file and Restart the OPMN services.

Good Luck!!!!

Thanks,

Satya Ranki Reddy

Hardware and Software System Requirement for OBIEE 11g

Hardware and Software System Requirement for OBIEE 11g

1.0 Oracle Business Intelligence Requirements

This section contains important information for the system on which you are installing Oracle Business Intelligence and the database containing the schemas.

1.1 Installation System Requirements

Refer the below link for latest hardware and software system requirement for OBIEE11g.

http://www.oracle.com/technetwork/middleware/ias/downloads/fusion-certification-100350.html

Below are the recommended hardware and system configuration requirements for an
Oracle Business Intelligence installation on 32-bit Windows operating systems:
Hardware Requirement:
1. Disk Space: 20GB or more
2. Available Memory: 4GB or more
3. Temp Space: 950MB or more
4. Swap Space: 3GB or more
5. CPU: dual-core Pentium, 1.5GHz or greater
Software Requirement:
1. OS: Windows Xp SP2  above version
2. Microsoft .Net Frame Work 3.5 SP2 above
3. OBIEE 11g latest Version
4. RCU(Repository Creation Utility 11.1.1.7)
5. MS SQL Server 2005 Enterprise Edition

2.0 Database Requirements
Below are the recommended disk space requirements for the database containing the
Oracle Business Intelligence Scheduler database tables.
 500MB on Oracle and Microsoft SQL Server databases for standalone and Business Intelligence applications and deployments.
 500MB on IBM DB2 databases for standalone deployments.
3.0 RCU Supported Platforms
RCU is available only on 32-bit Microsoft Windows operating system platforms. You can run RCU from these machines to connect to Microsoft SQL Server database in order to create the 20 schemas required by Fusion Middleware components. The database server can be running on any platform that is supported by its respective database.

Hope this help's

Thanks,

Satya Ranki Reddy

OBIEE upgrade 11.1.1.6.0 to 11.1.1.6.9

The Oracle Business Intelligence 11.1.1.6.9 Patchset

Today am going to show you how to upgrade 11.1.1.6.0 to 11.1.1.6.9 upgrade.

This patchset is available for all customers who are using Oracle Business Intelligence Enterprise Edition 11.1.1.6.0, 11.1.1.6.1, 11.1.1.6.2, 11.1.1.6.2 BP1, 11.1.1.6.4, 11.1.1.6.5, 11.1.1.6.6, 11.1.1.6.7, and 11.1.1.6.8.

Note the following:

• Oracle Exalytics customers must only install this Oracle Business Intelligence patchset if it is certified for the specific Oracle Exalytics Patch or Patchset Update that they are applying. For more information see Oracle Fusion Middleware Installation and Administration Guide for Oracle Exalytics In-Memory Machine and the Oracle Exalytics certification information.
• Oracle Fusion Applications customers must not install this Oracle Business Intelligence patchset.
• The Oracle Business Intelligence 11.1.1.6.9 Patchset is cumulative and includes patches that you might have already applied to the BI System. Therefore, when you are installing the patchset, you might see warning messages indicating that earlier patches are being rolled back. These warnings simply indicate that oPatch is working correctly, and do not require any action.
• If you have horizontally scaled out the BI system on to multiple machines, then you must apply the Oracle BI EE 11.1.1.6.9 patches and the JDeveloper patch to all machines in the cluster.
• Customers installing this Oracle Business Intelligence 11.1.1.6.9 patchset on the HP Itanium platform must first download and apply patch 14016752 from My Oracle Support. Note that you must apply patch 14016752 before installing the Oracle Business Intelligence 11.1.1.6.9 patchset. Follow the instructions in the Readme file for patch 14016752 carefully. In particular, be sure to set the ORACLE_HOME environment variable to the <Middleware Home>/<Oracle BI Home> directory (for example, prod_mwhome/Oracle_BI1) before applying patch 14016752.
• When the patchset installation is complete and the BI System is running again, end users might experience unexpected behavior due to pre-existing browser sessions caching javascript from the earlier Oracle BI release. To avoid unnecessary support requests, ask all end users to clear their browser cache.

Patchset Installation Instructions

1. Back up the Oracle BI System, including the following:
   
   • The ORACLE_HOME\bifoundation\server directory
   • The ORACLE_INSTANCE\bifoundation\OracleBIServerComponent\coreapplication_obis1\repository
   • The ORACLE_BI_HOME\bifoundation\jee\mapviewer.ear\web.war\WEB_INF\conf\mapViewerConfig.xml, if you have modified it
   •  
2. Download the following Oracle BI 11.1.1.6.9 patch zip files from My Oracle Support into the Oracle BI Home directory:
   
   • 16287811
   • 16287778
   • 16237960
   • 16287840
   • 16287854
   • 16227549
   • 16287884

Like below :

The location of the Oracle BI Home directory depends on where Oracle BI was originally installed, and on the platform. For example:

For me :

C:\ Satya\OBIEE11G\Oracle_BI1

3. Download the following J Developer patch zip file from My Oracle Support:

• 13952743
  
  4.   Stop the BI System (in the order shown):
  
• BI system components:
  
  • On Unix, navigate to prod_mwhome/instances/<instance>/bin and enter the following at the command prompt:
    ./opmnctl stopall
    
  • On Windows, navigate to prod_mwhome\instances\<instance>\bin and enter the following at the command prompt:
    opmnctl stopall
    
    
    

 If you installed Software in your server then you need to stop the weblogic servcies as well.

• WebLogic Managed Server(s):
  
  • On Unix, navigate to prod_mwhome/user_projects/domains/<domain_name>/bin and enter the following at the command prompt:
    ./stopManagedWebLogic.sh bi_server1
  • On Windows, navigate to prod_mwhome\user_projects\domains\<domain_name>\bin and enter the following at the command prompt:
    stopManagedWebLogic.cmd bi_server1
• WebLogic Administration Server:
  
  • On Unix, navigate to prod_mwhome/user_projects/domains/<domain_name>/bin and enter the following at the command prompt:
    ./stopWebLogic.sh
  • On Windows, navigate to prod_mwhome\user_projects\domains\<domain_name>\bin and enter the following at the command prompt:
    stopWebLogic.cmd -stop

 5.  Clear the files that are associated with the Oracle BI EE Catalog Manager binary cache as follows:

1. Go to the ORACLE_BI_HOME/bifoundation/web/catalogmanager/configuration/ directory (using a file manager application or the command line). For example:
   
   • On Linux, AIX, or Solaris: If the Oracle BI Home directory is prod_mwhome/Oracle_BI1, then go to the following directory:
     prod_mwhome/Oracle_BI1/bifoundation/web/catalogmanager/configuration/
   • On Windows: If the Oracle Home directory is C:\satya\OBIEE11G\Oracle_BI1, then go to the following directory:
     c:\satya\OBIEE11G\Oracle_BI1\bifoundation\web\catalogmanager\configuration\
     
2. Remove the following Catalog Manager cache directories (if they exist):
   
   • org.eclipse.osgi
   • org.eclipse.equinox.app
     
     
     
     

 6.   In the Oracle BI Home directory, unzip each of the Oracle BI 11.1.1.6.9 patch zip files into a subdirectory below the Oracle BI Home directory. For example:

• On Linux, AIX, or Solaris: You might extract patch 16287811 into prod_mwhome/Oracle_BI1/16287811
• On Windows: You might extract patch 16287811 into c:\satya\OBIEE11G\Oracle_BI1\16287811

7. At the command prompt, change directory to the Oracle BI Home directory using the command appropriate for the operating system.
For example:

• On Linux, AIX, or Solaris: If the Oracle BI Home directory is prod_mwhome/Oracle_BI1, then enter the following:
  cd c:\satya\OBIEE11G/Oracle_BI1
• On Windows: If the Oracle BI Home directory is C:\prod_mwhome\Oracle_BI1, then enter the following:
  cd c:\satya\OBIEE11G\Oracle_BI1

8. At the command prompt, set the ORACLE_HOME, PATH, and JAVA_HOME environment variables as appropriate for the operating system.
For example:

• On Linux, AIX, or Solaris: If you are using a command shell derived from the C shell, then set the environment variables by entering the following:
  setenv ORACLE_HOME $PWD
  setenv PATH $ORACLE_HOME/bin:$PATH
  setenv JAVA_HOME $ORACLE_HOME/jdk
  setenv PATH $JAVA_HOME/bin:$PATH
  setenv PATH $ORACLE_HOME/OPatch:$PATH
  
• On Windows: If the Oracle BI Home directory is C:\satya\OBIEE11G\Oracle_BI1, then set the environment variables by entering the following:
  set ORACLE_HOME=C:\prod_mwhome\Oracle_BI1
  set PATH=%ORACLE_HOME%\bin;%PATH%
  set JAVA_HOME=%ORACLE_HOME%\jdk
  set PATH=%JAVA_HOME%\bin;%PATH%
  set PATH=%ORACLE_HOME%\OPatch;%PATH%
  
  You have to set two System variables like below.

 10.  At the command prompt, for each of the extracted Oracle BI 11.1.1.6.9 patch directories (starting with 1 of 7, then 2 of 7, and so on):

1. Change directory to the extracted patch directory.
   For example:
   
   • On Linux, AIX, or Solaris: If you extracted patch 16287811 into prod_mwhome/Oracle_BI1/16287811, then enter the following:
     cd prod_mwhome/Oracle_BI1/16287811
     
   • On Windows: If you extracted patch 16287811 into C:\satya\OBIEE11G\Oracle_BI1\16287811, then enter the following:
     cd c:\satya\OBIEE11G\Oracle_BI1\16287811
     
2. Apply the patch using the command: opatch apply
   
3. When the message "Opatch Succeeded" is displayed, repeat the previous steps for the next patch directory until all the patches have been applied.
   
   
   
   
   
   
   
    11.   Verify that the Oracle BI 11.1.1.6.9 patches have been applied successfully as follows:
   
4. At the command prompt, change directory to the Oracle BI Home.
   
5. Run the following command to list the patches that have been applied to the Oracle home that is
   specified by the ORACLE_HOME environment variable (currently the Oracle BI Home):
   opatch lsinventory
   
6. Confirm that all the Oracle BI 11.1.1.6.9 patches shown in Section 1 appear in the list of applied patches (along with any other patches that have previously been applied to the BI System).
   
   
   
   
   
    Stall the all OBIEE related services including web logic.
   
   If you want check current obiee version please use below command in command mode in windows .
   
   Putty in Linux/Unix/Aix.
   
   
   C:\Oracle\Middleware\Oracle_BI1\OPatch>opatch version
   OPatch Version: 11.1.0.9.0
   
   
   
   
   
   
   Hope this help's
   
   Thanks,
   Satya Ranki Reddy
   
   

Dashboard Custom Jave and HTML Scripts

Dashboard Custom Java Scripts Style

 

 

Insert text box onto Dashboard and "Contains HTML Markup" must be ticked. then the following statements can be used independently.


Create a Title With a Nice Line Underneath

<table class="TitleTable" cellspacing="0" style="" width="100%">
<tr>
<td class="TitleCell" style="" title="">Dashboard Menu</td>
</tr>
<tr>
<td class="TitleNameCell" style="" title=""></td>
</tr>
</table>



Out Put:

Thanks,
Satya Ranki Reddy


 

OBIEE 11g Dashboard Background image change

OBIEE 11g Dashboard Background Image or Watermark

I have implemented on Windows 64bit 11.1.1.7.0.

1. Make sure analyticsRes folder is active in weblogic for customizations

Check out the section Exposing a Static Directory in WebLogic Server

I normally use this location for customizations or images etc..

$MW_HOME\instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\analyticsRes

(Remember i will make this deployment accessible from the following location setting is ticked) when deploying analyticsRes folder in weblogic.

2. Upload your image file to the Linux box for OBIEE within anaylticsRes folder.

3. Edit or create an OBIEE Dashboard and insert a Text Box within the text box paste the following code

<script type="text/javascript">var obj = document.getElementById('DashboardPageContentDiv');obj.style.background = "url('/analyticsRes/satya.jpg') white center no-repeat fixed"</script>

Remember to tick the html box . Save your dashboard.
I uploaded an image called satya.jpg.

When you view your dashboard your image will be in the background.

Hope this help's

Thanks,

Satya