Kishore Analytics Solutions: March 2013

Saturday, March 30, 2013

EBS 12.1.3

OBIEE 11g - Weblogic Security Administration

Debugging the Weblogic Authentication Errors

1) Boot.properties : key file to start the node manager/ weblogic

weblogic.security.SecurityInitializationException: Authentication denied: Boot i

dentity not valid; The user name and/or password from the boot identity file (bo

ot.properties) is not valid. The boot identity may have been changed since the b

oot identity file was created. Please edit and update the boot identity file wit

h the proper values of username and password. The first time the updated boot id

entity file is used to start the server, these new values are encrypted.

at weblogic.security.service.CommonSecurityServiceManagerDelegateImpl.do

BootAuthorization(CommonSecurityServiceManagerDelegateImpl.java:959)

at weblogic.security.service.CommonSecurityServiceManagerDelegateImpl.in

itialize(CommonSecurityServiceManagerDelegateImpl.java:1050)

at weblogic.security.service.SecurityServiceManager.initialize(SecurityS

erviceManager.java:873)

at weblogic.security.SecurityService.start(SecurityService.java:141)

at weblogic.t3.srvr.SubsystemRequest.run(SubsystemRequest.java:64)

Truncated. see log file for complete stacktrace

Caused By: javax.security.auth.login.FailedLoginException: [Security:090304]Auth

entication Failed: User weblogic123 javax.security.auth.login.FailedLoginExcepti

on: [Security:090302]Authentication Failed: User weblogic123 denied

at weblogic.security.providers.authentication.LDAPAtnLoginModuleImpl.log

in(LDAPAtnLoginModuleImpl.java:261)

at com.bea.common.security.internal.service.LoginModuleWrapper$1.run(Log

inModuleWrapper.java:110)

at java.security.AccessController.doPrivileged(Native Method)

at com.bea.common.security.internal.service.LoginModuleWrapper.login(Log

inModuleWrapper.java:106)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

Truncated. see log file for complete stacktrace

If you read the bold text your problem/solution is clearly explained at the time of starting BI Services the credentials you entered will store in boot.properties file located at

\middleware\user_projects\domains\bifoundation_domain\servers\AdminServer\security

when the credentials are wrong then it will throw above error message next time it wont ask again for the password because it already stored at boot.properties file so solution is to delete the file and start the BI Services again this time enter the right credentials without fail and the console should display below message

<Storing boot ide

ntity in the file: \middleware\user_projects\domains\bifoundation_domain\serve

rs\AdminServer\security\boot.properties>

Embedded LDAP Data : Default LDAP server

2) Weblogic Server’s default security providers use an embedded LDAP server to persist all security-related data. Each server stores this data locally,including all of the user,group,role,access control policy,and credential information.For each domain,the admin server acts as the master LDAP server and replicates new information to the embedded LDAP running on each of the managed servers.

All the data of the embedded LDAP server will store into a directory

\middleware\user_projects\domains\bifoundation_domain\servers\AdminServer\data

Whenever a WebLogic Server is started, it places all of its internal files in a server instance-specific directory. By default, the server’s directory is located in the directory it was started from and has the same name as the server instance (for example,

user_projects/bifoundation_domain/AdminServer/data).

Inside this server directory is an ldap sub directory where you will find the LDAP server’s files. shows the full directory structure and description of the embedded LDAP server directory contents.

LDAP folder has below details

backup - Zipped backup files created once a day from the ldapfiles directory

conf - Configuration files that are generated on the first server start

ldapfiles - LDAP server data files

log - LDAP server log files

replicadata - Managed server replicated data

backup time can be manged from console

If you ever encounter a problem where a managed server won’t start and you suspect that its LDAP data may be corrupt, you can either try to use one of the backup zip files from the backup directory to revert the contents of the ldap files directory or simply remove the entire ldap directory and let it be recreated when the managed server starts up and connects to the admin server

where ldap_bkp is backup file and ldap - is newly created one when I start ' Start BI Services' - weblogic

\middleware\user_projects\domains\bifoundation_domain\servers\AdminServer\data\ldap\ldapfiles has different files but below are key files to know

EmbeddedLDAP.data - is the main data file where all the users, groups, roles, and policies are stored

