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
Quote from: en1 on 07 Sep 2017 10:45:12 AM
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.
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
Quote from: en1 on 08 Sep 2017 01:49:53 AM
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.