RSS

Tag Archives: presentation server

What are the Configuration Files that will be updated with the changes made in EM?

The beauty of OBIEE 11G is that the major system administration tasks can be performed using Oracle Enterprise Manager for Fusion Middleware Control (EM) application.

We can use Fusion Middleware Control (EM) to centrally manage, monitor, and configure Oracle Business Intelligence system components (for example, the Oracle BI Server, Oracle BI Presentation Services, and Oracle BI Scheduler) and some aspects of Java components. For example, you can monitor their status and start and stop them.

To log in to Fusion Middleware Control (EM), open a web browser and enter the Fusion Middleware Control URL, in the following format: http://<hostname>:<port>/em

Once you logged into EM, you can manage the OBIEE by navigating to Business Intelligence folder. The OBIEE management can be done through the following different tabs.

OBIEE-EM_tabs

These tabs consist of different set of configuration settings that we can change relevantly during our journey in application development and usage. But as an administrator, for completeness, we should know that what configuration files will be updated with the FMW EM changes.

Here the following tables contain the mapping information of the Fusion Middleware Control (EM) labels for Oracle Business Intelligence with the corresponding element names used in configuration files.

1. Scalability Tab – Mapping Between User Interface Labels and Configuration File Elements

Scalability_tab

2. Availability Tab – Mapping Between User Interface Labels and Configuration File Elements

Availability_tab

  • 3. Performance Tab – Mapping Between User Interface Labels and Configuration File Elements

 

Performance_tab1

 

4. Log Configuration Tab – Mapping Between User Interface Labels and Configuration File Elements

Log Configuration_tab 

5. Security Tab – Mapping Between User Interface Labels and Configuration File Elements

Security_tab

6. Presentation Tab – Mapping Between User Interface Labels and Configuration File Elements

Presentation_tab

7. Repository Tab – Mapping Between User Interface Labels and Configuration File Elements

Repository_tab

8. Scheduler Tab – Mapping Between User Interface Labels and Configuration File Elements

Scheduler_tab

9. Marketing Tab – Mapping Between User Interface Labels and Configuration File Elements

Marketing_tab

10. Mail Tab – Mapping Between User Interface Labels and Configuration File Elements

Mail_tab

Hope this excerpt helps you.

Thanks,

Shiva Molabanti

 
1 Comment

Posted by on April 12, 2013 in BI Publisher, OBI EE, OBIEE 11g, Weblogic

 

Tags: , , , , , , , , , , , , , , , , , , , , , , , , , , ,

How to bypass Presentation Server Cache in OBIEE 11G

During our development if we wanted to check the report level UI changes, sometimes we will not see the changes immidiately. This is due to Presentation Server Cache. Eventhough we disable the BI Server cache, It doesnt make any effect on presentation Server objects.

So in that situations we need to disable Presentation server cache permanently across OBI Application, To do this add the following parameters in instaceconfig.xml. (Make sure that you have taken a backup copy of instanceconfig.xml)

<ServerInstance>
———

<Cursors>
<ForceRefresh>true</ForceRefresh>
</Cursors>

——–

</ServerInstance>

Now restart the OBI Presentation server service and test the results.

Note: Keep in mind that this parameters cause Presentation Server to always bypass its cache. To be used only for testing – may have serious performance implications.

Keep smiling 🙂

Thanks,
Shiva

 
4 Comments

Posted by on July 17, 2012 in BI Publisher, OBI EE, OBIEE 11g

 

Tags: , , , , , , , , , , , , , , , ,

How to increase slider value limit in OBIEE 11.1.1.5?

By default OBIEE 11G has slider value limit of 50. But most of the cases we got to change this setting to 100 or more(at least in my case). To change the default set limit, update your instanceconfig.xml file as explained below.

1. Open Instanceconfig.xml file from the location <MW_HOME>\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1
2. Make a backup copy of this file before making any changes as you may risk not being able to start BI service
3. Add the following parameters

<Charts>
<SectionSliderDefault>5</SectionSliderDefault>
<SectionSliderLimit>100</SectionSliderLimit>
</Charts>

4. Restart all BI services either from EM or using commands
<MW_HOME>\instances\instance1\bin\opmnctl stopall
<MW_HOME>\instances\instance1\bin\opmnctl startall.

For more information refer http://docs.oracle.com/cd/E14571_01/bi.1111/e10541/prescatadmin.htm. It covers many more parameters, that may be needed to do other, additional customizations, too.

 

Thanks,
Shiva

 
3 Comments

Posted by on November 16, 2011 in BI Publisher, OBI EE, OBIEE 11g

 