EmbeddedLDAP.delete - contains information about deleted entries

EmbeddedLDAP.lok -

file is used to ensure access consistency to the LDAP information. In some cases, a Weblogic Server might shutdown without allowing the embedded LDAP server to unlock the data. If this hap-pens, the server will go into a loop, waiting for the file to be removed and printing out a warning message:

Typically, deleting the EmbeddedLDAP.lok file will resolve this issue

3) Authentication Provider : Control Flag which wont allow you to login analytics

Authentication Providers are used to derive login credentials, certificate or custom headers, using some form of LDAP, or other identity store

When a user has configured their custom provider and changed the control flag to required for both the providers (custom and Default Authenticator)

The Control Flag governs whether authentication from a provider is required. If

multiple providers are present, then at least one of them must be set to REQUIRED(but not both) You can mess up your domain resulting in not being able to start your server

anymore (if you use two Authentication Providers, define the Weblogic user in both

of them and set one to REQUIRED resulting in not being able to access the domain

anymore). In fact, you should always set the Default Authenticator to REQUIRED.

4) Creating New weblogic User

Weblogic user creation :

Don't forget to take backup of security folder

--- \middleware\user_projects\domains\bifoundation_domain\security

Above three approaches can be used to bring back your weblogic server

Partial Update using Condition - OBIEE 11g

I have a page, where reports display based on a prompt value using guided navigation/Conditional navigation

its successfully upgraded from 10G to 11G when we sort on the report title view is disappearing but it appears by clicking on refresh button at bottom of report

To overcome it you can disable the presentation server Cache but it would cause performance issues so in 11g we have Partial Update option in Advanced Tab of Analysis select Entire Report which would solve the issue.

Partial Update — Use this box to specify whether to update the SQL statement and HTML code only for views or for the entire analysis in response to an event.

Select either Default or Affected Views to update the SQL statement and HTML code only for the views that have been affected by an event such as drilling or sorting. These settings ensure better performance because the SQL statement and HTML code is generated only for affected views, which prevents the entire analysis from redrawing.
Select Entire Report to rebuild and redraw the entire analysis

Error: OBIEE 11g: Error: "Stream Closed" Server Exception in Enterprise Manager during PPR, #13 .1)OBIEE 11G - Selecting 'Coreapplication' Reports ADF_FACES-60096 Error Message

Solution:
1. Delete the instance.jspx.xml file in folder $Middleware_home\user_projects\domains\bifoundation_domain\sysman\mds\partition1\ai\bi\mdssys\cust\user\USER_NAME where USER_NAME represents the user id of the user in question.
2. Stop and re-start all services, including WebLogic. The instance.jspx.xml file will be recreated.

OBIEE 11g - Oracle Map viewer Installation & Configuration

MapViewer Introduction.

MapViewer is a J2EE service for rendering maps using spatial data managed

by Oracle Spatial.MapViewer provides services and tools that hide the complexity of spatial

data queries and cartographic rendering, while providing customizable options for more

advanced users. MapViewer is designed to integrate with Location-Based services and

applications.

Configure Install script

Copy the map_install from other server where it is deployed (eicfdcn35) or if it’s not in any other server

Download SampleApp V10722 Installation ZIP Files from OTN which contains installation files including database dump files

Save the zip file on to the machine where OBIEE 11g is preconfigured, up and running.

Change it using chmod 777 map_install

Edit the “installSA.sh” installation script using a text editor to specify correct values for the following variable names. “installSA.sh”. Incorrect values can result in incorrect .

Troubleshooting Install Script

When the installSA.sh is executed we may encounter the following error

-bash: ./installSA.sh: /bin/sh^M: bad interpreter: No such file or directory

If you encounter this error, then create a new file called installSA1.sh, copy and paste the contents of installSA.sh into the new file installSA1.sh. Then grant execute privileges on this new file using chmod 777 installSA1.sh. Now execute installSA1.sh to run the installer.

If your OBIEE installation is of is of „Enterprise‟ and not „Simple‟ type, then your setup will have both AdminServer and bi_server1. In this case, the installer will give the following error while trying to copy a couple of files for Actions because the path needs to be bi_server1 instead of AdminServer.

