August 19, 2004 at 8:49 am
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
August 19, 2004 at 1:16 pm
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.
Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply