creating dynamic translation

hi

is there a way to create a dynamic translation for a cube ?

i have another table that translate words and i want to that the cube dimensions names and the measures name will translate by the table i have

is there a way i can do it ?

Thanks

Eyal

Hi,

AS2005 can do what you described for attribute members, but not for cube dimension names and measure names. For attribute members, in the dimension editor (in BI Development Studio), in the Translations tab, you can specify for each attribute the column (from the relational table) from which to get the translated member names. For everything else (dimension names, hierarchy names, cube dimension names, measure names etc) AS2005 allows specifying a static text per language (the translated name).

However, you can use AMO (the management object model for AS2005) to dynamically read from the relational data table and create a Translation (with the static name) for each cube dimension and measure.

If AS2005 were to support natively this scenario, on each process of the cube, you would have gotten the new translated names for cube dimensions and measures. But if you do not have frequest changes in the translations table, then it should be acceptable to create the translations manually (and only update them from time to time, not necessarily on each cube re-process).

Quick startup on AMO: http://adriandu.spaces.live.com/

To create the translated names for cube dimensions and measures, there are the CubeDimension and Measure classes, each having a collection of Translation objects; each Translation specifies the Language (as an LCID) and the Caption (the text you will read from the relational translations table).

Adrian Dumitrascu

Creating Defaults using Column Names

Hello to everyone,
Please help me on how to Create Defaults using Column Names.
I also don't how to use computed column names. If the latter is the answer.
Please help.
Thanks> Please help me on how to Create Defaults using Column Names.
> I also don't how to use computed column names. If the latter is the
> answer.
> Please help.
If you tell us **what** you want to do (not **how**), we might be able to
suggest something.|||Have you read this, yet?
http://msdn.microsoft.com/library/d... />
2_8g9x.asp
Based on your post I'm not quite sure what you need, so here goes:
To add a default constraint after the table has been created:
alter table <table>
add constraint <default name>
default (<default expression> )
for <column>
[with values]
To add a computed column after the table has been created:
alter table <table>
add <computed column> as (<expression> )
Does this come close to your expectations?
ML
http://milambda.blogspot.com/|||ML wrote:
>Have you read this, yet
>http://msdn.microsoft.com/library/d.../>
e2_8g9x.asp
>Based on your post I'm not quite sure what you need, so here goes:
>To add a default constraint after the table has been created:
>alter table <table>
> add constraint <default name>
> default (<default expression> )
> for <column>
> [with values]
>To add a computed column after the table has been created:
>alter table <table>
> add <computed column> as (<expression> )
>Does this come close to your expectations?
>ML
>--
>http://milambda.blogspot.com/
Hi to all,
When we voucher, we need to default Distribution date column based on
invoice date column.
For example: Our invoice date is 01/31/06 then our Distribution date field
should also be 01/31/06. In order to avoid mistake in manually inputting the
Distribution date then I think we might as well default the Invoice to
Distribution date using SQL script.
However whenever I am checking Default function, it seems it only allows
constant values.
Please help.
I really love this website amongst others. You can understand inquirers here
as not a technical person so you really explained it very well. Thanks so
much and good day to everyone!
Message posted via http://www.webservertalk.com|||minda wrote:
>[quoted text clipped - 20 lines]
>Hi to all,
>When we voucher, we need to default Distribution date column based on
>invoice date column.
>For example: Our invoice date is 01/31/06 then our Distribution date field
>should also be 01/31/06. In order to avoid mistake in manually inputting th
e
>Distribution date then I think we might as well default the Invoice to
>Distribution date using SQL script.
>However whenever I am checking Default function, it seems it only allows
>constant values.
>Please help.
>I really love this website amongst others. You can understand inquirers her
e
>as not a technical person so you really explained it very well. Thanks so
>much and good day to everyone!
Please help. Thank you in advance for your time.
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Forum...amming/200602/1|||minda wrote:
>[quoted text clipped - 20 lines]
>Please help. Thank you in advance for your time.
Can someone help me on this matter? Please let me know if you need further
data. Thanks again.
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Forum...amming/200602/1|||So what you want to do is set a default value based on the value in another
column?
"minda" <u18464@.uwe> wrote in message news:5b7ba24bb8e97@.uwe...
> Hello to everyone,
> Please help me on how to Create Defaults using Column Names.
> I also don't how to use computed column names. If the latter is the
answer.
> Please help.
> Thanks|||Jim Underwood wrote:
>So what you want to do is set a default value based on the value in another
>column?
>
>[quoted text clipped - 3 lines]
Yes, abosolutely. Thanks for understanding. Please help.
Message posted via http://www.webservertalk.com|||minda wrote:
>[quoted text clipped - 4 lines]
>Yes, abosolutely. Thanks for understanding. Please help.
Is my question very hard? I am sorry for taking your time. Thanks again.
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Forum...amming/200602/1|||The question is not hard, just that we didn't understand what you wanted.
You may want to use a trigger for this, rather than using the default value
setting in EM. I haven't done much with triggers myself, so I'll let
someone else speak to the best way to go about it.
"minda via webservertalk.com" <u18464@.uwe> wrote in message
news:5b9e170dee63f@.uwe...
> minda wrote:
another
>
> Is my question very hard? I am sorry for taking your time. Thanks again.
> --
> Message posted via webservertalk.com
> http://www.webservertalk.com/Uwe/Forum...amming/200602/1