Error XQE-PLN-0298 member already exists (cashe problem)

[en1]

Hi
I have hierarchy with member that have been changed in source table (member_caption ) since date 2017-01-01 and when i restart report on next date - error XQE-PLN-0298 member already exists.if local cashe is off no problem. (Cognos 10.2.1) Help me please

[MFGF]

Hi
I have hierarchy with member that have been changed in source table (member_caption ) since date 2017-01-01 and when i restart report on next date - error XQE-PLN-0298 member already exists.if local cashe is off no problem. (Cognos 10.2.1) Help me please

Hi,

Is the source a Dynamic Cube? The message you're seeing means you have a non-unique MUN (Member Unique Name), and this points to an issue in the modelling of your cube.

MUNs always need to be unique, so you need to define the member keys using values that will not change.

Cheers!

MF.

[en1]

thanks for your reply!
It is DMR
DQM with local cashe is on. Source is DB table:

(Slow change dimension)
ID Code Name        SD            ED
1    1      'A'      2016-01-01  2017-01-01
1    1      'B'      2017-01-02  2018-01-01

Code is _business_key and _member_description
Name is _member_caption
Error  "XQE-PLN-0298 member already exists"
ocсurs when report was generated with parameter data = 2017-01-01 and next run with 2017-01-02

1 report run generate SQL query to DB like this:
select ID,Code,Name from D1 where  2017-01-01 between SD and ED

2 report run:
select ID,Code,Name from D1 where  2017-01-02 between SD and ED

so _member_caption has been changed  but it is typical SCD behavior

[MFGF]

thanks for your reply!
It is DMR
DQM with local cashe is on. Source is DB table:

(Slow change dimension)
ID Code Name        SD            ED
1    1      'A'      2016-01-01  2017-01-01
1    1      'B'      2017-01-02  2018-01-01

Code is _business_key and _member_description
Name is _member_caption
Error  "XQE-PLN-0298 member already exists"
ocсurs when report was generated with parameter data = 2017-01-01 and next run with 2017-01-02

1 report run generate SQL query to DB like this:
select ID,Code,Name from D1 where  2017-01-01 between SD and ED

2 report run:
select ID,Code,Name from D1 where  2017-01-02 between SD and ED

so _member_caption has been changed  but it is typical SCD behavior

Hi,

So this is a DMR model over a Type 2 slowly changing dimension? In that case, although the code remains the same for name changes, I would expect to see a unique surrogate key which does change on every row. Is this your ID column? If so, why does it have a repeating value for both rows?

Assuming it's a typo in your post and the ID values are 1 and 2, then you should use the ID as the _business_key in your DMR so that it is unique.

Cheers!

MF.