[Mondrian] Re: NativizeSetFunDefTest and mondrian.olap.SsasCompatibleNaming

[Pedro Alves]

This reminds me a doubt I have from this option.


When I use [Foo].[Bar].[Zoo], how do I know if it's 
[Dimension].[Hierarchy] or [Dimension].[Member] (or even 
[Dimension].[Level]..) ?



-pedro


On 09/12/17 14:39, Matt Campbell wrote:
> (resending to include the mailing list...)
>
>     Hi Julian,
>
>     The failures are caused by Dimension.Level.Members queries being
>     interpreted as Dimension.Hierarchy.Members.  For example,
>
>     select  [Gender].[Gender].members on 0 from sales
>
>     returns
>
>     Axis #0:
>     {}
>     Axis #1:
>     {[Gender].[All Gender]}
>     {[Gender].[All Gender].[F]}
>     {[Gender].[All Gender].[M]}
>     Row #0: 266,773
>     Row #0: 131,558
>     Row #0: 135,215
>
>
>     This is different than SSAS 2005/2008, which excludes the [All
>     Gender].  That is, Gender.Gender is not interpreted as the hierarchy.
>
>     F M
>     $10,932.00 $10,696.00
>
>
>     We can change the tests to match the currently expected syntax for
>     referring to a level, but I wonder if the real fix here is to modify
>     Mondrian to be consistent with SSAS behavior.
>
>     -matt
>
>
>     On Wed, Dec 16, 2009 at 4:29 AM, Julian Hyde <jhyde at pentaho.com
>     <mailto:jhyde at pentaho.com>> wrote:
>
>         Matt,
>         If I run the test suite with
>         mondrian.olap.SsasCompatibleNaming=true, I get lots of errors
>         from NativizeSetFunDefTest. This is one of those options for
>         which the test suite needs to pass regardless of the setting.
>         It's important that the test suite works with this option set to
>         true, because this will be the default behavior of mondrian in 4.0.
>         (You weren't to know that this parameter was important. We're
>         setting up a hudson instance that tests all of these obscure
>         parameters, and runs on multiple databases and jdks regularly.)
>         Can you please fix NativizeSetFunDefTest for this option?
>         There are also errors in NonEmptyTest, SchemaTest and
>         XmlaBasicTest. I have not figured out who owns there.
>         Julian
>
>
>
>
>
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian