多语言对于一个全球化的公司来说是很重要的。在SAP ERP系统中,所有的内容都是多语言支持的。
SAP的HANA也是支持这种多语言的。这里calculation view来举例。
1. 在SQL EDIT里创建两个表,表student保存学生的基本信息。studentname保存学生的多语言的名字
create column table student(id integer,age integer,gender char(1))
insert into student values(1,25,'M')
create column table studentName(id integer, sname nvarchar(20), langu char(1))
insert into studentName values(1,'Marx','E');
insert into studentName values(1,'马克思','1');
insert into studentName values(1,'막스','3');
insert into studentName values(1,'Μαρξ','G');
注意:这个的langu列的值可以从T002表里拿到,或者查看appendix。
2. 创建一个Calculation view
添加表student和studentname
3. 在calculation view里的design区域用一个join,通过ID把两张表join起来
4. 在properties面板中,设置join type为Text Join, Language Column选择langu
5. 激活,预览。如果你的默认登入语言是英文的,那结果就是下面这个
6. 修改用户的登入语言,在HANA系统上右键点击,属性,additional properties。更改Locale的语言
7. 再预览
SPRAS | SPTXT |
0 | Serbian |
1 | Chinese |
2 | Thai |
3 | Korean |
4 | Romanian |
5 | Slovenian |
6 | Croatian |
7 | Malay |
8 | Ukrainian |
9 | Estonian |
A | Arabic |
B | Hebrew |
C | Czech |
D | German |
E | English |
F | French |
G | Greek |
H | Hungarian |
I | Italian |
J | Japanese |
K | Danish |
L | Polish |
M | Chinese trad. |
N | Dutch |
O | Norwegian |
P | Portuguese |
Q | Slovak |
R | Russian |
S | Spanish |
T | Turkish |
U | Finnish |
V | Swedish |
W | Bulgarian |
X | Lithuanian |
Y | Latvian |
Z | Customer reserve |
a | Afrikaans |
b | Icelandic |
c | Catalan |
d | Serbian (Latin) |
i | Indonesian |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Subject | Kudos |
---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
User | Count |
---|---|
35 | |
25 | |
14 | |
13 | |
7 | |
7 | |
6 | |
6 | |
5 | |
5 |