Skip to Content
0
Former Member
Aug 10, 2012 at 07:00 PM

Matrix type dimension-how to handle

14 Views

I have a table A in HANA with one varchar(30) column and it has 800 distinct values like

Table A

Column A

abc

bcd

.

.

.

.

.

xyz

then I have another similar Table B in HANA with one varchar(30) column and it has 800 distinct values and all the values

are same as in table A

Table B

Column B

abc

bcd

.

.

.

.

.

xyz

I want to create a dimension (attribute view in HANA based on above mentoned 2 tables) and View will look like

Attribute View

Column A ColumnB

abc def

ghi abc

.

.

.

.

.

xyz ghi

Can I do it in attribute view in HANA or I have to use DataServices to load data in HANA table like this attribute view.Please suggest

best way to handle this.