edit the tag, add the attribute visualEffects=“NONE” so it looks like the following
<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.
Setting online configuration through EM (default rpd and webcat paths)
EM screen also offers you the possibility of turning OBIEE cache on or off. Leaving cache set to off will allow tosee physical SQL logs for every query. Performance should not be of issue with the low data volume in the sampledatabase. To Switch Cache off, click on tab “Capacity Management”, sub-tab “Performance”. Disable cache thereand click on Activate changes.
Deploying SampleApp BIP Content
Sample schema OE
The Oracle Sample OE schema (Order Entry) needs to be installed as part of the database samples in order for some of the BIP examples to work.
alter user OE account unlock;
alter user OE identified by OE;
Data Sources
From the web UI – http://localhost:9704/analytics – logged in with the user biadmin (with Admin permissions), click on the Administration link > Manage BI Publisher > Data Sources:
JDBC Connection.
For the demo connection enter your parameters for the connnection string (e.g. jdbc:oracle:thin:@WINDOWS11G:1521:DB11GR2)) and be careful that the case of the password and user is important.
Create also a BISAMPLE connection for the BISAMPLE user
Test the “Oracle BI EE” JDBC connection
File Connection
Verify that you have files in the demo files directory
Grant access to data sources
For users to be able to see data when they run BIP reports, the BI Author & BI Consumer roles must be granted access to data sources.
Under Administration URL in OBIEE web interface, click on “Manage BI Publisher” > “Security Center” > Roles and Permissions.
In the Add Data Sources column, click the “key” icon for the BI Author role & BI Consumer to add access to the database connection and to the demo files.
Verify that you can login with the credentials abell/Admin123 otherwise you must repeat the user import step (FMW_Users_Definition)In the folder 3_SampleApp_XXXX_Actions/ Actions_Definitions, you find tree files:
ActionSamples.ear. The application
ActionsSamples V3 (Jdev_project).zip. The application source code
CreateCred.py
Deploying Sample Actions services in WLS
Copy the file ActionsSamples.ear in the folder \FMWHome\instances\instance1\bifoundation\OracleBIServerComponent\coreapplication_obis1\sample\SampleAppFiles\Actions
If the port of the analytics application has changed (is not 9704), you must change the following entries in the files below.They are all located in the same directory :/InstallHome/user_projects/domains/bifoundation_domain/servers/bi_server1/tmp/_WL_user/ActionSamples/XXXXXX/war/
“CreateCred.py” is located in the same directory that the application ear file
username and password are the admin credential of the weblogic server.
Actions configurations files
If the ports of the weblogic server (AdminServer and bi_server) have changed, open the file ActionFrameworkConfig.xml and change them.Copy the XML files:
ActionFrameworkConfig.xml
ActionsSAMLPolicy.xml
wss_username_token_policy.xml
into the following directory:/FMWHome/user_projects/domains/bifoundation_domain/config/fmwconfig/biinstances/coreapplicationCopy the file:
default-keystore.jks
into the following directory:/FMWHome/user_projects/domains/bifoundation_domain/config/fmwconfig
Run the script OBIEE_NAVTEQ_USER.SQL to create the Navteq user
-- USER SQL
CREATE USER obiee_navteq IDENTIFIED BY obiee_navteq DEFAULT TABLESPACE USERS QUOTA UNLIMITED ON USERS ;
-- ROLES
GRANT "CONNECT" TO obiee_navteq;
GRANT "RESOURCE" TO obiee_navteq;
As user obiee_navteq, run the script OBIEE_NAVTEQ_INSERT.SQL to insert data into the user_sdo views.
insert into user_sdo_maps select * from my_maps;
insert into user_sdo_themes select * from my_themes;
insert into user_sdo_styles select * from my_styles;
insert into user_sdo_cached_maps select * from my_tile_cache;
commit;
Go to the Mapviewer Administration console: http://host:port/mapviewer > Admin Link. Enter the weblogic Administrator credential
Click on configuration and made the changes below with your own parameters (IP, Host, SID, …).
Replace the security_config node with this content:
<security_config>
<!-- if you wish to disable direct XML based info requests from
MapViewer's requests web page, set the following value to true.
-->
<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>
<!-- Add remote URLs that this MapViewer's built-in proxy servlet
is allowed to communicate with. URLs should be separated by a comma.
-->
<proxy_enabled_hosts>
localhost.com,http://www.localhost.com,http://localhost:9704/mapviewer,http://localhost:9704/,
http://192.168.2.247:9704/,http://192.168.2.247:9704/mapviewer,http://windows11g:9704/mapviewer,
http://windows11g:9704/,http://10.10.10.10:9704/,http://10.10.10.10:9704/mapviewer
</proxy_enabled_hosts>
</security_config>
Add this Predefined Data Sources at the end of the file
On the Data sources link, you should now see OBIEE_NAVTEQ_Sample.
To confirm that the Mapviewer configuration is working, in the page Manage Map Tile Layers > Manage, 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.
Did you notice the difference ? Copy the files in the good location and retry your deployment.
No application files exist at
When attempting to restart the ActionSample Appliation, you can get this error:
weblogic.management.DeploymentException: [Deployer:149003]Unable to access application source information in
'E:\MiddelwareHome\user_projects\domains\bifoundation_domain\servers\bi_server1\stage\ActionSamples\ActionSamples.ear'
for application 'ActionSamples'. The specific error is: [Deployer:149158]No application files exist at
'E:\MiddelwareHome\user_projects\domains\bifoundation_domain\servers\bi_server1\stage\ActionSamples\ActionSamples.ear'..