Fwd: [Mondrian] RE: Excel 2007 Support

Calum Miller calum at millersoft.ltd.uk
Mon Jan 18 19:15:45 EST 2010



Begin forwarded message:

> From: Calum Miller <calum.miller at yahoo.com>
> Date: 18 January 2010 23:02:30 GMT
> To: jhyde at pentaho.com, Mondrian developer mailing list <mondrian at pentaho.org 
> >
> Subject: Re: [Mondrian] RE: Excel 2007 Support
>
>
> On 18 Jan 2010, at 18:04, Julian Hyde wrote:
>
>>> I recall you stating that there is a property/utility which
>>> translates
>>> from
>>> <[Store].[Store Name].[Store Name Type]>Small
>>> Grocery</[Store].[Store
>>> Name].[Store Name Type]>
>>> to
>>> <
>>> _x005B_Store_x005D_
>>> ._x005B_Store_x0020_Name_x005D_._x005B_Store_x0020_Type_x005D_>Small
>>> Grocery</
>>> _x005B_Store_x005D_
>>> ._x005B_Store_x0020_Name_x005D_._x005B_Store_x0020_Type_x005D_>
>>>
>>> Could you point me in the direction of this property/utility
>>> and I'll
>>> rewrite the test?
>>
>> The utility is encodeElementName, as in the following lines from  
>> XmlaHandler
>> (to deal with output of multidimensional results in Tabular format):
>>
>>       Column(String name, int type) {
>>           this.name = name;
>>
>>           // replace invalid XML element name, like " ", with  
>> "_x0020_" in
>>           // column headers, otherwise will generate a badly- 
>> formatted xml
>>           // doc.
>>           this.encodedName = XmlaUtil.encodeElementName(name);
>>           this.xsdType = sqlToXsdType(type);
>>       }
> Unfortunately, just setting the startElement correctly is not  
> enough, the following line generated the correct level names but the  
> values are missing in Excel
> 	 
> writer 
> .startElement 
> (XmlaUtil.encodeElementName(member.getLevel().getUniqueName()+". 
> ["+properties[i].getName()+"]"));
>
> I think the getProps function returns the wrong values when  
> HierachyInfo is  generated. I will not get another chance to review  
> this function until Wednesday evening.
>
>            <HierarchyInfo name="Store">
>              <UName name="[Store].[MEMBER_UNIQUE_NAME]"/>
>              <Caption name="[Store].[MEMBER_CAPTION]"/>
>              <LName name="[Store].[LEVEL_UNIQUE_NAME]"/>
>              <LNum name="[Store].[LEVEL_NUMBER]"/>
>              <DisplayInfo name="[Store].[DISPLAY_INFO]"/>
>              <PARENT_UNIQUE_NAME name="[Store].[PARENT_UNIQUE_NAME]"  
> type="xsd:string"/>
>              <Store name="[Store].[Store]" type="xsd:string"/>
>              <Store name="[Store].[Store]" type="xsd:string"/>
>              <Store name="[Store].[Store]" type="xsd:string"/>
>              <Store name="[Store].[Store]" type="xsd:string"/>
>              <Store name="[Store].[Store]" type="xsd:string"/>
>              <Store name="[Store].[Store]" type="xsd:string"/>
>              <Store name="[Store].[Store]" type="xsd:string"/>
>              <Store name="[Store].[Store]" type="xsd:string"/>
>            </HierarchyInfo>
>
>
>>
>>> Agreed, makes sense to add in the correct child names, I'm also very
>>> interested in JSON for delivering Dashboards via GWT...but I  
>>> digress.
>>
>> Yeah, seems like there's an untapped demand for integrating OLAP and
>> JavaScript. By the way, I'll ensure that what comes out in JSON are  
>> the
>> un-encoded names. Obviously, we want to see
> The demand arises from Execs/Customers being sold dashboards via  
> Powerpoints and mockups with Jaspersoft/Pentaho failing to deliver  
> on the original vision. Hence, folk are looking for a more flexible  
> dashboard solution. I hope to demo xmla4j to two needy customers  
> this week  so thanks for the heads-up on that utility.
>
>>
>> "[Store].[Store Name].[Store Type]": "Small Grocery"
>>
>> Rather than
>>
>> "_x005B_Store_x005D_ 
>> ._x005B_Store_x0020_Name_x005D_._x005B_Store_x0020_Type_
>> x005D_": "Small Grocery"
>>
>> Julian
>>
>> _______________________________________________
>> Mondrian mailing list
>> Mondrian at pentaho.org
>> http://lists.pentaho.org/mailman/listinfo/mondrian
>


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20100119/878a0f14/attachment.html 


More information about the Mondrian mailing list