[Mondrian] RE: Excel 2007 Support

[Julian Hyde]

Calum,

Looks mostly good, but it seems a bit strange that member properties all
have the same name. They're all called 'Store' in your reference log:

                                <Tuple>
                                    <Member Hierarchy="Store">
                                    <UName>[Store].[All
                                    Stores].[USA].[WA].[Bellingham].[Store
2]</UName>
                                    <Caption>Store 2</Caption>
                                    <LName>[Store].[Store Name]</LName>
                                    <LNum>4</LNum>
                                    <DisplayInfo>0</DisplayInfo>
                                    <PARENT_UNIQUE_NAME>[Store].[All
Stores].[USA].[WA].[Bellingham]</PARENT_UNIQUE_NAME>
                                    <Store>Small Grocery</Store>
                                    <Store>Smith</Store>
                                    <Store>28206</Store>
                                    <Store>22271</Store>
                                    <Store>3561</Store>
                                    <Store>2374</Store>
                                    <Store>true</Store>
                                    <Store>5203 Catanzaro Way</Store>
                                    </Member>
                                </Tuple> 

Please clarify this point and I can check in.

I agree that we should only return slicer members that are explicitly
mentioned in the WHERE clause. As you know previous behavior was to return
all members, including implicit members, ContentType=Data but not if
ContentType=DataOmitDefaultSlicer.

I've changed the default behavior to include only explicit members. This is
the behavior for ContentType=Data, SchemaData, or DataOmitDefaultSlicer. In
fact Data and DataOmitDefaultSlicer now have identical behavior. I've added
a new ContentType value, ContentType=DataIncludeDefaultSlicer, if people
want the current behavior, that is, to return all members even implicit
ones.

Julian

> -----Original Message-----
> From: Calum Miller [mailto:calum at millersoft.ltd.uk] 
> Sent: Sunday, January 17, 2010 1:15 PM
> To: jhyde at pentaho.com
> Cc: 'Mondrian developer mailing list'
> Subject: Excel 2007 Support
> 
> Hi Julian
> 
> I have added a new test to xmlaExcelTest2000.java, called 
> testExpect07  
> which checks
>   a) Member Properties are in the correct format for Excel 2007
>   b) The SlicerAxis is in the correct format for Excel 2007
> 
> The following attached files must be updated to support this test:
> 
> 
>