The below option has to be worked out if the below changes are not made .

1. Oracle \OBIEE home path \

2. Replace bifoundation_domain1 with bifoundation_domain

[INFO] Copying files for Actions

cp: target `/app/oracle/product/obiee/11g/user_projects/domains/bifoundation_domain/servers/AdminServer/tmp/_WL_user/analytics_11.1.1/silp1v/war/res/b_mozilla/actions/' is not a directory

cp: target `/app/oracle/product/obiee/11g/user_projects/domains/bifoundation_domain/servers/AdminServer/tmp/_WL_user/analytics_11.1.1/silp1v/war/res/s_blafp/images/' is not a directory

These two copy steps need to be manually executed with the appropriate paths on your setup.

1) Copy Comment.gif and NoComment.gif from your SampleApp install location /Actions/CommentaryArtifacts to the following two locations on your OBIEE install

/installhome/user_projects/domains/bifoundation_domain/servers/bi_server1/tmp/_WL_user/analytics_11.1.1/7dezjl/war/res/b_mozilla/actions

and /installhome/user_projects/domains/bifoundation_domain/servers/bi_server1/tmp/_WL_user/analytics_11.1.1/7dezjl/war/res/s_blafp/images

2) Copy UserScripts.js from your SampleApp install location /Actions/CommentaryArtifacts to the following two locations on your OBIEE install

/installhome/user_projects/domains/bifoundation_domain/servers/bi_server1/tmp/_WL_user/analytics_11.1.1/7dezjl/war/res/b_mozilla/actions

and

/installhome/ Oracle_BI1/bifoundation/web/app/res/b_mozilla/actions

C:\OBI11G\Oracle_BI1\bifoundation\web\app\res\b_mozilla\actions

If your environment doesn‟t support neither batch nor shell scripts, then you will have to carry out the copy process manually before you proceed with the rest of the steps. Similarly if any part of the “installSA” script fails, retry the failed command and all the remaining commands manually. You may open the script using a text editor and refer it to understand the source and target files paths and the list of files to be copied.

1.2 File copy Status

The below status indicates the list of files that got copied after running the installSA.sh file

1) Copy Comment.gif and NoComment.gif from your SampleApp install location /Actions/CommentaryArtifacts to the

following two locations on your OBIEE install

/installhome/user_projects/domains/bifoundation_domain/servers/bi_server1/tmp/_WL_user/analytics_11.1.1/7

dezjl/war/res/b_mozilla/actions

and

/installhome/user_projects/domains/bifoundation_domain/servers/bi_server1/tmp/_WL_user/analytics_11.1.1/7dezjl/war/res/s_blafp/images

From the sample app location copy the2 gif files

[biadmin@eicfdcn37 CommentaryArtifacts]$ pwd

/essdata1/map_install/SampleApp_10722/Actions/CommentaryArtifacts

Copy the files Manually to the location if you run into file copy issues

/essdata1/OBIEE11g/user_projects/domains/bifoundation_domain/servers/bi_server1/tmp/_WL_user/analytics_11.1.1/7dezjl/war/res/b_mozilla/actions

Gif .files

RPD file: The SampleApp.rpd file that is in the install directory does NOT need to be moved into your BIEE install. It will be used directly by EM administration process, and needs to be copied to the machine where you will run EM browser from.

Restoring Data Dumps

Oracle data dump is used to import the definition and data for several database schemas. If any of these schemas exist, they must be dropped before you begin the import. In case they cannot be dropped, the schemas may be imported into different schema names using schema mapping options available for impdp command. If the schema names and/or passwords are changed, it will require additional corrections and configurations in SampleApp RPD.

Send an email to the DBA Team requesting them to create the Mpaviewer schemas and send them the Mapviewer documentation link[ ]

These tasks will be performed by DBA .

From the SampleApp installation files, copy \DataSources\ORCL\SASCHEMAS.dmp file to the machine where Oracle database 11gR2 is up and running

Unzip this file to a folder on the database server, say “C:\datapump\”

Connect to database using a sysdba user and create a directory object to import the database dump. Change the data base connection parameters (highlighted in red) to reflect your connection settings.

sqlplus "sys/Admin123@sampledb1 as sysdba"

create or replace directory datapumpdir as 'c:\datapump';

Import the database dump using the command below.

impdp "'"sys/Admin123@sampledb1 as sysdba"'" directory=datapumpdir dumpfile=SASchemas.dmp version=11.2.0.0.0 schemas=BISAMPLE,OBIEE_NAVTEQ,BIFOD,BIBPM,DEV_ODI_REPO,ODI_STAGING LOGFILE=SASchemas_imp.log

NOTE:- Change the value of Version parameter depending on the version of your target database.

During the import process you may get the warning ORA-39082: Object type VIEW:"BISAMPLE"."ODM_SAMP_CUSTOMERS_LTV" created with compilation warnings

This a known warning and can be ignored.

Once the import is completed, connect back to the database using a sysdba user and execute the following sql commands.

To connect use - sqlplus "sys/Admin123@sampledb1 as sysdba"

alter user BISAMPLE identified by BISAMPLE;

alter user OBIEE_NAVTEQ identified by obiee_navteq;

alter user BIFOD identified by BIFOD;

alter user BIBPM identified by BIBPM;

alter user DEV_ODI_REPO identified by DEV_ODI_REPO;

alter user ODI_STAGING identified by ODI_STAGING;

insert into user_sdo_maps select * from obiee_navteq.my_maps;

insert into user_sdo_themes select * from obiee_navteq.my_themes;

insert into user_sdo_styles select * from obiee_navteq.my_styles;

insert into user_sdo_cached_maps select * from obiee_navteq.my_tile_cache;

commit;

Creating Weblogic Server Users

Start Weblogic AdminServer

On your server, navigate to: /essdata1/OBIEE11g/user_projects/domains/bifoundation_domain/bin and run the startWebLogic.sh depending on your environment OS. You will be prompted with your Administrator credentials created during platform install. Bringing up this service may take a few minutes depending on your environment, wait until the command line.

Importing Users in Weblogic

This step is required in order to have most of the SampleApp features to work. Make sure the FMW import happens properly on your environment. Open the weblogic Administration console online (http://eicxxcxxx.ebiz.xxxxx.com:7001/console use the login that was created in BIEE installation to log in).

From home screen, click on Security Realms link.

Go to the migration page tab. Go to the Import tab.

In the 'Import Directory on Server', point to the directory where you saved

the SampleApp Install files, navigate to the core folder and FMW_Users_Definition subdirectory within that.

Click on Save. This should import all the SampleApp users into your environment. To confirm it, click

on Users and Groups tab.

Activate the changes

· Verify that you can see the new users like abell, etc created now. You should be able to login using any of these users in OBIEE

User Credentials

The list of users in this build is listed in the table below. Passwords for all SampleApp users imported, as well as the RPD encryption password is uniquely set to : Admin123

Verify by logging with the Admin123 for any of the above users listed.

Deploying analyticsRes in WLS

This step allows to point WLS to the file folder location where you have pasted custom files

for SampleApp (Images, styles, messages…).

Login to weblogic Administration console (http://eicxxxxx.ebiz.xxxxx.com:6001/console use the login

you created in BIEE installation to log in).

Navigate to deployments area.

Click on the Install button in the deployments area to install a new web application. (If Install button is

not enabled, click on Lock & Edit on the left frame).

In the Install Application Assistant dialog, provide the path:

\installhome\instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1

This should give the option to select analyticsRes as a valid application to deploy.

Select analyticsRes and click on Next In the Install Application Assistant dialog, provide the path:

\installhome\instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1

This should give the option to select analyticsRes as a valid application to deploy

Deploying Metadata Dictionary Folder in WLS

This step is required to make metadata dictionary available within SampleApp.

ü IMPORTANT Note :

The metadata dictionary folder name SampleApp_BI0001 in the path

OBIEE11g]$ cd instances/instance1/metadatadict/SampleApp_BI0001/

should be the same as the rpd name that is online currently. If your rpd name has changed to say SampleApp_BI0002 or SampleApp_BI0003, then change the directory name of the SampleApp_BI0001 under metadatadict to the same name as the rpd.

Deploying the Dictionary in WLS

eblogic Administration console screen, click on Deployments area.

