Duplicate members in parent-child dim + writeback

Hello,

I have this problem: I need duplicate members in parent-child dim. I searched web and i find this solution http://www.sqlserveranalysisservices.com/OLAPPapers/DuplicateMembers.htm by Richard Tkachuk. I'm using dimension in cube. And I want to use writeback to this cube. And that is the problem.

For example:

dimension structure employee

Boss Fred

Michael

Sam Will

Rachel Sam1 Will1

For the second occurrence of Sam and Will I changed Unique Name and add calculation to get right value from fact table.

But when I use UPDATE CUBE ... and change value of Will, Will and Will1 will have different values. Will the old one and Will1 the new one.

Can anybody help me, how to use duplicate members with writeback ?

Thank's

Erik

(Please excuse me my English.)

From your description it sounds like what is happening is that the "Will" member is the one with the formula and that the "Will1" member is the original member and that when you are doing the write back it is overwriting the formula, not writing into the original member. So if you could check if the member has a "Source Member" before writing back and either block the write back or re-direct the write back to the "Source Member" you should be able to get this working.|||

I know about this solution, but i'm trying to find solution without checking property 'Source Member'. From my aplication it isn't problem, but I want to use this dimenion from other clients too.

Thank's

Erik

|||I am not aware of any other solution, the writeback facility is just not that sophisticated. You can't intercept writebacks and the writeback cannot allocate back through a formula (which would be nice, but you can imagine how complicated it could get)|||

Thank's anyway..

Erik