Knowledge Base

ADI Strategies › Resources › Knowledge Base
  • [ID:0070] Create new “.ads” file and make changes to it in case of planning app gets corrupted

    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 the different dimensions of the same application.

    Hence to create those members manually along with the properties is bit tedious task.
    With help of ADS file we can able to do the task in much easier way.

    Different Sections

    Explore More

  • [ID:0093] Workspace menus not rendering full view of options when using Internet Explorer

    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 the Security tab:
    1.    Click on the Trusted Sites icon
    2.    Click the Sites button
    3.    The url for the current location should be displayed, if so, click Add.  If not, type in the appropriate url and click

    Explore More

  • [ID:0094] Compression Types in Hyperion Essbase

    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 into the Essbase database.
    •    No Compression:  It is what it says, no compression is occurring on the database. 
    •    zLib Compression:  This is a good choice

    Explore More

  • [ID:0095] Using substitution variables to ease rolling forecast business rules in Hyperion Planning

    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 common mistake of copying and pasting the same calculation logic in two different if statements in order to ensure they have captured the correct section of the rolling forecast.  The same principle applies when the

    Explore More

  • [ID:0096] Create a Batch File with ODI

    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 a batch file, and use the task scheduler of your choice.  This will also allow you to execute the ODI Scenario (ON DEMAND) without having to go into

    Explore More

  • [ID:0097] Essbase Client will not run

    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.  When we install the Essbase client it only creates these variables for the user doing the install.  When you logon to the server your account doesn’t have the

    Explore More

  • [ID:0098] Step to execute HBRs from CmdLnLauncher.bat

    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 batch script for loading data and executing the BR.
    •    We used the complete URL for the database as it appears in the EAS console for a business Rule in the xml

    Explore More

  • [ID:0099] Application Deployment Issue in version 11.1.2

    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 i.e. the respective database of the application.
    But in version 11.1.2 on successful deployment we will have to check the Message link provided on the Deployment Job Console

    Explore More

  • [ID:0100] Fact table processing for balance sheet accounts

    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.    Handling of opening balance: If opening balance is stored in BegBalance member, then drilling-through to a particular period in the year will not return opening balance causing the drill-through result set



    Explore More

  • [ID:0101] Rule Launching Utility – EPMA vs Classic

    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 are developed in Calc Manager. Planning comes with a separate command line utility CalcMgrCmdLineLauncher. (Note: CmdLnLauncher is packaged under EAS, not Planning.) This utility allows running Calc Manager rule or ruleset in a

    Explore More

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