Here is a new version of the "useful functions" for EPM. Some App Engine code coming with light-weight App Studio reports that make life easier for developers, administrators and users.
New stuff:
- OlapExportCreateTable: App Engine can now create the tables for exporting cube or dimension data. This routine will do it for you.
- OlapDeletePhysicalZero: Find physical 0 amounts in user cubes, and report on them or delete them right away. In almost all cases, they only use memory and detract from performance
- PrepareSemiAdditive (new entry in the XML templates): Olap can now handle semi-additive measures out of the box, without hypercube rules. You will have to create a few attributes. Then use this function to enable your time dimension for semi-additive measures.
Old stuff:
- Delete, export, copy or move data between cubes of any sort
- Import data from a table to a cube, via a mapping or via App Engine code
- Rename elements without losing data
- Find dimension elements which don't have any data
- Check a hierarchy for completeness
- XML functions, such as save and unload cubes, put a database into "reserved" mode, stop long-lasting tasks
- and more
The routines are documented in code. The reports are an easy way to run them, without interfering with anything else (no global variables, lists, language items etc to take care of)
