Jaspersoft picking up Attribute from a different Domain with same name

Document ID : KB000099424
Last Modified Date : 01/06/2018
Show Technical Document Details
Question:
The Jaspesoft Ad Hoc View is picking up an attribute from a different Domain (Project instead of Investment), for an Attribute which has the same name in both locations.

The Attribute name has been changed, but even after running Load Data Warehouse (Full), the issue remains.

For example, the 'Product Grouping' field of the Product Alignment Object has a Lookup value 'Fixed Other'.

It is appearing as 'FIX_Other' under the Ad Hoc View. However, it is configured as 'Fixed Other' under the Product Grouping field Dynamic Lookup.

In Ad Hoc Views, the values are coming from the wrong domain.
Answer:
Even though the Attribute Name is different now, at some point of time the past, names may have been the same.

A Load Data Warehouse (Full) Job should have picked this up, but in this case didn't.
(There possibly may be an issue with a complex Dynamic Lookup setup.)

The resolution is the same, as for any issue where a "Jaspersoft Ad Hoc View or Report is not showing the right Objects/Attributes/Values compared to the CA PPM Database."

That is, exclude the item from Load Data Warehouse, then add it back in.

STEPS
1. Exclude the Attribute (Product Grouping) from Load Data Warehouse, by unchecking its DWH flag against the attribute.
2. Run the Full Load Data Warehouse Job
3. Include the Attribute back into "Include in Data Warehouse."
4. Run the Ful Load Data Warehouse Job again.