Hyperion Kernel, From Alpha To Omega

Hyperion developers love FIX and IF, both are powerful tools and interchangeable in usage in certain circumncetances. There are also differences between the two. Let's take a look. FIX...ENFIX Usages and Rules Every FIX must be ended with ENDFIX. But it is optional to end the statement by ";" FIX Mbr can be any comma-delimited list of members, or member set functions FIX Mbr argument can be a combination of members from multiple dimensions           FIX(@CHILDREN(Qtr1),"Actual")                 Calc Dim(Accounts);           ENDFIX FIX Mbr list from the same dimension means "OR", cross dimensions means "AND" FIX cannot be used inside of formulas in outline, they can ONLY be used in calc scripts Cannot consolidate a dimension that is FIXed on. Following will generate an error when run          FIX(@CHILDREN(Qtr1),"Actual")                 Calc Dim(Accounts, Scenario);         ENDFIX It c

Everyone used FDM to update mapping probably will fee frustration when updating mappings, especially when many rows of records need to be added. More often than not, instead of giving you successful grid update confirmation, it throws you an error message, and all your hard working of mappings are lost in a second. After ran into those kind of errors for several times, people started to hit the Update Grid button every time making two or three entries. See error below. It is extremely painful when you have MANY mapping entries to make. Here is an easier way to do mass update of meta data mappings. - First you would need to export the mapping into an excel file. - Open the exported excel file, and insert rows, and ensure all newly added rows fall within the range of upstDataMap.                    - Delete all data in the DataKey, as those will be regenerated when the export file is imported back. - Save the file