Click on the Install button in the deployments area to install a new web application. (If Install button is not enabled,

click on Lock & Edit on the left frame).

Specify the path as indicated below for the metadatadict deployment click Next proceed .

Path:/essdata1/OBIEE11g/instances/instance1/metadatadict

Choose the deployment type as application

It should be deployed on bi_cluster

OBIEE Configuration Settings

NQSConfig.ini Edits

Open NQSConfig.ini file from the following location:

/essdata1/OBIEE11g/instances/instance1/config/OracleBIServerComponent/coreapplication_obis1

BEFORE CHANGE

USER_REF_GUIDS

Make sure the following tag (in green) is set as shown below in your NQConfig file and save it :

->[SERVER]

...

FMW_UPDATE_ROLE_AND_USER_REF_GUIDS = YES;

2.6.1.2.Usage Tracking

The following entry is not mandatory, but will allow the usage tracking SampleContent to show data, it is advised that you set

these tags as described :

->[USAGE_TRACKING]

ENABLE = YES;

...

DIRECT_INSERT = YES;

PHYSICAL_TABLE_NAME = "10 - System DB (ORCL)"."Catalog"."dbo"."S_NQ_ACCT";

CONNECTION_POOL = "10 - System DB (ORCL)"."UT Connection Pool";

Before Changing

AFTER CHANGING THE NQSConfig file

1USER_REF_GUIDS

Make sure the following tag (in green) is set as shown below in your NQConfig file and save it

Instanceconfig.xml Edits

Open Instanceconfig.xml file from the below location :

/essdata1/OBIEE11g/instances/instance1/config/OracleBIPresentationServicesComponent\coreapplication_obips1

Comment the following tag.

<Catalog>

<UpgradeAndExit>false</UpgradeAndExit>

</Catalog>

Make sure you have all the following tags (in green below) in the file, within the existing <ServerInstance> tag. Some of these entries may already be present in your file. Ensure that entries are made only once and are in appropriate locations.

...

<SpatialMaps><LayerDataLayout><MaxRecords>1000</MaxRecords></LayerDataLayout></SpatialMaps>

<LightWriteback>true</LightWriteback>

...

<ps:Catalog xmlns:ps="oracle.bi.presentation.services/config/v1.1">

<ps:UpgradeAndExit>false</ps:UpgradeAndExit>

<ps:UpdateAccountGUIDs>UpdateAndStartNormally</ps:UpdateAccountGUIDs>

</ps:Catalog>

<LogonParam>

<TemplateMessageName>LogonParamSQLTemplate</TemplateMessageName>

<MaxValues>100</MaxValues>

</LogonParam>

<SubjectAreaMetadata>

<DictionaryURLPrefix>/metadatadict/</DictionaryURLPrefix>

</SubjectAreaMetadata>

…

</ServerInstance>

Instanceconfig.xml edits

Added under server instance

<SpatialMaps><LayerDataLayout><MaxRecords>1000</MaxRecords></LayerDataLayout></SpatialMaps>

<LightWriteback>true</LightWriteback>

...

<ps:Catalog xmlns:ps="oracle.bi.presentation.services/config/v1.1">

<ps:UpgradeAndExit>false</ps:UpgradeAndExit>

<ps:UpdateAccountGUIDs>UpdateAndStartNormally</ps:UpdateAccountGUIDs>

</ps:Catalog>

<LogonParam>

<TemplateMessageName>LogonParamSQLTemplate</TemplateMessageName>

<MaxValues>100</MaxValues>

</LogonParam>

<SubjectAreaMetadata>

<DictionaryURLPrefix>/metadatadict/</DictionaryURLPrefix>

</SubjectAreaMetadata>

Add the similar code in instance config.xml SAC server under this path

/apps/biadmin/OBIEE11g/instances/instance1/config/OracleBIPresentationServicesComponent/coreapplication_obips1

RPD Edits

ü IMPORTANT Note :

Always open Admintool by opening the Start program menu, and navigating on to the menu icon within the Oracle Business Intelligence menu. Do NOT open the RPD simply double click on the RPD file or typing Admintool.exe in command line

Open Admintool then open the SampleApp.RPD file offline from your installer location :

RPD Password for opening offline : Admin123

RPD Existing Connections

