Lo.

I would like to translate dimensions, measures, and all language dependent
texts.

I'm looking for a VB6 sample that parse and change these texts. Which access
method should I use to manipulate a cube DSO, ADOX, ADOMD ?

Thanks for your help

Jo

If what you want is translating object (dimensions, levels, etc.) names in
a client application before displaying them to the user in UI components,
then you should use ADOMD.
However, if you want to actually rename the server objects, then you have to
use DSO. In this case, you would have to be very careful with dependencies.
For instance, dimension or level names may be referred to in Calculated
Members, Named Sets, Security Roles and other elements.
HTH,
Brian
www.geocities.com/brianaltmann/olap.html

"JO" wrote:

Several techniques to change the "names" of things.
1) Use the Metadata Scripter utility on the SQL Server 2000 Resource Kit
(available at your local bookstore; or if you can find someone in your
company with a TechNet distribution, it is on the RK CD). With it, you point
to an AS object and it will generate a VB program which will re-create that
object. Reading the VB code, it is quite clear how to use DSO to accomplish
the same thing in your application
2) Use the DSO/XML utility to script the object out as a XML file; modify
the XML file, then script the object back in again. See
http://www.microsoft.com/downloads/d...displaylang=en
3) If by "translate", you mean rendering different captions for a member
based on the language of the client machine, then look in BOL under the
topic: "Multiple Language Implementation Using Member Properties"

Hope that helps.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"JO" <jostorero (AT) iware (DOT) deletethis.ch> wrote