Who can help me!

  • I have just started using MSO AS.

    My problem is, that my firm is placed in Denmark, but have a lot of branches around the world. Therefore it will be good if someone will give me on solution, where my my cube can show the description and a description in an other langauge.

    the table I use in the cube has following columns!

    P_ORG, C_ORG. C_ORG_DESC, V_ORG

    Maybe a MDX can help me

    Thank you in advance

    Morten Tvergaard

    Denmark

  • I can think of only one way to do this in AS 2005.

    1) Extend your dimension table to provide a column for each language that you want to translate into. Populate it with the translations.

    2) Use dimension member properties to expose those columns.

    3) You can access member properties through MDX, essentially you would have multiple copies of the same report (one for each language), the only difference being that each one selects the appropriate member property for that language.

    Does that make sense? You will have to read up about member properties. Post here if you have any problems.

     

    For what is worth (and this doesn't help you one little bit) AS2005 has functionality to allow you to do exactly what you are trying to do here i.e. Display different translations of the same dimension member.

     

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply