how many primary keys can w have in cube, ods objects?

[Former Member]

how many primary keys can w have in cube, ods objects?

[former_member205352]

In general for all database tables you can have only

16 primary Keys.

Since Cube and ODS are also tables it cant exceed 16.

Hope this helps.

[Former Member]

Hi Naresh,

16 primary keys only possible(for cube: 16 dimensions, ODS - Keyfields)

For ODS:

- You can create a maximum of 16 key fields (if you have more key fields, you can combine fields using a routine for a key field (concatenate).)

- You can create a maximum of 749 fields

- You can use 1962 bytes (minus 44 bytes for the change log)

- You cannot include key figures as key fields

More info: [Creating ODS Objects|http://help.sap.com/saphelp_nw04/helpdata/EN/4a/e71f39488fee0ce10000000a114084/content.htm]

Hope it Helps

Srini

[Dont forget to close the call by assigning poings.... - Food for Points: Make a Difference through Community Contribution!|https://www.sdn.sap.com/irj/sdn/index?rid=/webcontent/uuid/007928c5-c4ef-2a10-d9a3-8109ae621a82]