[Mondrian] Re: Excel 2007 Support

Calum Miller calum at millersoft.ltd.uk
Mon Jan 18 06:02:28 EST 2010


Hi Julian,

Admittedly, this does look at bit odd but it does work with all the  
properties lining up in Excel. When I find some more time I will try  
again with the associated property names, but this approach will work  
for now.

Calum

On 18 Jan 2010, at 10:21, Julian Hyde wrote:

> 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:
>>
>>
>>
>

Calum Miller
Business Intelligence Specialist
calum at millersoft.ltd.uk
http://www.millersoft.ltd.uk
Telephone: +44 (0) 131 208 0202
Mobile: +44 (0) 7973 249 621
Skype: calummiller

-------------- next part --------------
A non-text attachment was scrubbed...
Name: millersoft-mail.logo.jpg
Type: image/jpeg
Size: 8712 bytes
Desc: not available
Url : http://lists.pentaho.org/pipermail/mondrian/attachments/20100118/4f571c24/attachment.jpg 
-------------- next part --------------




More information about the Mondrian mailing list