Home > Hyperion Enterprise > Logic Analysis Utility |
Converts logic files to columnar format allowing formulas to be analysed with Excel AutoFilter. For more information see the Help section below.
1. | Logic to analyse: Extract logic from Enterprise and paste into this box. |
2. | |
3. | Analysed logic: Click inside this box, press Ctrl+A to select all and Ctrl+C to copy. |
4. | Paste into Excel. |
This script was developed to help manage a logic file that contained over 25,000 formulas. It takes a logic file like this:
[METHOD=CHART,Default Chart Logic ,MAXIMUM,A,] [CATEGORY= ALL] #GROSS_PROFIT=tot #OPERATING_PROFIT=tot [METHOD=CONSOL,Default Consolidation Logic ,MAXIMUM,C,] [METHOD=TRANS,Default Translation Logic ,MAXIMUM,T,] [CATEGORY= ALL] #revenue=round(pva(@ACC,#fx_average),1) #cost_of_sales=round(pva(@ACC,#fx_average),1) [METHOD=CHARTDSM,Default DSM Chart Logic ,MAXIMUM,A,] [CATEGORY= ALL] #GROSS_PROFIT=tot #OPERATING_PROFIT=tot [METHOD=DYNVIEWACCTS,Dynamic View Accts ,MAXIMUM,A,] [CATEGORY= ALL] #gross_profit_precent=#GROSS_PROFIT/#revenue*100
and converts it to a tab delimited table that will look like this in Excel.
Target Method Category Formula #GROSS_PROFIT CHART ALL #GROSS_PROFIT=tot #OPERATING_PROFIT CHART ALL #OPERATING_PROFIT=tot #revenue TRANS ALL #revenue=round(pva(@ACC,#fx_average),1) #cost_of_sales TRANS ALL #cost_of_sales=round(pva(@ACC,#fx_average),1) #GROSS_PROFIT CHARTDSM ALL #GROSS_PROFIT=tot #OPERATING_PROFIT CHARTDSM ALL #OPERATING_PROFIT=tot #gross_profit_precent DYNVIEWACCTS ALL #gross_profit_precent=#GROSS_PROFIT/#revenue*100
You can then filter the table using AutoFilter and for example identify all the formulas that affect a particular account.
Copyright © 1999-2008 Consolidation Consultancy Limited | Last updated: 09 Sep 2010 |