Edit BI_EE_HOME Variable Value

Navigate to Manage>Variables menu, double click on the BI_EE_HOME Repository Variable, update the default initializer string from its current value to the correct full path of the following directory on your BIEE install :

/essdata1/OBIEE11g/instances/instance1/bifoundation/OracleServerComponent/coreaplication_obis1

Update RPD variables that contain database connection information

The connection pools setting uses repository variables to connect to the underlying database. You must update these variables to allow the RPD to properly connect. On the RPD click on Manage->Variables and update the following variables to appropriate values to connect to your database.

DB_HOST - This variable holds the value of the database host machine.

DB_PORT - This variable holds the value of the port.

DB_SID - This variable holds the SID information.

DB_USERNAME - This variable holds the database username. (Must be BISAMPLE)

WLS_HOST - This host information should be the computer name (or IP) of your Weblogic Server host.

2.6.3.4 Update Database Password in RPD connection pools

If you have not changed the OOB password for BISAMPLE user (pwd = „BISAMPLE‟), then there should be no edit needed in the RPD. If you have changed the value of the password for the BISAMPLE user, you need to edit password values for all the Connection Pool entries in RPD that use the above variables with your correct password value.

Update settings with RCU db for Scheduler Connection Pool

The values in “Scheduler Connection Pool” under “07 – Scheduler Jobs” database need to be updated to point to the BIPLATFORM schema that is installed during OBIEE installation. In the connection pool, update the data source name with the appropriate values of database host, sid, port, username and password of the BIPLATFORM schema.

ü Note :

The BIPLATFORM schema is the one that is used during the OBIEE installation process.

Expected Consistency Warnings

ü Important : Expected Consistency Warning

Run a consistency check of your RPD. You should see the single following consistency warning message :

RPD Consistency check

This warning is expected; do not try to fix it. Fixing it would break the OLAP API functionality. In case you see other errors or warnings coming up, please process previous steps again starting from the original RPD.

Save your offline RPD.

Save the RPD Offline after updating the required changes

Setting the default rpd and webcat paths through EM

RPD selection

Use the login that was created during OBIEE installation to log in to the EM http://eicfxxxx.ebiz.xxxx.com:6001/em

Expand 'Business Intelligence' node on the left and choose Coreapplication

· Click on 'Lock and Edit Configuration' to enable you to change the default settings.

· Click on the Deployment tab on the right. Navigate to the Repository tab.

· In the 'Upload BI Server Repository' section, click on the Browse button and locate the SampleApp.rpd that you updated with correct connection information, on your client machine.

· Enter Admin123 as the password ( this is the offline password for SampleApp.rpd)

· Stay on the same configuration screen to update webcat selection

Webcatalog path

This platform install, does not yet point to SampleApp catalog, you need to update the path at the bottom of the same EM screen, with the location looking like this.

Change the path to point to SampleApp Webcat so the location gets reflected as indicated below.

Sample AppWebcat path:/essdata1/OBIEE11g/instances/instance1/SampleAppWebcat

Default path:$ORACLE_INSTANCE/bifoundation/OracleBIPresentationServicesComponent/$COMPONENT_NAME/catalog/SampleAppLite

Sample app repository path

/essdata1/OBIEE11g/instances/instance1/bifoundation/OracleBIServerComponent/coreapplication_obis1/repository

Catalog Path:[biadmin@eicfdcn37 catalog]$ pwd

/essdata1/OBIEE11g/instances/instance1/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/catalog

Default catalog path in em

$ORACLE_INSTANCE/bifoundation/OracleBIPresentationServicesComponent/$COMPONENT_NAME/catalog/SampleAppLite

Apply changes

· Click on Apply (top right corner of screen)

· Click on activate changes

Sac mapviewer error http://113.130.93.9:9704/mapviewer/mapadmin

Configuring SampleApp Mapviewer Content

Confirm that WLS server and WLS managed servers are up and running, and make sure OMPNCTL is not running (neither OBIS nor OBIPS are running). Stop BI Server and Presentation Server if they are running.

MapViewerConfig.xml Edits

Open the map viewer console login with the user name and password that was provided while installing the product

http://eicxxxx.ebiz.xxxx.com:8704/mapviewer/faces/admin/admin_mvconfig.jspx

