Following are the bug fixes and enhancements released in version 5.0: Bug Fixes Saving the results of an MDX query to a file resulting in the string “null” in empty cells. This has been corrected. Some unicode characters were incorrectly represented…
Tag: cubeSavvy Utilities
cubeSavvy Utilities 4.1
Just a short post to announce some minor bug fixes and enhancements for cubeSavvy Utilities. Version 4.1: Bug Fixes Selecting files through the “Browse…” buttons often required changing the file type to see the correct extension – xml or txt.…
cubeSavvy Utilities 4.0 released
One of the most-requested enhancements in this release is the ability to parse an ASO export file without having access to the outline. This can now be done by selecting a file containing the outline in xml format, using the “MaxL…
cubeSavvy Utilities 3.0 – XML Outline Editing
I was extremely excited to see XML Outline Editing show up in the 11.1.2.4 Essbase New Features. You see, I despise load rules. They are as close to evil as a software feature can get. Their hundreds of conflicting settings hidden away, just…
cubeSavvy Utilities 2.0 – File Filters added
A common task I encounter is needing to filter a flat file using a list of Essbase members. For example, I have a data file that contains all months for all CostCenters. However, I currently only need to work with a…
cubeSavvy Utilities – updated MDX capabilities
As promised when I introduced cubeSavvy Utilities, expanding the MDX Query functionality to handle PROPERTIES and PROPERTY_EXPR was my next task. I’m happy to say that version 1.1, now available for download, incorporates this feature. This version can also…
Introducing cubeSavvy Utilities
cubeSavvy Utilities I’ve wanted to combine my various Essbase-related tools into a single, integrated tool for a while. That tool is now called cubeSavvy Utilities. It encompasses my MDX Query Tool – XMLA Edition, ASO Export Parser, and MaxL Outline XML Parser. I’ve…
ASO Export Parser – now with Filters!
I’ve updated the ASO Export Parser to allow for filtering the output to only include those members specified on the “Member Filter” tab. You can see the allowable “Selection Type” commands in the screenshot below. Keep in mind that only level-0…
Parse ASO export to columns
I developed MDX Query Tool in order to facilitate extracting small amounts of data from ASO databases using MDX queries. Sometimes, however, the volume of data you are working with exceeds the MDX query limit. You may be able to…