Primary key in Dimension

[Former Member]

Dear Colleague,

We have SAP BPC 7.5 NW, SP10.

In any dimension primary key is ID. So dimension members can't repeated with same ID.

Our requrement is set our property RNN unique. We mean our dimension members can't repeated with same RNN.

Is it possible in SAP BPC 7.5 NW. If no, could we solved it in BW side?

Thanks,

Kadraliyev Yerlan

Edited by: Erlan Kadraliev on Feb 7, 2012 4:19 PM

[former_member313601]

Am I correct in saying that Dimension Id and RNN are mapped one-to-one?

If yes, why not make RNN as the dimension Id?

[Former Member]

Dear Colleague

Thanks for your answer Siva Namuduri .

This solution can be usefull for us and at the moment we looking advantages and disadvantages.

But do we have any other solution to make Property unique? Is it possible in BW side or FrontEnd(BPC)

Thanks,

Kadraliyev Yerlan

[RichHeilman]

No you can not restrict this from the frontend, not sure about in BW though.

Cheers,

Rich Heilman