Oracle Bi Administration Tool 11.1.1.5
Posted on
Hyperion Essbase Integration with OBIEE.OBIEE can connect to multidimensional as well as relational sources Microsoft Analysis Services, SAP B/W, Essbase.Import process converts the multidimensional view into a relational view.Essbase cubes, dimensions, hierarchies converted to a logical relational star schema.Essbase data can then be combined with data from sources.OBIEE 11g introduces new OLAP query capabilities making Answers a first-class ad-hoc query tool for Essbase cubes.Other use case is to bring in budget, forecast data etc from Essbase and use to enhance relational data. Before starting this tutorial, you should: 1. Have installed Oracle Business Intelligence Enterprise Edition 11.1.1.5 and its components. Have installed the Financial Management client and the Financial Management ADM driver on the same server as Oracle Business Intelligence Enterprise Edition. Have installed Shared Services. Have created the Financial Management application that you want to analyze with Oracle Financial Management Analytics.
Have registered the Financial Management application in the Financial Management client on the Oracle Business Intelligence Enterprise Edition server. Have ensured that the administrative user for Oracle Financial Management Analytics has write access to the directory that is used for the installation and has administrative rights to all associated software. Have created the FCCOFMA table. See the 'Creating the FCMOFMA Table for Financial Close Management for Oracle Databases Only' section of Oracle Hyperion Financial Management Analytics Administrator Guide for details.(Financial Close Management dashboards only.) 8.
Have created the required FCM database views. For details, see 'Setting Financial Close Management Views on Oracle Databases Only' section in the Oracle Financial Management Analytics Administrator Guide for details. (Financial Close Management dashboards only.). Download and unzip the Oracle Financial Management Analytics installer files from Oracle edelivery. Double-click setup.exe.
Note: there are separate installers for 32-bit and 64-bit installations. Select the installer version that is appropriate for your environment. In this tutorial, you install the 32-bit version. Oracle Universal Installer is displayed. Review the Welcome panel, and click Next.
On the Select Installation Type panel, select Complete, and click Next. The complete installation automatically installs the following components of the application:. Repository (FinancialManagementAnalytics.rpd), which contains metadata such as subject area, metrics, and dimensions. Note: the default password for the repository is welcome1.
Oracle Business Intelligence Presentation catalog (FinancialManagementAnalytics), which contains reports and dashboards. Oracle Financial Management Analytics Configuration Utility.
Note: English is the default language for Oracle Financial Management Analytics. If you want to use a different language, click Product Languages. For details, see 'Setting the Application Language' in the Oracle Financial Management Analytics Administrator Guide. On the Specify Home Details panel, enter the following details for the installation, and click Next.
Enter the name of the installation. By default, the name is OraOFMAx, where x is the number of the previous installation of Oracle Financial Management Analytics + 1. Enter the path, or browse to the location where you want to install Oracle Financial Management Analytics. By default, the path is C: OFMAHomex, where x is the number of the previous installation of Oracle Financial Management Analytics + 1. On the Summary panel, review the components to be installed, and click Install. Oracle Universal Installer installs the product with the specified options. On the End of Installation panel, confirm that the installation was successful, and click Exit.
At the exit prompt, click Yes. You successfully installed Oracle Financial Management Analytics. Running the Configuration Utility. In this topic, you run the configuration utility to configure Oracle Financial Management Analytics. Select Start, then All Programs, then Oracle Financial Management Analytics, and then Configuration Utility. Oracle Financial Management Analytics Configuration Utility is displayed.
In the Catalog And Repository Details section, click Browse next to the Catalog Location field. The Select Catalog Location dialog box is displayed. Select FinancialManagementAnalytics, and click OK. By default, the catalog is located in C: OFMAHome1 OFMA.
In the Catalog And Repository Details section, click Browse next to the Repository Location field. The Select RPD File dialog box is displayed.
Select FinancialManagementAnalytics.rpd, and click OK. By default, the catalog is located in C: OFMAHome1 OFMA.
In the BI Admin Server Details section, complete these fields for Oracle Business Intelligence Enterprise Edition:. In Host Name, enter the server name where Oracle Business Intelligence Enterprise Edition is installed. In Port, enter the port number. In User Name, enter the Oracle Business Intelligence Enterprise Edition user name. In Password, enter the password.
In the HFM Server Details section, complete these fields for Financial Management:. In Server Name, enter the name of the cluster or server where the Financial Management application is deployed.
In Application Name, enter the name of the Financial Management application. In User Name, enter the user name of the Financial Management administrator associated with the application. In Password, enter the password of the Financial Management administrator associated with the application.
The Configuration Utility connects to the specified Financial Management application and reads the dimension hierarchy information. This information is used to configure the dashboards in the next several steps. On the Entity dimension screen, perform the following actions:. Select the regional entities to be displayed on the dashboards.
You select only the parent regions that you want to drill down from in the reports. Click the right arrow button to move them to the Regions section. Click Next.
On the Account dimension screen, perform the following actions:. Select an account group from the drop-down list, such as Balance Sheet Accounts, Income Accounts, or Performance Indicators Accounts. In the Account Hierarchy list, select the accounts to be displayed on the dashboards. You must select at least one account for each account group, but you may select as many as you need. Click the right arrow button to move them to the Accounts section. Continue selecting accounts and account groups until you have selected at least one account for each account group.
Click Next. Note: For the Performance Indicator account group, the accounts that you select are displayed in the Associate Account drop-down list on the next screen. You must select four accounts. If you select more than four, the additional selections are not displayed in the report.
On the Performance Indicators screen, perform the following actions:. Select an associate account from the drop-down list. The accounts in this list are the accounts that you selected in the previous screen for performance indicators.
Select the accounts to be associated with the performance indicator. You must select at least one account for each performance indicator, but you may select as many as you require.
In this example, for the QuickRatio Performance Indicator account, the associate accounts are Current Assets (111000), Inventory (112000), and Current Liabilities (211000). Click the right arrow button to move them to the Performance Ratio section. Continue selecting accounts and performance iIndicators until you have selected at least one account for each performance indicator. Click Next. On the Product Dimension screen, perform the following actions:.
In the Select Product drop down list, select the custom dimension that contains the product hierarchy in your application. In this example, you select Custom1.
Select the required products. You can choose multiple products. Click the right arrow button to move them to the Products section. Click Next. On the Currency Constant Rate Dimension screen, perform the following actions:. In the Select Currency Rate drop-down list, select the custom dimension that contains the hierarchy for performing constant rate analysis in your application.
Oracle Bi Administration Tool For Obiee
If your application does not use a custom dimension for constant rate analysis, select Scenario. In this example, you select Custom3. Select the ConstantRate hierarchy. This setting is used to neutralize fluctuating currency values so that changes in exchange rates do not incorrectly reflect as a profit or loss. For details, see the Oracle Financial Management Analytics Administrator’s Guide for details. Click the right arrow button to move it to the Constant Rate section.
Click Next. On the Default Dimension Member screen, set the default point of view (POV) for the dashboards by performing the following actions:. Select a dimension from the Default Dimension drop-down list. Select the default member for each POV dimension.
Click the right arrow button to move the selected to the Default Member section. Repeat steps a through c for the following dimensions:. Scenario. Year.
Period. View. Entity. Value. Click Next.
Complete the following information to enable connection between Financial Management and Oracle Business Intelligence Enterprise Edition:. Select Perform OPMN Changes Required to Connect to HFM Data Source. Note: This step is required only when you perform a first-time configuration. For OPMN File Path, enter the full path to the opmn.xml file, or click the Browse icon to navigate to the full path to the opmn.xml file. Select Upload Repository. Enter and confirm the RPD password for the selected repository. Select Upload Catalog to upload the Oracle Financial Management Analytics catalog to the business intelligence (BI) server.
Click Next. On the Summary screen, review your selections, and click Submit. Verify that all changes were completed successfully, and click OK. Note: This operation may take several minutes as the services are restarted.
Oracle Financial Management Analytics Configuration Utility closes. Setting Connection Pool Parameters. After uploading the repository to the BI Server, you must open the repository in online mode and define the connection parameters in the Oracle Financial Management Analytics repository (RPD) file to enable the connection between Oracle Financial Management Analytics and the Financial Management application. Select Start, then All Programs, then Oracle Business Intelligence, and then BI Administration.
The Oracle BI Administration Tool is displayed. Select File, then Open, and then Online. Perform the following actions:. For Repository Password, enter the password for the RPD file. For User, enter the Oracle BI administrator user name. For Password, enter the Oracle BI administrator password. Optional: select Load all objects on startup.
Click Open. The repository is opened in online mode. In the Physical layer panel, expand HFM, and double-click on Connection Pool. At the prompt to check out connection pool, click Yes. In the URL field, enter the Financial Management server or cluster name and the application name to which you want to connect, and click OK.
Use the following format. In this topic, you set the Financial Management application name in the RPD file. In the Oracle BI Administration Tool, on the Physical layer, expand HFM, and double-click HFM Application. At the prompt to check out HFM Application, click Yes. The Cube Table dialog box is displayed. In the External Name field, enter the name of your Financial Management application, leave all other settings at their default values, and click OK. Note: If your application name contains restricted characters, you can use the string “OFMA”.
Renaming Custom Dimensions. After you install Oracle Financial Management Analytics, the custom dimension names in the Oracle Financial Management Analytics repository files are displayed as placeholders, such as Custom1, Custom2, Custom3, and Custom4. If your Financial Management application uses aliases for the custom dimensions, you must rename these placeholder values to reflect the custom dimensions in your application (for example, “Products,' “Customers,' or “Sales Channels”). In the Oracle BI Administration Tool, on the Physical layer, perform the following actions:. Expand HFM. Expand HFM Application.
Double-click Custom1. At the prompt to check out Custom1, click Yes. The Physical Dimension - Custom1 dialog box is displayed.
Perform the following actions:. In the Name field, enter the name of the associated custom dimension in the selected Financial Management application. In this example, you enter Products. In the Default Member field, enter a valid member value corresponding to your application.
In this example, you enter Total. Expand the renamed Custom1 dimension to display all members in the hierarchy, and double-click Custom1. At the prompt to check out Custom1, click Yes. The Physical Hierarchy - Custom1 dialog box is displayed. Select the Levels tab, and perform the following actions:. In the Name field, enter the name of the associated custom dimension in the selected Financial Management application. In the expanded Custom1 dimension list, double-click the first column in the database hierarchy.
The Physical Dimension - Custom1 dialog box is displayed. At the prompt to check out Custom1 ClassType, click Yes.
The Physical Cube Column dialog box is displayed. Perform the following actions:. In the Name field, modify the database column name to reflect the name of the column in the associated Financial Management application.
In this example, you change Custom1 ClassType to Products ClassType. Repeat steps 7, 8, and 9 for each column in the custom dimension. Repeat steps 1 through 10 for each additional custom dimension; for example, Custom2, Custom3, and Custom4. Click Check In Changes to check in your selections. Select File, and then Save to save your selections. Setting Default Members in the RPD File.
In this topic, you use the Oracle BI Administration Tool to set the default member values in the online repository file (RPD). In the Oracle BI Administration Tool, on the Physical layer, perform the following actions:. Expand HFM.
Expand HFM Application. Double-click Account. At the prompt to check out Account, click Yes.
The Physical Dimension - Account dialog box is displayed. Select the Hierarchies tab, and perform the following actions:. In the Default Member field, enter the default member for the Account dimension from the Financial Management application. Repeat steps 1, 2, and 3 for the remaining dimensions. Click Check In Changes to check in your selections. Select File, and then Save to save your selections. Select All Programs, then Oracle Business Intelligence, and then Stop BI Services.
At the prompt, enter your Oracle WebLogic admin user name and password, and press Enter. Oracle BI services are stopped. Select All Programs, then Oracle Business Intelligence, and then Start BI Services. Oracle BI services are started.
The connection pool, custom dimension names, and other configuration details are updated. Launching Oracle Financial Management Analytics.
In this topic, you access Oracle Financial Management Analytics in a web browser. In a browser, enter the URL for Oracle Business Intelligence Enterprise Edition. The URL is in the format name:port number/analytics, where:. Server name is the name of the computer hosting the Oracle Business Intelligence Enterprise Edition server. Port is the Oracle Business Intelligence Enterprise Edition server port number. Analytics is the Virtual Directory set for Oracle Financial Management Analytics on the Oracle Business Intelligence Enterprise Edition server. The Oracle Business Intelligence Enterprise Edition Sign-In screen is displayed.
Perform the following actions:. Enter the user ID for the Financial Management administrator. This user must have the required permission in both Financial Management and Oracle Business Intelligence Enterprise Edition. Enter the password for the Financial Management administrator.
Click Sign In. Oracle Business Intelligence Enterprise Edition is displayed. Select Dashboards, and then Oracle Financial Management Analytics. Verify that the Oracle Financial Management Analytics dashboard tabs are displayed.
HFM Connectivity with OBIEE. As part of that i was testing the HFM connectivity that was introduced in BI EE 11.1.1.3. In this post i shall be covering the basics of how the integration works in general. I will follow this post up with a more in-depth walk through of the connectivity in the next part.
Before we get into the details, couple of points to keep in mind. BI EE 11.1.1.3 is certified only on HFM 11.1.2(though will work with the older releases). If you are on HFM 11.1.1.3 or HFM 9.3.3, you need to upgrade BI EE to 11.1.1.5. This looks good.
And it does seem to generate the right queries as well. But what are the queries that get generated? They are not normal SQL queries. Also, how does BI Server generate them. Does it delegate all the data extraction to the ADM driver natively or does it let JavaHost extract the data. If it is the latter, it will be very interesting as this is the first time i am noticing JavaHost being used for data extraction from within BI Server. Perhaps this is how the planned BI EE 11g-Planning integration will work in the future.
Anyway to answer these queries, i will follow this post with another one with more details. Embedding OBIEE11g into EPM 11.1.2.1 Workspace. Prerequisites. A working OBIEE 11g install.
Working OFMA dashboards (to come in more detail later post). A working 11.1.2.1 environment ENABLE IFRAME Being a web based application ideally we could embed OBIEE into the EPM workspace much like a web portal. If you try it fails with “OBIEE content cannot be displayed in an IFrame”. Follow the below steps to remove it. 1) Locate the instanceconfig.xml file at the location: OBIEEHOME instances instance1 config OracleBIPresentationServicesComponent coreapplicationobips1.
Update the instanceconfig.xml file to add the highlighted entry within the 'security' tag (possible values are 'allow', 'prohibit' and 'sameDomainOnly'): allow 210 Now, this will only get you half way. You'll still run into the error, which really doesn't help you any. The 2nd piece is as follows: 2) Edit the 'web.xml' file at the following location: OBIEEHOME oracleBI1 bifoundation web app WEB-INF Add the following highlighted entry to the file. The syntax is the opposite of what the syntax for instanceconfig.xml is, since the 'never' means to never block the rendering within IFrame (you can choose 'never' to always allow rendering in the IFrame, or 'differentDomain' to only allow rendering if it is in the same domain). SAWBridge /saw.dll/.
RelatedContent /RelatedContent oracle.adf.view.rich.security.FRAMEBUSTING never CLIENT-CERT. Now to look at the GO URL Sample GO URL: As you see above the following are the parameters.
PortalPath (Direct path to the Dashboards). Page (This points to the page within the dashboard). nquser (Username).
nqpassword (Password) But if you want more customizations the only way is to create custom styles and skins. Lets test out the above GO URL.
Oracle Bi Administration Tool
Are you in need of uninstalling Oracle BI Publisher Desktop 11.1.1.5.0 to fix some problems? Are you looking for an effective solution to completely uninstall it and thoroughly delete all of its files out of your PC? This page provides detailed instructions on how to completely uninstall Oracle BI Publisher Desktop 11.1.1.5.0. Possible problems when you uninstall Oracle BI Publisher Desktop 11.1.1.5.0. Oracle BI Publisher Desktop 11.1.1.5.0 is not listed in Programs and Features. You do not have sufficient access to uninstall Oracle BI Publisher Desktop 11.1.1.5.0. A file required for this uninstallation to complete could not be run.
An error has occurred. Not all of the files were successfully uninstalled. Another process that is using the file stops Oracle BI Publisher Desktop 11.1.1.5.0 being uninstalled. Files and folders of Oracle BI Publisher Desktop 11.1.1.5.0 can be found in the hard disk after the uninstallation. Oracle BI Publisher Desktop 11.1.1.5.0 cannot be uninstalled due to many other problems.
An incomplete uninstallation of Oracle BI Publisher Desktop 11.1.1.5.0 may also cause many problems. So, it's really important to completely uninstall Oracle BI Publisher Desktop 11.1.1.5.0 and remove all of its files. How to Uninstall Oracle BI Publisher Desktop 11.1.1.5.0 Completley? Method 1: Uninstall Oracle BI Publisher Desktop 11.1.1.5.0 via Programs and Features. When a new piece of program is installed on your system, that program is added to the list in Programs and Features. When you want to uninstall the program, you can go to the Programs and Features to uninstall it.
So when you want to uninstall Oracle BI Publisher Desktop 11.1.1.5.0, the first solution is to uninstall it via Programs and Features. Open Programs and Features. Windows Vista and Windows 7 Click Start, type uninstall a program in the Search programs and files box and then click the result. Windows 8, Windows 8.1 and Windows 10 Open WinX menu by holding Windows and X keys together, and then click Programs and Features. Look for Oracle BI Publisher Desktop 11.1.1.5.0 in the list, click on it and then click Uninstall to initiate the uninstallation. Method 2: Uninstall Oracle BI Publisher Desktop 11.1.1.5.0 with its uninstaller.exe. Most of computer programs have an executable file named uninst000.exe or uninstall.exe or something along these lines.
You can find this files in the installation folder of Oracle BI Publisher Desktop 11.1.1.5.0. Go to the installation folder of Oracle BI Publisher Desktop 11.1.1.5.0. Find uninstall.exe or unins000.exe.
Double click on its uninstaller and follow the wizard to uninstall Oracle BI Publisher Desktop 11.1.1.5.0. Method 3: Uninstall Oracle BI Publisher Desktop 11.1.1.5.0 via System Restore.
System Restore is a utility which comes with Windows operating systems and helps computer users restore the system to a previous state and remove programs interfering with the operation of the computer. If you have created a system restore point prior to installing a program, then you can use System Restore to restore your system and completely eradicate the unwanted programs like Oracle BI Publisher Desktop 11.1.1.5.0.
You should backup your personal files and data before doing a System Restore. Close all files and programs that are open. On the desktop, right click Computer and select Properties. The system window will display.
On the left side of the System window, click System protection. The System Properties window will display. Click System Restore and the System Restore window will display. Select Choose a different restore point and click Next. Select a date and time from the list and then click Next. You should know that all programs and drivers installed after the selected date and time may not work properly and may need to be re-installed.
Click Finish when the 'Confirm your restore point' window appears. Click Yes to confirm again. Method 4: Uninstall Oracle BI Publisher Desktop 11.1.1.5.0 with Antivirus.
Nowadays, computer malware appear like common computer applications but they are much more difficult to remove from the computer. Such malware get into the computer with the help of Trojans and spyware.
Other computer malware like adware programs or potentially unwanted programs are also very difficult to remove. They usually get installed on your system by bundling with freeware software like video recording, games or PDF convertors.
They can easily bypass the detection of the antivirus programs on your system. If you cannot remove Oracle BI Publisher Desktop 11.1.1.5.0 like other programs, then it's worth checking whether it's a malware or not. Method 5: Reinstall Oracle BI Publisher Desktop 11.1.1.5.0 to Uninstall.
When the file required to uninstall Oracle BI Publisher Desktop 11.1.1.5.0 is corrupted or missing, it will not be able to uninstall the program. In such circumstance, reinstalling Oracle BI Publisher Desktop 11.1.1.5.0 may do the trick. Run the installer either in the original disk or the download file to reinstall the program again. Sometimes, the installer may allow you to repair or uninstall the program as well. Download minecraft android free. Method 6: Use the Uninstall Command Displayed in the Registry.
When a program is installed on the computer, Windows will save its settings and information in the registry, including the uninstall command to uninstall the program. You can try this method to uninstall Oracle BI Publisher Desktop 11.1.1.5.0. Please carefully edit the registry, because any mistake there may make your system crash.
Hold Windows and R keys to open the Run command, type in regedit in the box and click OK. Navigate the following registry key and find the one of Oracle BI Publisher Desktop 11.1.1.5.0: HKEYLOCALMACHINE SOFTWARE Microsoft Windows CurrentVersion Uninstall c. Double click on the UninstallString value, and copy its Value Data. Hold Windows and R keys to open the Run command, paste the Value Data in the box and click OK. Follow the wizard to uninstall Oracle BI Publisher Desktop 11.1.1.5.0.
Method 7: Uninstall Oracle BI Publisher Desktop 11.1.1.5.0 with Third-party Uninstaller. The manual uninstallation of Oracle BI Publisher Desktop 11.1.1.5.0 requires computer know-how and patience to accomplish. And no one can promise the manual uninstallation will completely uninstall Oracle BI Publisher Desktop 11.1.1.5.0 and remove all of its files. And an incomplete uninstallation will many useless and invalid items in the registry and affect your computer performance in a bad way. Too many useless files also occupy the free space of your hard disk and slow down your PC speed. So, it's recommended that you uninstall Oracle BI Publisher Desktop 11.1.1.5.0 with a trusted third-party uninstaller which can scan your system, identify all files of Oracle BI Publisher Desktop 11.1.1.5.0 and completely remove them. Download this powerful third-party uninstaller below.
Awards Testimonials My game refused to reinstall after I uninstalled it from my laptop. And I was told to completely uninstall it from the computer first. And I googled it and found your tutorial. It really helped me completely remove the game.
And now I can reinstall it. Thank you so much! -Alice M, US Your site really provides the most comprehensive and detailed uninstall guide.
I could easily follow your steps and got rid of my program.Bernard B, CA Great! I can easily uninstall my software now and there is no folder of the software left in my hard drive. Thanks for your instruction!
-Henry P, UK Recent Posts. Categories. Search for.