Tags: , , , , , , , , ,

RCU Schema Configuration failed with the error “The specified prefix already exists”

We all know that we need to create RCU schemas before starting OBIEE 11G (In fact, for any Fusion Middleware application) Installation. Because it is the base store for FMW.

Recently I came across a scenario where my customer created RCU schemas with Oracle Repository Creation Utility (RCU) version 11.1.1.3.0 and Installed OBIEE 11.1.1.3.0. Now after new OBIEE 11.1.1.5.0 release he wants to upgrade his application from 11.1.1.3.0. But he is not interested at the In-place upgrade. So we uninstalled weblogic and OBIEE 11.1.1.3.0 and started RCU 11.1.1.3.0 to drop the _BIPLATFORM and _MDS schemas.

The RCU shown up with successful message and so we thought everything is cleaned up and it’s good to create schemas again. I started RCU 11.1.1.5.0 and selected Oracle Business Intelligence component and given prefix as DEV. But am not able to assign this prefix and got a message like “The specified prefix already exists”.  Though I got successful dropped schemas message, just for cross check I looked at database for the DEV_BIPLATFORM and DEV_MDS schemas. There I am not seeing any of them.

Then I checked at dropped schemas log generated by RCU and realized that there is an entry in System.SCHEMA_VERSION_REGISTRY$ table which is stopping me to assign the same DEV prefix which we used for earlier version schemas.

Actually the RCU should drop schemas using mdsschemamanager.pl script. This script has capability to do cascade delete and will delete entries in System.SCHEMA_VERSION_REGISTRY$ table.

To make sure this log into RCU DATABASE as sys and run the following SQL Query:

Select * from System.SCHEMA_VERSION_REGISTRY$;

If this query returns any record then it means the RCU didn’t drop the schemas properly.

Actually what happened in this case is the RCU schemas were not dropped using mdsschemamanager.pl script, it’s just dropped with normal schema delete and the resulting repository record for the schema is not clean. Keep in mind, this is just in case if you want to use same prefix. Otherwise RCU will let you proceed to create new prefixed Schemas.

If the RCU schemas have been deleted incorrectly using the RCU drop user command, then We need to clean these entries before starting new repository schemas creation.

To do this, run the following SQL*Plus command as sys to complete the removal of the RCU schemas records in the repository database:

delete from System.SCHEMA_VERSION_REGISTRY$;

Once you confirmed there are no entries in System.SCHEMA_VERSION_REGISTRY$  table and start the RCU to create repository schemas with the prefix (DEV in my case). The RCU will go smooth and wont complain with any error.

Hope this helps you in your RCU issues troubleshooting.

 

Thanks,

Shiva

 
7 Comments

Posted by on November 16, 2011 in BI Publisher, OBI EE, OBIEE 11g

 

Tags: , , , , , , , , , , , , ,

Predefined Presentation Variables in OBIEE 11G

The OBIEE has couple of predefined presentation variables which we can reference in analyses, dashboards, KPIs, and agents. we can take advantage of these varaibles and can be used in analysis for better presentation.

The below table contains a list of the predefined presentation variables. For time zone variables, the time zone for a user must be set to a value other than Default in order for this variable to work. (Users set their preferred time zone in the “My Account dialog: Preferences tab”.)

Note that the syntax for these predefined presentation variables omits the variables qualifier. 
for example, @{session.locale} rather than @{session.variables.locale}.


Hope this post helps you in your report developments.


Thanks,
Shiva
 
Leave a comment

Posted by on October 23, 2011 in BI Publisher, OBI EE, OBIEE 11g

 

Tags: , , , , , , , ,

what is the DXE Execution in OBIEE 11G Session log?

In OBIEE 11G if we look at Session logs, we will see a new status called ‘DXE Execution’ with amount of time its been executed. I did some research on this to answer my burning questions ‘ What this new alien will do? and How it is helpful for Performance tuning?.

Then I founded interesting news about this and actually the DXE Execution means “Data Transformation Engine which handles post-processing of the BIServer results within OBIPS”.

The post-processing can involve resorting, filtering, aggregating, and/or indexing the original BIServer result set so that the data can be consumed by a view’s renderer. And It can be automatically kicked off when the BIServer query finishes.

So if the DXE Execution is running long time, Then it’s time to open your arms to tune your report UI/Presentation Server.

Of course if the sql query is taking long time, We know how to tune DB(A)’s  :).

 

 

Thanks,

Shiva.

 
9 Comments

Posted by on September 30, 2011 in BI Publisher, OBI EE, OBIEE 11g

 

Tags: , , , , , , , , , , , , ,