<security_config>

In the <security_config> property of this file, make the following changes:

Change the <proxy_enabled_hosts> property to the following :

Substitute the hostname, IP address and port to the correct values on your setup.

(NOTE:- There are 4 entries here. Two of them refer to the hostname and while two refer to the ip address of the machine where OBI is installed. Update all 4 entries to the hostname and ip address on your setup)

-----------------------------------

<proxy_enabled_hosts> http://eicxxxx.ebiz.xxxxxxx.com:8704/mapviewer,http://eicxxxx.ebiz.xxxxxxx.com:8704/,http://113.141.192.37:8704/,http://113.141.192.37:8704/mapviewer

</proxy_enabled_hosts>

Substitute any entries with these tags with the property entries below: If the entry already exists, confirm that the value is as shown below. If the entry does not exist, then add a new entry with the value given below.

<<disable_direct_info_request> true </disable_direct_info_request>

<disable_info_request>true</disable_info_request>

<disable_csf>true</disable_csf>

<enforce_security_role> true </enforce_security_role>

Predefined Data Sources

At the end of the file, in the section named 'Predefined Data Sources', add the following data source entry. Replace the ipaddress, sid and port to the correct values of the database where the obiee_navteq schema has been created in the above steps.

<map_data_source name="OBIEE_NAVTEQ_Sample"

jdbc_host="10.229.147.238" (use your db ip)

jdbc_sid="orcl" (use your db sid)

jdbc_port="1521" (use your db port)

jdbc_user="obiee_navteq"

jdbc_password="!obiee_navteq" (use your selected password if different from OOB)

jdbc_mode="thin"

number_of_mappers="3"

allow_jdbc_theme_based_foi="false"

Make sure all tags have been closed correctly and also make sure the above data source is not within the comments section (ensure that it is outside the comments section which is represented by )

Post changes

This should reflect as indicated below

<map_data_source name="OBIEE_NAVTEQ_Sample"

jdbc_host="eicfxxxx.ebiz.xxxx.com"

jdbc_sid="VS2"

jdbc_port="1521"

jdbc_user="obiee_navteq"

jdbc_password="!obiee_navteq"

jdbc_mode="thin"

number_of_mappers="3"

allow_jdbc_theme_based_foi="false"

</MapperConfig>

uncomment the above in default code and password should be prefixed with !

Save & Restart, Verify

Click on Save & Restart button at the bottom of the file. Once it is restarted, Click on Data sources. You should now see OBIEE_NAVTEQ_Sample as an entry there.To confirm that the Mapviewer configuration is working, choose the Map Tile Layer called OBIEE_WORLD_MAP and click on 'View Map / Manage tiles' option. In the window that opens up, click on the 'Show Map' button. This should display the world map. Repeat the steps for the Map Tile Layer called OBIEE_WORLD_MAP_FAST and confirm that the world map is displayed.

· Click on save and re start the password now be viewed in the encrypted form.

No need to add the data source manually it would get reflected as indicated below.

MapViewer Configuration settings screenshots

Mapviewer url:http://eicfxxxx.ebiz.xxxx.com:8704/mapviewer/faces/admin/admin.jspx

Known Mapviewer Issues:If the schemas are not created properly and the relevant inserts statements are not passed on the default maps wouldb’t get reflected.

Configuring Google Maps

· Click on “Manage Tile Layers”. Click “Create”

· Select Google Maps as Tile Layer Type

· Select “Google Maps” as type of map source. Click “Continue”

· Enter “key”

On the tile layer properties page, enter a valid value for the key. Select a data source from the Data Source dropdown. Click “Submit”. Test the tile layer by selecting the tile layer from the list of layers and click “View Map / Manage Tiles”

Edit/view API Key

Key assigned on eicfdcn35: use the same keyABQIAAAAPnwEhDNdNs3kx2nW2Es5GRT1apVUF891Z07_t00B1qRQi77KhhTUOv9Qdye_uCBq9xS_yZ9IPLOGCQ

Add the GOOGLE MAPS and assign the above key and click on submit

Obtaining a Google Maps API Key

