Knowledge Base

ADI Strategies › Resources › Knowledge Base
  • [ID:0145] How to create a folder with a timestamp for Archiving purpose in an ODI Package

    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) , please follow the steps mentioned below:
    – Create a variable, say “SystemDate”, with datatype as ‘Alphanumeric’ and Action as ‘Latest
    Value’.
    – On “Refreshing” tab, you have to select a SQL /Oracle



    Explore More

  • [ID:0021] ASO Usage Example

    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 BSO cube as target. 
    Mapping area should include ALL BSO stored members.
    For best retrieval performance from  BSO, only set Time as dense. This

    Explore More

  • [ID:0020] Dimension import issue in EPMA

    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 new dimensions in EPMA

    An example scenario is the following:
    Product dimension is going to be imported to EPMA by creating a new dimension in EPMA.  Parent-child relationships for the members

    Explore More

  • [ID:0019] Grid POVs issue in financial reports

    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 a security is imposed into Grid POV and selects a specific member for it. The report designer then hides the Grid POV bar to prohibit the corresponding

    Explore More

  • [ID:0018] Run time prompt issues on business rules

    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 on Hyperion Planning 9.3.1, following steps were followed.
    i.    A planning web form is created with one HBR attached to it.
    ii.    Two RTPs are associated with

    Explore More

  • [ID:0022] BSO Calculation Tuning

    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.    Time requires to run a ‘calc all’ after performing level 0 export/import. This will provide calc time for cycle through all upper level blocks.
    Once baselines have been established, calc script performance can always be


    Explore More

  • [ID:0023] Optimizing HPCM Dense / Sparse settings.

    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.  As a starting point to optimize the calculation performance, set only the largest “target” dimension to dense, while all others are sparse.  To initially test these, make the

    Explore More

  • [ID:0028] Migrating FDQM From Earlier Versions to 11.1.1.3

    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: Default target members that were specified in the target adapters (defaults for “No Member”) in versions prior to 11.1.1.3, must now be replaced by maps.  Otherwise, the output file will

    Explore More

  • [ID:0026] How To Email In A Calculation Script

    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.  This has been tested and developed on V11 Oracle Essbase.

    Solution: To begin we need to setup the Essbase environment with the following files that will

    Explore More

  • [ID:0025] Modify Shared Services User Directories

    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:   The server hosting Shared Services must be rebooted to user directories to take effect.  Restart of Shared Services will not suffice.  Save all changes, stop all Hyperion services on the server

    Explore More

  1. Pages:
  2. 1
  3. 2
  4. 3
  5. 4
  6. 5
  7. 6
  8. 7
  9. ...
  10. 15