Enterprise Transformations, It's all About Performance Management

First of all some basics of smart list: Administrators use Smart Lists to create custom drop-down lists that users access from data form cells. When clicking in cells whose members are associated with a Smart List (as a member property), users select items from drop-down lists instead of entering data. Users cannot type in cells that contain Smart Lists. Smart Lists display in cells as down arrows that expand when users click into the cells. Below link will give you more information on Smart Lists: http://download.oracle.com/docs/cd/E17236_01/epm.1112/hp_admin/enum_pg.html I got a simple query today, " The LCM process generates and indicates a status of "Complete", however, the 3,018 records do not appear in the Planning application. No error exists in the log to identify the problem ." Things which can be checked in this case: 1. Spaces are not allowed in the Entry Name, 2. Spaces are allowed in the Entry Label, 3. The nam...

Migrating BRs and BRs' Security to 11.1.2.2: As we are aware that, 11.1.2.2 no longer supports Business Rules as  calculation  module. If we are using BRs as  calculation  module in your current version, then How do we achieve this ? How do we migrate rules and more importantly the  security  from previous version to 11.1.2.2 ? Here is an example where we will be migrating rules and  security  from 11.1.1.3 to 11.1.2.2. Few consideration before we start: 1. Ensure that user directories and native users with the same SID are available when you upgrade Shared Services, since the security migration is done on the basis of SID, if SIDs are not in sync then the security won't be migrated  successfully , 2. If the HSS upgrade process is followed as documented then the SIDs will be in sync. 3. Ensure that the Planning applications are upgraded to the current release and are available in Calculation Manager under SYSTEM View, ...

We have an application with one plan type say its name is "console", now we want to migrate this application with a different plan type name say "con1". Here are the steps which will help you out with the same.  Note: Make sure the plan type name is less then 8 characters otherwise you will end up in issues.  You can take the file system backup of the application Once its done you can find the same at below location: Here I have name file system backup as "Backup", a xml name listing.xml contains the artifacts listing its present at Backup/info/: Plan type information is also stored in "Application Definition.xpad" file, location Middleware\user_projects\epmsystem1\import_export\<User>@Native Directory\Backup\resource\Configuration\Properties: You can also find a folder name with the Plan type name, in our case its "Console": Here I have taken a copy of File system backup an...

When it comes to 11.1.2.X, some times installation of common components fails, Common components includes installing essbaseProductCommonComponents, installing ocm, installing oracle_common, installing productCommonComponents,installing tools, installing commonComponents, installing essbase_integration_services, installing OUI etc. and we get fail status for OCM in installation summary logs: Completion status for ocm is Fail Fail [ Unknown ] installing ocm Fail ocm assembly was not saved in SoftwareRegistry. Fail commonComponents assembly was not saved in SoftwareRegistry. Summary: Fail In windows:   Install, com.hyperion.cis.OCMOracleHomeSetup, dbg, Finished with exit code 0 com.hyperion.cis.OCMOracleHomeSetup, wrn, OCM installation check failed: C:\Oracle\Middleware\EPMSystem11R1\ccr\bin\configCCR.exe does not exist or   In Linux:   Install, com.hyperion.cis.OCMOracleHomeSetup, wrn, OCM installation check failed: /opt/app/oracle/middleware/EPMSystem11R1/ccr/bi...

Some times when we drill down a member we get this error: "Cannot perform cube view operation. OLAP error (1020011): Maximum number of rows [5000] exceeded" this is because by default the max Rows setting for Analytic Provider Services is  5000. If needed we can increase the value for number of rows to be retrieved, this can be done by:  1.Open essbase.properties file,  1.a)Version 9.x: Open the HYPERION_HOME%\AnalyticProviderServices\bin\essbase.properties file  1.b)Version 11.x: Open the HYPERION_HOME%\products\Essbase\aps\bin\essbase.properties file 2. Look for the setting: "service.olap.dataQuery.grid.maxRows=5000", 3. Increase the value to the desired value, and yeah please take care of rows limitation of excel. [For 2003: 65,535; For 2007: 1,048,576] 4. Save the file, 5. Restart the APS Service. If you will set this value too high then: 1. You might need to increase caches, 2. you might get 1042017 Network erro...

If uninstaller is stuck somewhere during uninstallation then we can perform few things to  make  sure EPM is un-installed property. First of all   un-installation should be done by same  user  who installed it. Windows: If you are doing a clean uninstall make sure you: 1.  Delete environment variables like ARBORPATH, EPM_ORACLE_HOME,  ESSBASEPATH, HYPERION_HOME etc, 2.  Delete .oracle.instance file from Documents and Settings\<UserWhoInstalled>\, 3.  Delete set_hyphome.bat file from Documents and Settings\<UserWhoInstalled>\, 4.  Delete all the file left in Hyperion_Home, 5.  Delete BEA folder, 6.  Delete or rename installer records in Program Files\common files\InstallShield\, 7.  Delete Program Files (x86)\Oracle\ or Program Files\Oracle\inventory, 8.  Delete the Hyperion Solutions key under HKEY_LOCAL_MACHINE\Software, 9.  Dele...

Many time when we try to do some operation like loading metadata or data via ODI , while  refreshing data to Essbase etc we get error Planning application is locked. Few Ex: com.hyperion.planning.HspCubeRefreshInProgressException: Cannot complete your  request because the database is being refreshed. com.hyperion.odi.planning.ODIPlanningException:  com.hyperion.planning.ObjectIsLockedException  When ever we perform an operation where planning need to put a lock on any object an entry  goes to HSP_LOCK table. Planning enters a record in this table when it acquires a lock and  deletes the record the moment lock is released.  Lets refresh our database and check if we get any entry in HSP_LOCK table: Here are the records of HSP_LOCK table for App1:   I clicked refresh database for my application App1, let go back and check the records of this table: Once the refresh oper...