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.
<ServerInstance>
...
<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
Login to the EM administration screen using the url http://eicfxxxx.ebiz.xxxx.com:6001/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
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
<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
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”
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
/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.
<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>
<
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
Login into http://eicxxx.ebiz.xxxxx.com:6001/analytics
The list of possible users is given in section Error! Reference source not found.
Verify the Spatial & Mapviewer connection
Login to Answers.
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.
