HyperionSolutions

Hello friends, I faced this issue today which I would like to share with you all, it shows how simple manual mistakes can sometimes cause crucial errors. Goal: I was trying to launch one of the Calc All scripts for my production application which failed with an error saying "Failed to execute the Calculation script" Issue: When I went through the logs ; I find the following issue: java.io.IOException: Server returned HTTP response code: 503 for URL: http://<servername>:19000/eas/eas The issue is when the script is run from 19000 port it fails with the above error in the logs but at the back end if you rectify the process is still running and the .pag files will be building as expected. So you do not see any difference at the process end except for this error. However, it is ideal to run the process through the correct port that is the 10080 port, which will not throw any error. Its a small error but can be misleading sometimes .. hope this po

Smart View is a tool that allows you to pull Hyperion Planning data web forms into Excel. Once a form is in Excel, you can essentially perform all the same functions that you can in Planning web. With Smart View, you can input data and save it to Essbase, use the adjust data feature, enter supporting detail and cell text, and run business rules and calc scripts. You even have the same look and feel as a web form with expandable parent members, page drop-down boxes, green read-only cells, and yellow updated cells. Offline Planning is a Smart View tool that allows you to take your Planning forms offline and enter data, run business rules, calc scripts and it has the same look and feel as the normal forms on Smart View with the only exception that to work on these forms you need not be connected to the server. Steps summarized to take Planning forms Offline: The process for taking a Planning data form offline in version 11 is fairly simple: •The application has to first be enabled

You connect to data sources through shared or private connections. Shared Connections •Shared connections are stored in a central location and are available to multiple users through the Smart View Panel. You cannot add, edit, or rename shared connections, but you can save them as private connections, which you can edit and rename. Private Connections •Private connections are those that you create by saving a shared connection to your local computer or by entering a URL to a provider that is not configured for shared connections. When you create a private connection, it becomes the active connection. Shared Connections : 1. From the Smart View ribbon, click  Panel . 2. From Smart View Home or from the menu displayed when you click the arrow next to Home button, do one of the following: • Click a connection name under  Recently U sed . You can click    to pin items to this list. • Select  Shared Connections  to open the Shared Connections panel, where you s

Planning 11.1.2.3 – Smart View metadata management One of the new features in planning 11.1.2.3 is the ability to manage dimensional metadata through Smart View  • The new Hyperion Planning Admin Extension for Smart View allows Oracle Hyperion Planning administrator users to import and work with metadata in Smart View. • With this extension, Planning administrators can use Oracle Hyperion Smart View for Office applications to perform these tasks: 1. Add, edit and import existing Oracle Hyperion Planning dimensions and members, including moving members and designating members as shared in Smart View 2. Create and refresh cubes • The extension can be downloaded from the Tools menu in workspace. • This will download a file called “ PlanningSVExtension.msi ” which is 1.4mb in size and can be easily installed by running the msi . Once you Install Planning Admin Extension A Smart View Set up Wizard opens up for the extension installation. Click on Next :

You can start your  OBIEE 11g installation after completing the prerequisites list. In the unzipped install files go to Disk 1 and run the setup.exe file (for Windows). This launches the Oracle Universal Installer. There are 12 steps in the installation process. And we’ll go through the most important ones in the following: Step 2 – choose installation type. For a test instance you can go on and choose the first option.  Step 3 – the installer verifies if your system meets the prerequisites to proceed.  Step 4 – you have to enter a location for the installation, but be careful and do not enter a location containing spaces.  Step5 – enter username and password. You will need these identification details to start and use OBIEE.  Step 6 – choose the desired components.  Step 7 – enter database details. Here you have the details corresponding to the database installed in the prerequisites sec

A reporting application is a target application on which you can report on and aggregate Planning data. The primary use cases: a. The reporting application contains data from any source, such as a data warehouse. You want to push new Planning data to it and report on the data. b. You want to report on Smart Lists in Planning, which you cannot do in Planning. You can map dimensions between source planning applications and reporting applications to enable: a. Reporting on planning data in a reporting application b. Aggregating and querying on Smart Lists, which are converted to regular dimensions in the reporting application? c. Linking Planning data to multiple reporting applications for various consolidations If you look at the broader level it does nothing but to export data and load the data to the target of course with specified mappings. Mapping can be of two types: Dimension to dimension : Displays the available unmapped dimensions in the Planning appl

Step 1 : Create a CSV file containing the outline members with parent-child relationships.   Make sure the header names are exactly same as specified. The Mandatory column headers are as follows:- “Parent”, “Dimension name”,  “Data Storage”, “Aggregation”, “Source Plan Type” and “Plan Type”. Step2: Go to Server where Hyperion Planning is installed. Step 3: Login . Enter the Credentials. Step 4: Once login is done, outline load utility path is - /Hyperion/Oracle/Middleware/user_projects/epmsystem1/Planning/planning1                 Copy the CSV file here in this path. Step 5: Navigate to following utility path through command prompt -/Hyperion/Oracle/Middleware/user_projects/epmsystem1/Planning/planning1 Step 6: Type Outline Load utility command with proper syntax.             ./OutlineLoad.sh /S:<Server Name> /A:<Application Name> /U:<username> /I:<File Name> /D:<Dimension Name> /L:<Log File> /X:<Error File&