Use of Principal Key in HANA

[nikhil_joy2]

Hi,

Can somebody explain the use of principal key in an attribute view in HANA. Also the importance of pricipal key in a parent-child hierarchy.

Your inputs would be appreciated. Thanks in advance.

Regards,

Nikhil Joy

[Former Member]

Hello Nikhil,

Regarding Parent Child hierarchy see the below link:

http://technet.microsoft.com/en-us/library/ms174846.aspx

And regarding Principal Key, if you want to make any non-key attribute in your attribute view as "Parent" you can make that property = "True" so that you will be able to create a parent-child hierarchy in SAP HANA.

Hope this helps a bit for you.

Regards,

Krishna Tangudu

[nikhil_joy2]

Hai Krishna,

Thanks for your inputs...

I can not define more than one node.

For eg. I have 3 fields Country , state , city.

Country is defined as prinicpal  key.

But i need to create the parent child hierarchy as

Key attribute         Parent

Country

State                   Country

City                     State.

As country is the first node, so we should not define any parent for the country.

But i can add the Key attribute as country and parent as Customer ID. After that i cannot define anything.

How can we create the above flow.

[Former Member]

Hi Nikhil,

If you have 3 fields then you should go for a level hierarchy and not Parent Child Hierarchy. The parent Child Hierarchy can only be created when you have only 2 concerned field in which one will act as parent and the other will act as child.

Regards,

Piyush