[Mondrian] ADOMD.Net/SSRS incompatible changes

[Tiago Ferreira]

We've been working on mondrian ADOMD.Net and SSRS compatibility, and some
changes modify current mondrian behavior in ways that could break current
usages (new functions etc not included here).
Some functionalities depend on enabling certain properties, but even just
those that don't will change every xmla response.
We're currently working on bringing these to the master branch and would
like to get developer and community input on how to best approach this part.

Of particular concern is which functionalities should be enabled by
properties, which properties should be grouped together, and what can be
just accepted as new behavior.

Here is an overview of potentially breaking changes:

MONDRIAN-1836/MONDRIAN-1990
- New rowset columns
Most of the new xmla rowset columns were just added to prevent outright
failure when reading the response or exceptions when trying to access them
via the adomd api. Most of them have default values that aren't useful
beyond keeping things from breaking in these scenarios. Only
MDSCHEMA_MEMBERS's EXPRESSION and MEMBER_KEY expose new info.
MDSCHEMA_MEMBERS
EXPRESSION
MEMBER_KEY
MDSCHEMA_HIERARCHIES
HIERARCHY_ORIGIN
HIERARCHY_DISPLAY_FOLDER
MDSCHEMA_CUBES
CUBE_SOURCE
LAST_DATA_UPDATE
MDSCHEMA_MEASURES
NUMERIC_PRECISION
NUMERIC_SCALE
MEASURE_UNITS
EXPRESSION
MEASURE_DISPLAY_FOLDER
MDSCHEMA_MEASUREGROUPS (new rowset)
CATALOG_NAME
SCHEMA_NAME
CUBE_NAME
MEASUREGROUP_NAME
DESCRIPTION
IS_WRITE_ENABLED
MEASUREGROUP_CAPTION
- Restrictions DIMENSION_VISIBILITY, HIERARCHY_VISIBILITY,
LEVEL_VISIBILITY, MEASURES_VISIBILITY
- Intrinsic member properties ID and NAME were added as aliases to KEY and
MEMBER_NAME respectively.
- xmlns prefixes (xmla and cxmla) were removed for adomd.
- mondrian.xmla.CustomProviderVersion=10.0.1600.22
This is an odd one but in at least one case adomd will throw a
NotSupportedException when accessing a field if adomd doesn't recognize the
provider version (even though the provider itself can still be mondrian).
This property was added to optionally spoof the xmla provider version.
- XMLA Tabular Cell changes
- Added FORMATTED_VALUE and FORMAT_STRING elements,
- VALUE element name now ends in .VALUE

MONDRIAN-1991
- Members by key. This is probably the only one prone to break things that
don't use xmla.
Added the property mondrian.olap.SsasKeyLookup=true to allow keys to be
used in the same situations as names (after a member or hierarchy).
This only affects the current mondrian3 key access (level + full key) when
doing key lookups from the hierarchy: instead of looking at the lowest
level it will now look up the topmost.

MONDRIAN-1993
- Xmla exceptions
The mondrian.xmla.UseMSSASError=true property changes mondrian xmla
exception format into something ADOMD can parse as an exception.
Any previous xmla exception parsing should break with this version.
It's mostly different structure, apart from the error code which has to be
an unsigned integer instead of string. In the current implementation this
number should be coherent but otherwise useless (it's just a part of the
string hash).

MONDRIAN-1996
- Full hierarchy names
mondrian.xmla.FullHierarchyNames=true property makes all unique names of
members, levels and hierarchies in xmla include the hierarchy name even
when it is the same as the dimension's.
-- 
Tiago Gomes Ferreira
Webdetails Dev

www.webdetails.pt
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20140409/4aff4c6d/attachment.html