Unique fields in tuples

[Former Member]

HI Experts,

Can you please, clarify on below points,

1.how to acheive uniqueness in tuples ?

when we make any field inside a tuple, it doesn't give us a option of making that field unique though it can be a DF.Any leads how we can achieve this?

2. What are the limitations of Tuples ?

3. Is validations and assignments are possible on Tuples ?

4.what are the differences between QT and tuples

Thanks & Regards,

Mahesh

Edited by: Mahesh Reddy on Jul 1, 2011 1:17 PM

[Former Member]

Hi Mahesh

Please see the replies below-

1.how to acheive uniqueness in tuples ?

when we make any field inside a tuple, it doesn't give us a option of making that field unique though it can be a DF.Any leads how we can achieve this?

As already explained this is not possible in data definition. Instead while importing the data for tuple in import map we have an option for selecting the Key update field for Tuple. So if we want to have a single set of tuple attributes for a key field, it can be selected.

2. What are the limitations of Tuples ?

Assigments and calculations are not supported for tuple fields.

Data export from data manager not supported.

Restricting role access for tuple fields not possible.

3. Is validations and assignments are possible on Tuples ?

Validations are possible but again in restricted fashion. Similar to Qualified table validations.

4.what are the differences between QT and tuples.

Tuples are more powerful and they can be used for modeling any nested structure. For more details pls read the console refernce guide.

Best regards-Ravi

[Erdal_Şimşek]

... and last but not least - it is not possible to extract a tuple's content from data manager - this needs to be done via syndicator ...

Regards,

Erdal

[Former Member]

1.how to acheive uniqueness in tuples ?

I agree with Adrivit,the uniqueness should be at the main table record level than at the tuple level.

2. What are the limitations of Tuples ?

Limitations are :

Assignments dont work at Tuple level.

You cannot set Role/Table level authorization on Tuplei.e you cannot control role based access on Tuples.

You cannot use Calculated Fields in a tuple.

3. Is validations and assignments are possible on Tuples ?

Assignments are not possible with Tuples.

I guess with Tuple level Validations are provided with SAP MDM 7.1 sp04,they work fine.

4.what are the differences between QT and tuples

Tuples are the next generation of Qualified tables and are meant to replace them in future.

They support multiple levels of nesting,i.e. you can have a tuple inside a tuple unlike Qulaified tables which support single level of nestingi.e you can only have a Qualified table.

Tuple import and usage is much simpler than qualified tables.

Thanks,

Ravi

[Former Member]

1.how to acheive uniqueness in tuples ?

its not possible to have a unique field in tuple.

but not sure why u would require it - i mean the uniqueness should be at the main table record level than at the tuple level.

2. What are the limitations of Tuples ?

Fields of a tuple cannot be calculated or assignment fields.

3. Is validations and assignments are possible on Tuples ?

no - they are at the record level

4.what are the differences between QT and tuples

Tuples generalize the concept of qualified lookup tables (e.g. qualified lookup --> qualified anything). And whereas qualified lookup tables support just a single level of nesting, tuples support arbitrarily deep multi-level nesting + a lot more func like reusabilty, achieving parent - child rel etc

hth

thanks

-Adrivit