http://www.adistrategies.com/index.php?loc=news Expert Connect Updates from Adi Strategies en-us Sat, 18 May 2013 06:32:01 -0700 Sat, 18 May 2013 06:32:01 -0700 http://www.adistrategies.com Adi Strategies RSS generator contact@adistrategies.com contact@adistrategies.com http://www.adistrategies.com/index.php?loc=news&item=901 Latest System Requirements per release 2013-03-06 http://www.adistrategies.com/index.php?loc=news&item=901 http://www.adistrategies.com/index.php?loc=news&item=899 New Features in the 11.1.2.2 release by product 2013-03-06 http://www.adistrategies.com/index.php?loc=news&item=899 http://www.adistrategies.com/index.php?loc=news&item=623 How To: Create a folder with a timestamp, for Archiving purpose in an ODI Package. Solution: For creating a folder with the name in format “Archive_mm-dd-yyyY” (eg: Archive_05-11-2011) 2011-10-25 http://www.adistrategies.com/index.php?loc=news&item=623 http://www.adistrategies.com/index.php?loc=news&item=622 Technology: Hyperion Essbase, Essbase Excel Add-In, Smartview, Microsoft Excel Version: [Version 11.1.2, Excel 2007] Definition: After installing the Essbase Excel Add-in or Smartview, users 2011-10-25 http://www.adistrategies.com/index.php?loc=news&item=622 http://www.adistrategies.com/index.php?loc=news&item=621 Technology: ERPI Definition: Regarding the use of ERPI with EBS to pull statistical values from EBS, in order for ERPI to extract statistical values from EBS the client must have already configured 2011-10-25 http://www.adistrategies.com/index.php?loc=news&item=621 http://www.adistrategies.com/index.php?loc=news&item=620 Definition: Report rendered in HTML. Last column in both Month and YTD sets is a variance scenario. In HTML, the ActvPY scenario is shown for the Month period selection. When the report is rendered in 2011-10-25 http://www.adistrategies.com/index.php?loc=news&item=620 http://www.adistrategies.com/index.php?loc=news&item=619 Definition: Services are not starting in EPM 11.1.2.x with error Unable to open wallet Solution: Likely cwallet.sso got corrupted. You will need to delete the corrupted wallet file and recreate 2011-10-25 http://www.adistrategies.com/index.php?loc=news&item=619 http://www.adistrategies.com/index.php?loc=news&item=618 Technology: Hyperion Essbase Version: Version 11.1.2 Definition: When does Implicit sharing happen in essbase? And what are the ways we can define them in essbase config file.? Solution: 1) 2011-10-25 http://www.adistrategies.com/index.php?loc=news&item=618 http://www.adistrategies.com/index.php?loc=news&item=617 Definition: Shared Services Security Migration can be done in the following two ways : 1. LCM 2. Export and Import LCM Log on to Shared Services. Navigate to Foundation in Application 2011-10-25 http://www.adistrategies.com/index.php?loc=news&item=617 http://www.adistrategies.com/index.php?loc=news&item=616 Technology: ODI Version: 11G Definition: The Log files and error files are generated from the interfaces but the files are empty i.e. there is nothing written in the log or error file. The file 2011-10-25 http://www.adistrategies.com/index.php?loc=news&item=616 http://www.adistrategies.com/index.php?loc=news&item=615 How To: How to Invoke a MAXL script using Windows server. Solution: When automating an Essbase process using MAXL you will need to create a corresponding batch file to invoke the script on the server 2011-10-25 http://www.adistrategies.com/index.php?loc=news&item=615 http://www.adistrategies.com/index.php?loc=news&item=614 Technology: Windows Batch File Definition: For users who like to open multiple instances of excel and tend to have “ghost” instances of excel running and are unable to perform Essbase 2011-10-25 http://www.adistrategies.com/index.php?loc=news&item=614 http://www.adistrategies.com/index.php?loc=news&item=613 Technology: Hyperion Planning, Essbase, EPMA, DRM Version: Version 11.1.2 Definition: Often times when sharing hierarchies between Essbase and planning applications you will find that member 2011-10-25 http://www.adistrategies.com/index.php?loc=news&item=613 http://www.adistrategies.com/index.php?loc=news&item=612 Technology: Financial Reports Issue: Users are not able to access reports in Workspace in PROD Error: Can't find resource for bundle java.util.PropertyResourceBundle, key 9004 Troubleshooting 2011-10-25 http://www.adistrategies.com/index.php?loc=news&item=612 http://www.adistrategies.com/index.php?loc=news&item=611 Technology: Hyperion Financial Management Definition: Assuming that in your HFM system, Beg RE is a calculated account (pull total retained earnings from prior month), then how do you load data 2011-10-25 http://www.adistrategies.com/index.php?loc=news&item=611 http://www.adistrategies.com/index.php?loc=news&item=610 Technology: LCM Migration (Security) Version: Version 11.1.2 Issue: LCM migration of Shared Services security from source to target environment fails for LDAP users. Native users are migrated 2011-10-25 http://www.adistrategies.com/index.php?loc=news&item=610 http://www.adistrategies.com/index.php?loc=news&item=609 Technology: Workspace Batch Scheduler Issue: Batch Scheduler unable to send emails.User schedules a batch job in workspace to export reports to PDF and email it to a group of people. Group does 2011-10-25 http://www.adistrategies.com/index.php?loc=news&item=609 http://www.adistrategies.com/index.php?loc=news&item=608 Technology: Hyperion Data Relationship Management (DRM) Version: 11.1.2.1.101 Definition: While upgrading DRM from v9.3.2 to v11.1.2.1, encountered an issue while importing a metadata file into 2011-10-25 http://www.adistrategies.com/index.php?loc=news&item=608 http://www.adistrategies.com/index.php?loc=news&item=607 Definition: Common issues faced in OBIEE 11.1.1.5]   Solution: 1) Unable to Log in: Error connecting to Oracle BI Server: Could not connect to the oracle BI Server because it is not running 2011-10-25 http://www.adistrategies.com/index.php?loc=news&item=607 http://www.adistrategies.com/index.php?loc=news&item=606 Definition: How to hardcode values in the POV column while loading data through ODI. While loading data with ODI, some values may need to be hardcoded in the POV column. In that case, if each hardcoded 2011-10-25 http://www.adistrategies.com/index.php?loc=news&item=606 http://www.adistrategies.com/index.php?loc=news&item=605 How To: Use LCM command line utility to automate the shared services/planning application backup.   Solution: LCM has a graphical interface to take shared services and applications backup. 2011-10-25 http://www.adistrategies.com/index.php?loc=news&item=605 http://www.adistrategies.com/index.php?loc=news&item=538 How To: Update Substitution Variables via a script Solution: Updating a large number of substitution variables via the EAS client can be a cumbersome process. In order to complete 2011-05-17 http://www.adistrategies.com/index.php?loc=news&item=538 http://www.adistrategies.com/index.php?loc=news&item=537 Definition: Hyperion Planning Smart Lists set ups at times can be quite complex. The following article outlines the steps to create a Hyperion Planning Smart list. Hyperion Planning Administrators 2011-05-17 http://www.adistrategies.com/index.php?loc=news&item=537 http://www.adistrategies.com/index.php?loc=news&item=536 Definition: How to Sort Metadata in Planning Using ODI Goal: To sort members in Planning Metadata using ODI Interface. This will be helpful in a typical case where Metadata from an 2011-05-17 http://www.adistrategies.com/index.php?loc=news&item=536 http://www.adistrategies.com/index.php?loc=news&item=535 Definition: Problem with Smart view Symptoms: 1. After certain period of using the Smartview, User is not able to use the Smartview options in the Microsoft Excel. 2. In the same 2011-05-17 http://www.adistrategies.com/index.php?loc=news&item=535 http://www.adistrategies.com/index.php?loc=news&item=534 Definition: In Classic Planning, it can be very time consuming if you need to delete a member and all its shared members throughout the outline. Solution: Use the DeleteSharedDescendant 2011-05-17 http://www.adistrategies.com/index.php?loc=news&item=534 http://www.adistrategies.com/index.php?loc=news&item=533 Definition: Applications not visible when first opening Workspace, v. 11.1.2. Solution: In version 11.1.2, an additional step is required to initialize your Workspace web interface. Step 2011-05-17 http://www.adistrategies.com/index.php?loc=news&item=533 http://www.adistrategies.com/index.php?loc=news&item=532 Definition: In FDM, how can you manipulate the order of precedence of logic within a “like” mapping table? Solution: The order of precedence depends on the row position 2011-05-17 http://www.adistrategies.com/index.php?loc=news&item=532 http://www.adistrategies.com/index.php?loc=news&item=531 How To: Importing hierarchies from the EPMA interface tables, to either the Shared Library or directly to an application, using “Merge”, creates duplicate members under multiple 2011-05-17 http://www.adistrategies.com/index.php?loc=news&item=531 http://www.adistrategies.com/index.php?loc=news&item=530 Definition: We faced issues in case Workforce deployment after initialization of the module. The application is a single currency classic planning application with a custom Currency dimension. The 2011-05-17 http://www.adistrategies.com/index.php?loc=news&item=530 http://www.adistrategies.com/index.php?loc=news&item=529 Error : Error while sending command to HBR Server running within the EAS Server. This error comes when we try to open a business rule in EAS (9.3.1). Refer the image below. (See the attachment) Reason: “C:” 2011-05-17 http://www.adistrategies.com/index.php?loc=news&item=529 http://www.adistrategies.com/index.php?loc=news&item=528 Definition: Unable to connect to Planning applications through business rules in EAS Solution: 1.    On the EAS server, navigate to HYPERION_HOME/products/Essbase/eas/storage/easusers. 2.   2011-05-17 http://www.adistrategies.com/index.php?loc=news&item=528 http://www.adistrategies.com/index.php?loc=news&item=527 Definition: Dynamic Time Series (DTS) not working in Essbase Solution: In Hyperion Essbase, when you set dynamic time series (DTS), you can't have the time periods dimension name as 2011-05-17 http://www.adistrategies.com/index.php?loc=news&item=527 http://www.adistrategies.com/index.php?loc=news&item=526 Definition: There are a couple limitations with the ‘deploy’ command in Maxl: 1. Not working with Linux and 64 bit OS. 2. When two ‘deploy’ commands are launched simultaneously 2011-05-17 http://www.adistrategies.com/index.php?loc=news&item=526 http://www.adistrategies.com/index.php?loc=news&item=525 Definition: How to map unique values from a source data store to a target data store in ODI. While doing a straight mapping with ODI, columns of the source data source are mapped to those of the 2011-05-17 http://www.adistrategies.com/index.php?loc=news&item=525 http://www.adistrategies.com/index.php?loc=news&item=524 Definition: Deploy of Workforce was not successful[Error faced during first deployment of the application as Deploy of Workforce not Successful in EPMA Hyperion Planning 11.1.2] Solution: We 2011-05-17 http://www.adistrategies.com/index.php?loc=news&item=524 http://www.adistrategies.com/index.php?loc=news&item=523 Definition: Deleting cell details in Planning 11x (via Web admin tools) fails with an error stating to look in the log for further details. If you are attempting to delete cell details from a 2011-05-17 http://www.adistrategies.com/index.php?loc=news&item=523 http://www.adistrategies.com/index.php?loc=news&item=522 Definition: How to generate a Quarterly rolling forecast report, in Financial Reporting Studio? For Example, if the Current Quarter is Q4, the report should show data for Q3 (Current Year), 2011-05-17 http://www.adistrategies.com/index.php?loc=news&item=522 http://www.adistrategies.com/index.php?loc=news&item=521 Definition: Deleting members inside of planning can be tedious, especially when removing shared members from descendants for a given member. Utilize this utility inside of planning to remove all 2011-05-17 http://www.adistrategies.com/index.php?loc=news&item=521 http://www.adistrategies.com/index.php?loc=news&item=459 How To: Clearing out intersections within an ASO cube using maxL. Solution: In order to clear out a slice of an ASO cube prior to re-loading data, use the following syntax in the maxL script.  2011-01-24 http://www.adistrategies.com/index.php?loc=news&item=459 http://www.adistrategies.com/index.php?loc=news&item=458 Issue: When using calc manager mode in 11.1.1.3 to build Business rules, after there is an essbase refresh done the Business Rules disappears from Planning. Even when the application is deployed in EPMA 2011-01-24 http://www.adistrategies.com/index.php?loc=news&item=458 http://www.adistrategies.com/index.php?loc=news&item=457 Issue:  The user is unable to perform extract tasks in Workspace due to the inability to download items from Internet Explorer. Solution: Refer to the below Internet Option settings, making 2011-01-24 http://www.adistrategies.com/index.php?loc=news&item=457 http://www.adistrategies.com/index.php?loc=news&item=456 Issue: Application error popping up when loading data in FDM Solution: All the amber sign "&" sign and non relevant data has to be removed from Workbench client to resolve this issue   2011-01-24 http://www.adistrategies.com/index.php?loc=news&item=456 http://www.adistrategies.com/index.php?loc=news&item=455 Definition: How to convert member formula in BSO having @ISDESC() to ASO outline formula Solution: Use MDX syntax to convert the formula. Solution: BSO member fomula: @ISDESC(Market) ASO 2011-01-24 http://www.adistrategies.com/index.php?loc=news&item=455 http://www.adistrategies.com/index.php?loc=news&item=454 Definition:  HFM reports zeros for future months in YTD view but calculated values in periodic view. Solution:  This is because periodic data is calculated by taking the YTD difference 2011-01-24 http://www.adistrategies.com/index.php?loc=news&item=454 http://www.adistrategies.com/index.php?loc=news&item=453 Definition:  A user exists in a Shared Services group, which has full access to FDM, but in FDM the same user does not in fact exist. Solution:  FDM is not compatible with Shared Services 2011-01-24 http://www.adistrategies.com/index.php?loc=news&item=453 http://www.adistrategies.com/index.php?loc=news&item=452 Definition: Rule Launching Utility – EPMA vs Classic Solution: For Classic Planning, CmdLnLauncher is the command line utility to use to batch a Business Rule. For EPMA Planning, rules 2011-01-24 http://www.adistrategies.com/index.php?loc=news&item=452 http://www.adistrategies.com/index.php?loc=news&item=451 Definition: Fact table processing for balance sheet accounts Solution: A couple of special considerations are needed for processing of balance sheet records in a fact table.: 1.    2011-01-24 http://www.adistrategies.com/index.php?loc=news&item=451 http://www.adistrategies.com/index.php?loc=news&item=450 Definition: Issues faced in Planning 11.1.2 In version 11.1.1.3 we are 100% sure that on successful deployment of the application all the changes made to the planning are reflected to the EAS console 2011-01-24 http://www.adistrategies.com/index.php?loc=news&item=450 http://www.adistrategies.com/index.php?loc=news&item=449 Definition:  Following are the steps followed while executing HBRs from CmdLnLauncher.bat file. •    Created a new admin user and named him ADIadmin. We used this user in the 2011-01-24 http://www.adistrategies.com/index.php?loc=news&item=449 http://www.adistrategies.com/index.php?loc=news&item=448 Definition: Essbase Client will not run. Solution: For Essbase client if you have issues with essmsh or esscmd you will need to add two environment variables to your local account on the server.  2011-01-24 http://www.adistrategies.com/index.php?loc=news&item=448 http://www.adistrategies.com/index.php?loc=news&item=447 How To:  Create a Batch File with ODI:  In some cases when scheduling metadata refreshes using ODI you may not want to use the internal scheduler within ODI.  The solution is to create 2011-01-24 http://www.adistrategies.com/index.php?loc=news&item=447 http://www.adistrategies.com/index.php?loc=news&item=446 Definition: Using substitution variables to ease rolling forecast business rules in Hyperion Planning. Solution: Often times when building business rules for rolling forecasts developers make the 2011-01-24 http://www.adistrategies.com/index.php?loc=news&item=446 http://www.adistrategies.com/index.php?loc=news&item=445 Essbase Optimization:   When Essbase stores blocks to disk, it can compress the data blocks using one of the following compression methods, this is based on the type of data that is being loaded 2011-01-24 http://www.adistrategies.com/index.php?loc=news&item=445 http://www.adistrategies.com/index.php?loc=news&item=444 Description: Workspace menus not rendering full view of options when using Internet Explorer  (as shown below):   Solution: From the Tools menu, select Internet Options.  Go to 2011-01-24 http://www.adistrategies.com/index.php?loc=news&item=444 http://www.adistrategies.com/index.php?loc=news&item=443 Definition: When Planning data forms include hidden segments, columns and rows are displayed if the data form is retrieved from Smart View. (8281619) (Known issue in version 11.1.1.3) Solution: 2011-01-24 http://www.adistrategies.com/index.php?loc=news&item=443 http://www.adistrategies.com/index.php?loc=news&item=442 Definition: Percentage calculations are summing instead of calculating at each level in an ASO cube. For example, operating profit % at level zero for a company dimension performs the calculation properly 2011-01-24 http://www.adistrategies.com/index.php?loc=news&item=442 http://www.adistrategies.com/index.php?loc=news&item=441 Description: Using the Datacopy functionality in Planning web to copy data from one intersection(s) to another does not copy any accounts with the HSP_NOLINK UDA in Planning 11.1.1.3. Solution: Patch 2011-01-24 http://www.adistrategies.com/index.php?loc=news&item=441 http://www.adistrategies.com/index.php?loc=news&item=440 Description: Opening multiple tabs in Workspace from the same Planning app causes errors or erratic behavior (11.1.1.3). Solution: Patch planning to 11.1.1.3.04 and create a new property “DATA_GRID_CACHE_SIZE” 2011-01-24 http://www.adistrategies.com/index.php?loc=news&item=440 http://www.adistrategies.com/index.php?loc=news&item=439 Minimize the number of dimensions:  The number of stored dimensions inside of a block storage database should not exceed seven to ten.  Adding dimensions increases the complexities of it 2011-01-24 http://www.adistrategies.com/index.php?loc=news&item=439 http://www.adistrategies.com/index.php?loc=news&item=438 How To: User is set up as Application Administrator or Power User for HPCM but cannot execute critical tasks (redeploy calculation / reporting cubes, regenerate calculation scripts. Solution: Be 2011-01-24 http://www.adistrategies.com/index.php?loc=news&item=438 http://www.adistrategies.com/index.php?loc=news&item=437 EPMA Interface Attribute Configuration The following steps outline how to add, and associate, multiple attribute dimensions for a base dimension through EPMA. There may be other variations of these 2011-01-24 http://www.adistrategies.com/index.php?loc=news&item=437 http://www.adistrategies.com/index.php?loc=news&item=436 How To:  load a CSV file whose values contain commas through ODI In some projects, CSV files need to be loaded to Essbase, Planning, database tables and/ or other files through ODI. It is likely 2011-01-24 http://www.adistrategies.com/index.php?loc=news&item=436 http://www.adistrategies.com/index.php?loc=news&item=435 How To: On saving a Planning web form, you are repeatedly getting the message “There was an error during the save process”. You are able to view the web form but not able to save any input 2011-01-24 http://www.adistrategies.com/index.php?loc=news&item=435 http://www.adistrategies.com/index.php?loc=news&item=434 Definition: How to Create Waterfall Chart in Web Analysis Solution: •    There is no option to select waterfall graph in Web Analysis. •    Accounts dimension 2011-01-24 http://www.adistrategies.com/index.php?loc=news&item=434 http://www.adistrategies.com/index.php?loc=news&item=433 Definition: Shared services will be started without any error  but you will not be able to open the User management Console. You will be able to login to the Workspace but no application list would 2011-01-24 http://www.adistrategies.com/index.php?loc=news&item=433 http://www.adistrategies.com/index.php?loc=news&item=432 How To: In a Planning application, a user has to generally enter allocation percentages. There is no direct way of validating if the sum of percentages entered is 100% or not. We can, however, provide 2011-01-24 http://www.adistrategies.com/index.php?loc=news&item=432 http://www.adistrategies.com/index.php?loc=news&item=431 How To: Load metadata for Classic Planning application, using "Outline Load" utility. (If you are not eager to use ODI/EPMA for a simple classic application) Solution: - Outline Load utility 2011-01-24 http://www.adistrategies.com/index.php?loc=news&item=431 http://www.adistrategies.com/index.php?loc=news&item=430 How To: Maintain Essbase database to avoid performance issues, by defragmenting on a regular basis using MaxL. Solution: We can schedule the defragmentation of an Essbase database daily or as required, 2011-01-24 http://www.adistrategies.com/index.php?loc=news&item=430 http://www.adistrategies.com/index.php?loc=news&item=429 Definition: How to blackout certain groups/users from read access to no access for particular dimensions in Essbase. For example, a company may want to blackout “Current” from the scenario 2011-01-24 http://www.adistrategies.com/index.php?loc=news&item=429 http://www.adistrategies.com/index.php?loc=news&item=428 How To: Resolve following the Oracle Hyperion Planning Data Form Error: There was an error during the save process. This solution applies to Oracle EPM version 11.1.1.3 Solution: Make sure you 2011-01-24 http://www.adistrategies.com/index.php?loc=news&item=428 http://www.adistrategies.com/index.php?loc=news&item=427 The following list describes some of the common error codes that are displayed in functions: #NO CONNECTION - This displays when you are not connected or logged on to a data source. #INVALID 2011-01-24 http://www.adistrategies.com/index.php?loc=news&item=427 http://www.adistrategies.com/index.php?loc=news&item=426 HsGetValue – Cell Reference In many instances, it is not desirable to hard code the cell with the dimension members. Rather that these cells are to reference other cells in Excel, either on 2011-01-24 http://www.adistrategies.com/index.php?loc=news&item=426 http://www.adistrategies.com/index.php?loc=news&item=425 Reason: Environment variables ARBORPATH and ESSBASEPATH missing. Solution: Add the following environment user variables ARBORPATH D:\Hyperion\products\Essbase\EssbaseClient ESSBASEPATH D:\Hyperion\products\Essbase\EssbaseClient Run 2011-01-24 http://www.adistrategies.com/index.php?loc=news&item=425 http://www.adistrategies.com/index.php?loc=news&item=424 Definition: Error message: Failed : 1030010 Invalid blank character in name.   Solution: When we open a data file in EAS for editing the load rule and data file is placed in path that has 2011-01-24 http://www.adistrategies.com/index.php?loc=news&item=424 http://www.adistrategies.com/index.php?loc=news&item=423 Solution 1. Select ‘Evaluation Order’. 2. Select Plan Type from drop down. 3. Select the dimension that requires percentage values and drag to right. 4. Change the data type of the 2011-01-24 http://www.adistrategies.com/index.php?loc=news&item=423 http://www.adistrategies.com/index.php?loc=news&item=422 Solution • Sort by sparse dimensions    o Touch each block only once • Use “wide” files instead of “long” files (wide on dense dimension!!!)    2011-01-24 http://www.adistrategies.com/index.php?loc=news&item=422 http://www.adistrategies.com/index.php?loc=news&item=420 Solution: • Importance: 1) From ADS file you can able to recreate your application multiple times. 2) Normal planning application consists of 1000-1500 members which are scattered among 2011-01-21 http://www.adistrategies.com/index.php?loc=news&item=420 http://www.adistrategies.com/index.php?loc=news&item=419 Issue: “Data Access Error” while adding the maps in FDM Solution: Note: This activity shall be carried out only by the authorized administrator only When such an error occurs the 2011-01-21 http://www.adistrategies.com/index.php?loc=news&item=419 http://www.adistrategies.com/index.php?loc=news&item=418 Issue: When running consolidation at the top most Parent level of the Hierarchy with the intersection being already in unlocked state consolidation gets aborted at 100%. Solution: Unlock once again 2011-01-21 http://www.adistrategies.com/index.php?loc=news&item=418 http://www.adistrategies.com/index.php?loc=news&item=417 Definition: How to Delete Members from Planning Using ODI Delete Operations. Goal: To delete members from Planning Metadata using ODI Interface. This will be helpful in a typical case where a huge 2011-01-21 http://www.adistrategies.com/index.php?loc=news&item=417 http://www.adistrategies.com/index.php?loc=news&item=416 Goal: To convert an EPMA Planning application to a classic planning application so that ODI can be used to load metadata and data from some external source. A typical scenario can be when some exchange 2011-01-21 http://www.adistrategies.com/index.php?loc=news&item=416 http://www.adistrategies.com/index.php?loc=news&item=415 How To: Migrate specific ODI components (e.g., interface) from one environment to another In a project that includes ODI work on multiple servers, there may be a need to migrate specific ODI components 2011-01-21 http://www.adistrategies.com/index.php?loc=news&item=415 http://www.adistrategies.com/index.php?loc=news&item=414 How To: Migrate the whole ODI work from one environment to another In a typical project where ODI work is included, physical schemas, models and interfaces are first created in ODI that resides on 2011-01-21 http://www.adistrategies.com/index.php?loc=news&item=414 http://www.adistrategies.com/index.php?loc=news&item=413 Definition: SQL Query against Hyperion Planning Repository for Cell Text Solution: This is a sql query that works for system 9.x and 11.x to get cell text for each intersection by directly going 2011-01-21 http://www.adistrategies.com/index.php?loc=news&item=413 http://www.adistrategies.com/index.php?loc=news&item=412 Definition: SQL Query against Hyperion Planning Repository for Supporting Detail Solution: This is a sql query that works for system 9.x and 11.x to get supporting detail for each intersection 2011-01-21 http://www.adistrategies.com/index.php?loc=news&item=412 http://www.adistrategies.com/index.php?loc=news&item=411 Definition: Using Transaction Logging and Replay for Backup and Recovery Solution: 1. Updated Essbase.cfg file to enable transaction logging. • From EAS, right click on the Essbase server 2011-01-21 http://www.adistrategies.com/index.php?loc=news&item=411 http://www.adistrategies.com/index.php?loc=news&item=410 Definition: Migrating Dimensions for EPMA application – what you’ll need to do after importing the dimensions into the target environment Solution: If you are migrating dimensions for 2011-01-21 http://www.adistrategies.com/index.php?loc=news&item=410 http://www.adistrategies.com/index.php?loc=news&item=409 How To: Resolve following the Oracle Hyperion Essbase Excel Add-in Error: Spreadsheet Extractor internal error: Invalid input spreadsheet table. This solution applies to Oracle EPM version 11.1.1.3 Solution: 2011-01-21 http://www.adistrategies.com/index.php?loc=news&item=409 http://www.adistrategies.com/index.php?loc=news&item=408 How To: Resolve following the Oracle EPM System Workspace Error: Required application module reporting.HRRunDlg is not configured. Please contact your administrator. This solution applies to Oracle 2011-01-21 http://www.adistrategies.com/index.php?loc=news&item=408 http://www.adistrategies.com/index.php?loc=news&item=361 How To: Fix the Workspace error “Required application module reporting.bookViewer is not configured.  Please contact your administrator.” This error may occur when trying to run a book 2010-07-09 http://www.adistrategies.com/index.php?loc=news&item=361 http://www.adistrategies.com/index.php?loc=news&item=360 How To: Fix ActiveX errors received upon starting Financial Reporting Studio on a Windows Platform. Solution: To launch the client go to Start Menu-All Programs-Oracle EPM System – Reporting 2010-07-09 http://www.adistrategies.com/index.php?loc=news&item=360 http://www.adistrategies.com/index.php?loc=news&item=359 How To: Fix a “Error retrieving children for Root.” error in Essbase Studio.   Solution: When logging in to Essbase Studio you receive “Error retrieving children for Root.” 2010-07-09 http://www.adistrategies.com/index.php?loc=news&item=359 http://www.adistrategies.com/index.php?loc=news&item=358 Definition: How to make your Smart List work in EPM 11?   Background:  Suppose that you create a Smart List called SL1 in your Planning in EPM11. You assign SL1 to one of your accounts called 2010-07-09 http://www.adistrategies.com/index.php?loc=news&item=358 http://www.adistrategies.com/index.php?loc=news&item=357 Background:  There is a data form that allows users to review revenue by each department in each business unit.  The company has more than 800 departments.  Only a small number of particular 2010-07-09 http://www.adistrategies.com/index.php?loc=news&item=357 http://www.adistrategies.com/index.php?loc=news&item=354 How To: Analyze the time taken by a calculation script executed every week / month. Solution:  1.    Right Click on the application and View -> Log Charts   2.    2010-07-05 http://www.adistrategies.com/index.php?loc=news&item=354 http://www.adistrategies.com/index.php?loc=news&item=353 How To: Avoid computation error in “Dynamic  Calc and Store” members   Solution: Members of type Dynamic Calc and Store are computed only  once when they are retrieved 2010-07-05 http://www.adistrategies.com/index.php?loc=news&item=353 http://www.adistrategies.com/index.php?loc=news&item=351 Definition: Smartview will not download from workspace   Solution: The reason that it is failing is that the IE browser has not been enabled for downloading from the zone the page is in. To 2010-07-02 http://www.adistrategies.com/index.php?loc=news&item=351 http://www.adistrategies.com/index.php?loc=news&item=350 How To: Change the timeout setting of Hyperion EAS session. Solution:You can change the setting in “web.xml” file, which is mentioned below: 1440 - You can find web.xml in 2010-07-02 http://www.adistrategies.com/index.php?loc=news&item=350 http://www.adistrategies.com/index.php?loc=news&item=349 How To: Change the log level detail for EAS, in easserver.log. Solution: - There is a parameter called “'-DEAS_LOG_LEVEL” in adminsvr.lax file, which is used to set up log level. - 2010-07-02 http://www.adistrategies.com/index.php?loc=news&item=349 http://www.adistrategies.com/index.php?loc=news&item=348 How To: Set datastorage type of a parent and its children to a different type while loading metadata to EPMA through interface tables If you want a parent to have a different datastorage type than its 2010-07-02 http://www.adistrategies.com/index.php?loc=news&item=348 http://www.adistrategies.com/index.php?loc=news&item=347 How To: Execute an existing interface table-based EPMA Import profile using EPMA Batch Client When running Performance Management Architect Batch Client in script mode, there is a need to create a 2010-07-02 http://www.adistrategies.com/index.php?loc=news&item=347 http://www.adistrategies.com/index.php?loc=news&item=346 How To: Link Web Analysis Dashboards from Financial Reports.   Solution: 1. Click on the cell you want to link to either another FR report or Web Analysis. 2. Check “Add Related 2010-07-02 http://www.adistrategies.com/index.php?loc=news&item=346 http://www.adistrategies.com/index.php?loc=news&item=345 Definition: Setting up Attributes in EPMA Interface Tables   Solution: The following steps outline how to add, and associate, multiple attribute dimensions for a base dimension through EPMA. 2010-07-02 http://www.adistrategies.com/index.php?loc=news&item=345 http://www.adistrategies.com/index.php?loc=news&item=344 Definition: MaxL Script for creating a transparent partition with two partition areas   Solution: spool on to "D:\\Data\\ScriptLogs\\log.out"; login $2 identified by $3 on $1; iferror 2010-07-02 http://www.adistrategies.com/index.php?loc=news&item=344 http://www.adistrategies.com/index.php?loc=news&item=343 Definition: Calculation script example for currency conversion Solution: SET CLEARUPDATESTATUS OFF; SET UPDATECALC OFF; SET CALCPARALLEL 3; SET AGGMISSG ON; SET CACHE HIGH; FIX ("Actual", 2010-07-02 http://www.adistrategies.com/index.php?loc=news&item=343 http://www.adistrategies.com/index.php?loc=news&item=342 Definition: Invalid Member Syntax error during cube deployment under Essbase Studio 11.1.2.0.00. Solution: If you ever get “invalid member syntax” error during cube deployment process 2010-07-02 http://www.adistrategies.com/index.php?loc=news&item=342 http://www.adistrategies.com/index.php?loc=news&item=341 Definition: Problem accessing drill through reports under Essbase Studio 11.1.2.0.00 even though cubes are deployed successfully. Solution: Although cubes may deploy without any problems and you 2010-07-02 http://www.adistrategies.com/index.php?loc=news&item=341 http://www.adistrategies.com/index.php?loc=news&item=340 How To: After installing Hyperion Planning 11.1.1.3 that’s deployed using Weblogic, the default JVMOptions for setting the heap sizes for the Planning web server do not appear in the registry 2010-07-02 http://www.adistrategies.com/index.php?loc=news&item=340 http://www.adistrategies.com/index.php?loc=news&item=339 How To: Deleting supporting details in Planning 9.3.1. Hyperion provides a basic sql script (sddelete.sql) for deleting supporting line detail. This sql script can be found in the “Planning\config\sql” 2010-07-02 http://www.adistrategies.com/index.php?loc=news&item=339 http://www.adistrategies.com/index.php?loc=news&item=338 Definition: UTF-8 Error on Hyperion Financial Reports. Allow Expansion feature does not work on Hyperion Financial Reports version 9.3 for a specific member, but it works for all other members. Solution: 2010-07-02 http://www.adistrategies.com/index.php?loc=news&item=338 http://www.adistrategies.com/index.php?loc=news&item=337 Definition: User cannot view the report in pdf format. Hyperion Financial Reporting Studio, Version 11.1.12 Solution: User gets the below error message when try to run a report in pdf format. If 2010-07-02 http://www.adistrategies.com/index.php?loc=news&item=337 http://www.adistrategies.com/index.php?loc=news&item=336 Definition: In Financial Data Quality Management (FDM), the Validation phase in the Workflow should validate to make sure all imported data can be exported to the target application. Any mapping kickouts 2010-07-02 http://www.adistrategies.com/index.php?loc=news&item=336 http://www.adistrategies.com/index.php?loc=news&item=335 Definition: In version 9 and below of HFM, the user can reorder the members in a dimension by manually moving them in Metadata Manager or by loading a modified flat file as a replace. However, the Currency 2010-07-02 http://www.adistrategies.com/index.php?loc=news&item=335 http://www.adistrategies.com/index.php?loc=news&item=334 Definition: Attached is a little utility and script that does string replacement of tab delimited text files. The example included is to replace all " in the fieds with single quote but leave the 2010-07-02 http://www.adistrategies.com/index.php?loc=news&item=334 http://www.adistrategies.com/index.php?loc=news&item=333 Problem: When migrating data forms inside of planning from System 9.3.1 to Version 11.1.1.3 some of the forms may contain Java Script errors after the migration. Solution: Recreate each one of the 2010-07-02 http://www.adistrategies.com/index.php?loc=news&item=333 http://www.adistrategies.com/index.php?loc=news&item=332 Problem: During a retrieve Excel Hangs or the retrieve returns no data. The Essbase Add-In only supports 1 instance of Excel open at any given time. If you are trying to retrieve data and nothing is 2010-07-02 http://www.adistrategies.com/index.php?loc=news&item=332 http://www.adistrategies.com/index.php?loc=news&item=331 Definition: When we load date to essbase, it stores date as Excel Serial Date Value. If we need to retrieve it in places other than Excel (such as Financial Reporting), we need a formula to convert from 2010-07-02 http://www.adistrategies.com/index.php?loc=news&item=331 http://www.adistrategies.com/index.php?loc=news&item=330 When setting up a gen/lev dim build file to be used with essbase studio. For any missing level/gen, a single space should be used in place of blanks. Otl preview will show empty (single space) parent 2010-07-02 http://www.adistrategies.com/index.php?loc=news&item=330 http://www.adistrategies.com/index.php?loc=news&item=311 How To: Migrating FDQM from versions prior to 11.1.1.3 to version 11.1.1.3.  In version 11.1.1.3, default target members can no longer be specified in the target adapter configuration. Solution: 2010-04-05 http://www.adistrategies.com/index.php?loc=news&item=311 http://www.adistrategies.com/index.php?loc=news&item=310 How To: Input source member names with “&” and other unrecognized characters in the FDQM maploader template.  The “&” is frequently used in member names, but cannot 2010-04-05 http://www.adistrategies.com/index.php?loc=news&item=310 http://www.adistrategies.com/index.php?loc=news&item=306 How To: Email from a calculation script.  Occasionally your users want to be notified after a calculation script has been executed.  This solution is for Windows based 32 or 64 bit based servers.  2010-03-31 http://www.adistrategies.com/index.php?loc=news&item=306 http://www.adistrategies.com/index.php?loc=news&item=305 How To: Modify currently configured User Directories in Shared Services.  Once a user directory is added to Shared Services changes made to the directory are not recognized. Solution:   2010-03-31 http://www.adistrategies.com/index.php?loc=news&item=305 http://www.adistrategies.com/index.php?loc=news&item=304 How To: Backup and recover the OpenLDAP database in Oracle EPM System, Fusion Edition (11.1.1.3). Solution:  EPM Shared Services utilizes an OpenLDAP database to store data along with the Relational 2010-03-31 http://www.adistrategies.com/index.php?loc=news&item=304 http://www.adistrategies.com/index.php?loc=news&item=301 How To: Optimizing HPCM Dense / Sparse settings. Solution: The default configuration for an HPCM model is for the Measures and AllocationType dimensions to be dense, while all others are sparse.  2010-03-29 http://www.adistrategies.com/index.php?loc=news&item=301 http://www.adistrategies.com/index.php?loc=news&item=300 How To: General Essbase BSO cube calc performance tuning. Solution:  Gather two baseline calc time: 1.    Time requires to cycle through all level 0 blocks. 2.    2010-03-29 http://www.adistrategies.com/index.php?loc=news&item=300 http://www.adistrategies.com/index.php?loc=news&item=299 How To: Would like to utilize the aggregation speed of ASO but want to retain BSO features such as BSO outline member formulas and DTS. Solution: Set up a partition that uses ASO as source and matching 2010-03-29 http://www.adistrategies.com/index.php?loc=news&item=299 http://www.adistrategies.com/index.php?loc=news&item=298 How To: Solve the error message: No dimension exists for the associated dimension property 'X' for Dimension 'Y' during the metadata import to EPMA when using interface tables and creating 2010-03-29 http://www.adistrategies.com/index.php?loc=news&item=298 http://www.adistrategies.com/index.php?loc=news&item=297 How To:  Deal with the problem of Grid POVs turning to User POVs in Hyperion Financial Reporting In a typical scenario where the above error occurs, a report designer places a dimension on which 2010-03-29 http://www.adistrategies.com/index.php?loc=news&item=297 http://www.adistrategies.com/index.php?loc=news&item=296 How To: This Knowledge base item is intended to document the issue you might face related to HBR and RTP on Hyperion 9.3.1 Scenario: For one of the customer, while configuring a Planning application 2010-03-29 http://www.adistrategies.com/index.php?loc=news&item=296 http://www.adistrategies.com/index.php?loc=news&item=295 How To: This knowledge base item is intended to document the issue you might face while installing 32 bit Hyperion components on a 64 bit platform. Scenario: While installing Essbase (64 bit) and 2010-03-29 http://www.adistrategies.com/index.php?loc=news&item=295 http://www.adistrategies.com/index.php?loc=news&item=294 Issue:  In System 9.3.1 Hyperion Planning, we have an option called “Run On Load” on Business rules attached to web forms. While using “FormDefUtil.cmd” utility to export 2010-03-26 http://www.adistrategies.com/index.php?loc=news&item=294 http://www.adistrategies.com/index.php?loc=news&item=293 Issue: Web-based EAS console will not load, issuing unsigned java exceptions after upgrading Planning 9.3.1 .1 to 9.3.1.11. Part of the install involves updating the easclientplugin.jar and easserverplugin.jar 2010-03-26 http://www.adistrategies.com/index.php?loc=news&item=293 http://www.adistrategies.com/index.php?loc=news&item=292 Issue: Using the LCM in Hyperion 11.1.1.3 to migrate planning applications fails to migrate certain webforms. This appears to be a bug when exporting a planning app via LCM to the file system and then 2010-03-26 http://www.adistrategies.com/index.php?loc=news&item=292 http://www.adistrategies.com/index.php?loc=news&item=291 How To: Error 5200 on Workspace while trying to run Hyperion Financial Reports.  This solution applies to versions 9.2, 9.3, and 11.1.1.3.  Below screen-shots were taken from a 9.2 Environment. Solution:  2010-03-26 http://www.adistrategies.com/index.php?loc=news&item=291 http://www.adistrategies.com/index.php?loc=news&item=290 How To: Configuring SMTP Server on Hyperion Shared Services to automatically run Hyperion Financial Reports (FR) on Hyperion Workspace (Workspace).  This solution applies to Oracle EPM version 11.1.1.3 Solution:  2010-03-26 http://www.adistrategies.com/index.php?loc=news&item=290 http://www.adistrategies.com/index.php?loc=news&item=288 Issue: When a user cannot navigate to a new application in Workspace because of interface deformation, it is an Internet Explorer issue. Solution: In order to fix this problem, go to Internet Options 2010-03-21 http://www.adistrategies.com/index.php?loc=news&item=288 http://www.adistrategies.com/index.php?loc=news&item=287 How To: In HFM, and are both unique out-of-the box Value Dimension members.  This is because at any given intersection, they do not roll up to a top member.  Instead, the members roll up 2010-03-21 http://www.adistrategies.com/index.php?loc=news&item=287 http://www.adistrategies.com/index.php?loc=news&item=284 Issue 1:  When modifying a package a Scenario executes as if it were the old package.   Issue 2:  When modifying the scheduling of a Scenario the Scenario will still execute as if 2010-03-18 http://www.adistrategies.com/index.php?loc=news&item=284 http://www.adistrategies.com/index.php?loc=news&item=272 Issue: When running a financial report on the web, the user might get a communication error followed with another error 'Required Application Module Reporting.HRRunDlg is not configured.' Solution: 2010-03-11 http://www.adistrategies.com/index.php?loc=news&item=272 http://www.adistrategies.com/index.php?loc=news&item=271 Issue: Adding a new user or group to Shared Services causes security to stop working. Solution: Be sure that the new user or group does not have the same name as another user or group.  It 2010-03-11 http://www.adistrategies.com/index.php?loc=news&item=271 http://www.adistrategies.com/index.php?loc=news&item=247 Issue: While deploying a Planning application through EPMA 9.3.0.1, the deployment might get stuck because of some interruption. Henceforth, the status of the application shows “Deployment Pending”. 2010-02-04 http://www.adistrategies.com/index.php?loc=news&item=247 http://www.adistrategies.com/index.php?loc=news&item=245 Domain controller being down will cause Business Rules to stop working and return a Null Pointer Exception for any attempt to open or validate a rule using EAS or the command line launcher. 2010-01-28 http://www.adistrategies.com/index.php?loc=news&item=245 http://www.adistrategies.com/index.php?loc=news&item=242 Some users have been experiencing issues running business rules in Smartview.  This is an IE7 issue and can be resolved by creating the following registry entries  on the users machine in the 2010-01-26 http://www.adistrategies.com/index.php?loc=news&item=242 http://www.adistrategies.com/index.php?loc=news&item=199 Oracle EPM All Versions Library 2010-01-18 http://www.adistrategies.com/index.php?loc=news&item=199 http://www.adistrategies.com/index.php?loc=news&item=198 2010-01-18 http://www.adistrategies.com/index.php?loc=news&item=198 http://www.adistrategies.com/index.php?loc=news&item=197 2010-01-18 http://www.adistrategies.com/index.php?loc=news&item=197 http://www.adistrategies.com/index.php?loc=news&item=196 2010-01-18 http://www.adistrategies.com/index.php?loc=news&item=196 http://www.adistrategies.com/index.php?loc=news&item=195 2010-01-18 http://www.adistrategies.com/index.php?loc=news&item=195 http://www.adistrategies.com/index.php?loc=news&item=194 2010-01-18 http://www.adistrategies.com/index.php?loc=news&item=194 http://www.adistrategies.com/index.php?loc=news&item=193 2010-01-18 http://www.adistrategies.com/index.php?loc=news&item=193 http://www.adistrategies.com/index.php?loc=news&item=192 2010-01-18 http://www.adistrategies.com/index.php?loc=news&item=192 http://www.adistrategies.com/index.php?loc=news&item=191 2010-01-18 http://www.adistrategies.com/index.php?loc=news&item=191 http://www.adistrategies.com/index.php?loc=news&item=190 2010-01-18 http://www.adistrategies.com/index.php?loc=news&item=190 http://www.adistrategies.com/index.php?loc=news&item=189 2010-01-18 http://www.adistrategies.com/index.php?loc=news&item=189 http://www.adistrategies.com/index.php?loc=news&item=188 A. Start Services Hyperion System 9 Foundation: Licensing Service Shared Services OpenLDAP Shared Services Tomcat5 Hyperion Analytic Services: Analytic Services Analytic Provider 2010-01-18 http://www.adistrategies.com/index.php?loc=news&item=188 http://www.adistrategies.com/index.php?loc=news&item=185 All documentation for Essbase 2010-01-18 http://www.adistrategies.com/index.php?loc=news&item=185 http://www.adistrategies.com/index.php?loc=news&item=184 Installation & Backup 2010-01-18 http://www.adistrategies.com/index.php?loc=news&item=184 http://www.adistrategies.com/index.php?loc=news&item=141 2009-12-28 http://www.adistrategies.com/index.php?loc=news&item=141 http://www.adistrategies.com/index.php?loc=news&item=140 2009-12-28 http://www.adistrategies.com/index.php?loc=news&item=140 http://www.adistrategies.com/index.php?loc=news&item=139 Oracle Enterprise Performance Management System, Fusion Edition 2009-12-26 http://www.adistrategies.com/index.php?loc=news&item=139 http://www.adistrategies.com/index.php?loc=news&item=112 1. Create a new relational database for your planning application on target DB server 2. Create a data source to the database 3. Create a fresh planning application on the new version of Planning 2009-12-24 http://www.adistrategies.com/index.php?loc=news&item=112 http://www.adistrategies.com/index.php?loc=news&item=111 When Installing Oracle Data Integrator for use with a MS SQL 2005 RDBMS, you will need to download the proper JDBC drivers for use with MS SQL 2005 as the ODI install only comes with drivers for MS SQL 2009-12-24 http://www.adistrategies.com/index.php?loc=news&item=111