Open URL http://code.google.com/apis/maps/signup.html in your browser. Log in to Google with a google.com user id. Read the Terms & Conditions. Enter the URL of your web site. Click “Generate API Key”. Copy and store this key value in a safe place. Use this key value when creating tile layers in MapViewer.

Known mapviewer error

On some of the dashboard pages with maps, you might see the error Fail to load “/mapviewer/fsmc/jslib/oraclemaps.js”.

An immediate workaround to this problem is to refresh the screen and the map should show up.

To fix it permanently, make the following changes to the mapviewer configuration. Edit the file web.xml located under the folder

/essdata1/OBIEE11g /Oracle_BI1/bifoundation/jee/mapviewer.ear/web.war/WEB-INF

In this file, search for the string „mime‟. Insert the full tag shown below just after the first <mime-mapping> tag, as shown in the

picture (tag to insert is highlighted)

<mime-mapping>

<extension>js</extension>

<mime-type>text/javascript</mime-type>

</mime-mapping

Removing drop-shadow effect on graphs

By default, whenever a chart is created, there is a drop-shadow effect on it. This property makes it difficult to read some of the SampleApp charts. In order to turn it off this property, edit the file dvt-graph-skin.xml from the following location on your installation.

/essdata1/OBIEE11g/Oracle_BI1/bifoundation/web/msgdb/s_blafp/viewui/chart Edit the <Graph> tag, add the attribute visualEffects="NONE". (Do not remove the rest of the contents in the file). After editing, the contents should look like this.

<!-- decimalDigitUsed is false here so that non-percentage pie slices do not pick up this value

The DVTChartProcessor sets decimalDigitUsed to true if this is a percentage pie slice -->

</SliceLabel>

Path:/essdata1/OBIEE11g/Oracle_BI1/bifoundation/web/msgdb/s_blafp/viewui/chart

Change /add the below tag to the dvt-graph-skin.xml

By default, whenever a chart is created, there is a drop-shadow effect on it. This property makes it difficult to read some of the

SampleApp charts. In order to turn it off this property, edit the file dvt-graph-skin.xml from the following location on your

installation.

\InstallHome\Oracle_BI1\bifoundation\web\msgdb\s_blafp\viewui\chart

Edit the <Graph> tag, add the attribute visualEffects="NONE". (Do not remove the rest of the contents in the file). After editing, the contents should look like this.

<Graph visualEffects="NONE">

<SliceLabel>

<!-- decimalDigitUsed is false here so that non-percentage pie slices do not pick up this value

The DVTChartProcessor sets decimalDigitUsed to true if this is a percentage pie slice -->

<ViewFormat decimalDigit="2" decimalDigitUsed="false"/>

</SliceLabel>

</Graph>

Save the file.

Graph visualEffects=”NONE”

</Graph>

Save the file.

Start BIEE services and login

Starting services From EM screen

Login to the EM administration screen using the url http://localhost:7001/em (Replace the hostname and port number based on your setup). Use the login you created in BIEE installation to log in.

Expand 'Business Intelligence' node on the left and choose Coreapplication.

Click on the Overview Tab,

Click on blue button „Restart‟ (or green button

„Start‟) under the Manage System category, middle of screen,

Click yes on dialog box to confirm the move. Wait for message that confirms successful restart.

üNote

If starting using EM is not successful and complaining about OPMNCTL not up, please follow starting process with OPMNCTL

Start services using OPMNCTL

This step is not required if you have started the services successfully using EM (previous step)

Open a command prompt, navigate to /essdata1/OBIEE11g/instances/instance1/bin

run “opmnctl status, this will show you status of all the OBIEE core services

run “opmnctl startall” or “opmnctl stopall” depending on your need

The list of possible users is given in section Error! Reference source not found.

Verify the Spatial & Mapviewer connection

Go to Administration --> Manage Map Data.

Click the "Layers" tab.

Click the "Add Layer" link. The data source dropdown at the top should contain at least one entry, one of which should be "OBIEE_NAVTEQ_Sample".

Click the OBIEE_NAVTEQ_Sample entry. It should populate the listbox with all available layers in the data source "OBIEE_NAVTEQ_Sample".

Check the tabs "Background Maps" and "Images" and ensure that you can see "OBIEE_NAVTEQ_Sample" entry.