HyperionSolutions

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 ...

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 Nam...

LCM has a graphical interface to take backup of the applications and Foundation services. We can also take backup using a command line utility which again can be used to automate and schedule backups. The following steps are needed to be followed in order to do automation of Shared Services or Application backup. Here the steps are shown of automation of backup of Foundation services. Same steps hold true for any Planning Application as well. The steps are as follows:       1)      First you need to login to Shared Services to create a migration definition xml. 2)    Go to Application Groups-> Foundation-> Shared Services and select all artifacts and click on Define Migration . 3) Click on NEXT. 4)  Select Destination as File system and give a name like – ‘SharedServicebkup’. 5)  Click on next. 6)  Click on Save Migration Definition. 7)    A pop up opens asking you to save th...

There will be a huge number of requests to grant or remove security access for users. For one or two changes, it is simple task, click on member and then assign access and grant permission. It becomes tiresome when we need to make changes for large number of members. It involves considerable amount of time. Automating the security changes saves considerable amount of time. The ImportSecurity utility in planning loads access permissions for users or groups from a text file into Planning. Importing access permissions using Import security utility overwrites existing access assignments only for imported members, users, or groups. All other existing access permissions remain intact. The SL_CLEARALL parameter clears all existing access permissions. ImportSecurity utility is located at /Hyperion/Oracle/Middleware/user_projects/epmsystem1/Planning/planning1 on Planning server as shown in the following picture: Steps for importing access permissions: STEP1 :Create a text...

Preparing Encrypted Username and Password: Generate Public and Private keys using essmsh -gk Note: Public key is for Encryption, Private key is for Decryption 1.        Encryption: Create one text or maxl script with username and password (login credentials of the Essbase) Login <Administratorname>  <Password> on <ServerName> Encrypt Username and password:  (Using Encryption Code) essmsh -E C:\Anvi\maxl\login.txt 32171,1911896561 After executing this, essmsh will create one file (login.txts) with encrypted username and password as shown below   Use this encrypted Username and Password for log in in your Maxl scripts. Thanks!!

Using single batch script, we need to update If we enter Current Month(CurrMonth), then automatically Previous month(PriorMonth), Next Month(NextMonth) will update automatically. If we enter Current Year(CurrYear), then automatically Previous Year(PriorYear), Next Year (NextYear) will update automatically. We can create substitution variables using MAXL Script but for updating them automatically here we are using batch script and retrieving the values of Current Year, Current Month from the local machine time and then subsequently updating those values to get Next Month, Previous Month as well as Next Year and Previous Year. Maxl Script: ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ login 'admin' 'password' on '<servername>'; alter database 'App'.'Plan1' set variable 'CurrMonth' $CurrMonth; alter database 'App'.'Plan1' set variable 'PriorMonth' $Prio...

You might get an error sometimes saying  "Application is in maintenance mode. New logins are not allowed". ·           For this you  will  need to change the application settings to allow all users to log into the application. To do this, log in with an administrator id. Then go to File -> Preferences-> Advanced Setting. The change the selection in "Application Maintenance Mode" drop down box.         Thanks!!

“ The Request Timed Out. Contact your Administrator to Increase netRetryCount and netRetryInterval. IE7 and IE8 & IE9 have a 30-second timeout when waiting for communication from the server. When adding form data, Smart View can take longer than 30 seconds to get confirmation from the Planning server that the changes were made and saved. A similar constraint exists for Essbase data. Pre update registry Settings Open the command prompt window by clicking the start  button   >Search bar >Key in regedit navigate to the below path and check the existing settings you might not have” KeepAlive,ServerInfo & ReceiveTimeout ” HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\InternetSettings Automated Resolution Steps 1)       Create a file called “test.reg” 2)       Edit the file in notepad. 3)       Add th...

You can copy versions using the Hyperion Planning Web client. You use the Copy Versions page to copy data from one bottom-up or target version of a selected scenario to another bottom-up or target version within the same scenario. You can copy between bottom-up and target versions, but keep in mind the following: When you copy to a bottom-up version, only selected level zero entities are copied. When you copy to a target version, all selected entities are copied. For example, you can create a Best Case version and then copy some or all of the data in that version to a Worst Case version to quickly create a starting point for the new version .To copy a version: 1. Open an application in the Hyperion Planning Web client. 2. From the Hyperion Planning Home page, click Copy Versions. 3. In the Scenario drop-down list, select the scenario you want to copy. 4. In the Copy From drop-down list, select the version from which you want to copy data. 5. In the Cop...

There are three things you can do to improve the performance of the Planning application. I. Increase the Java heap size: You can increase the heap to a maximum of 1Gb (1024Mb). If you have the available RAM to dedicate to Planning, it is recommended to increase both the minimum (Xms) and maximum (Xmx) heap size to 1024Mb. Increasing the minimum heap size will help because it lowers the overhead needed to manage garbage collection in a dynamically expanding heap. Do not exceed 1024Mb or you may see performance actually decrease. The step by step procedure for modifying the Java heap size varies from one web application server to another. Contact your web application administrator for assistance. II. Turn off process management for Version and Scenario members for which it is notneeded:  By default, new Scenario and Version members are enabled for process management.Each Entity-Scenario-Version...