Translations in XMLA  

Posted in ,

MSAS 2003/2005 supports translations for dimensions and measures.
In my task i must set translations for XMLA (OLAP) for PHP client.
(accessing by PHP SOAP through IIS)

If you want to use translations in MDX query you may use properites
like Properties("LCID1036"), where "LCID1036" is Locale ID.
Full article about it at sqlblog.com.

Other way is using custom caption in MDX query like this.


WITH member [Measures].[ruClients] as [Measures].[Clients],
caption = 'caption'
SELECT
{[Measures].[ruClients] } ON 0,
NON EMPTY [time].[week].children ON 1
FROM [payments]


Next you can set location in SOAP request. By using SQL Server Profiler Excel's XMLA
command can be found. Here exists field 1049.


< PropertyList xmlns="urn:schemas-microsoft-com:xml-analysis">
< Catalog>SomeMSASDatabase
< LocaleIdentifier>1049
< DataSourceInfo/>
< Content>SchemaData
< Format>Tabular
< /PropertyList>


P.S. Sorry for my English :(

0 responzez

Post a Comment

metanews


Add to Google