Thanks a lot for your response. See my answers below.

>What version of JTS, DNG, JRS are you using?
6.0.3 for all.

>Are you using data warehouse or LQE data source?
Rational Data Warehouse.

>Are these missing attributes custom attributes you have defined in DNG? If not, what kind of attributes are present and what are missing?
Yes.

>If you are using old version of JRS such as 5.0.x, custom attributes might not be available, and need to upgrade JRS to the latest version (at least 6.0.1).
Nope, started on 6.0.2, now on 6.0.3.

>It could be that you need to refresh the meta model in JRS data source (Go to https://  server  :  port  /rs/setup , open data source, and click on "Refresh" button on top right) to load custom attributes.
Thanks for these instructions. I did these, but nothing changed.

>It could be that schema RICALM is not present in DW database somehow, and custom attributes are not loaded into DW (data warehouse).
Is there some way for me to check this?

>It could be that these missing attributes never have values in DNG, so it is ignored by JRS.
Nope, we have 18000+ artifacts using these attributes.

Thanks,
Richard

Hi Kenji,

Thanks for the detailed response. I tried that advanced query you sent, but it returns "no results found" when I run the report. I do not know how I would run the command "repotools-jts" on the server, since it's a cloud-based server hosted by IBM.

The original query, choosing a random attribute, automatically created by Report Builder, was:

SELECT T1.PERIOD_START_DATE,
       SUM(T2.TOTAL_REQUIREMENTS) AS METRICSVAR14
FROM RIDW.D_DATE T1
INNER JOIN RIDW.F_REQUIREMENT_METRICS T2
ON (T1.DATE_ID = T2.DATE_ID)
  INNER JOIN RIDW.D_REQUIREMENT_CLASSIFICATION T3
  ON T3.REQUIREMENT_CLASS_ID=T2.REQUIREMENT_CLASS_ID
WHERE T2.PROJECT_ID = 2  AND
(  MONTHS_BETWEEN(CAST(CURRENT_TIMESTAMP AS DATE), CAST(T1.PERIOD_START_DATE AS DATE)) <= 3 AND
  DAYS(CURRENT_TIMESTAMP ) - DAYS(T1.PERIOD_START_DATE) >= 0 AND
  T3.NAME = 'Business Goal'
) AND
(T1.DATE_ID <> -1 AND T1.DATE_ID IS NOT NULL) AND
(T2.REQ_METRIC_ID <> -1 AND T2.REQ_METRIC_ID IS NOT NULL)GROUP BY T1.PERIOD_START_DATE

And the new query, for the attribute Elec Status, was:

SELECT DISTINCT T1.NAME,
       T2.LITERAL_NAME AS LITERAL_NAME
FROM RIDW.VW_REQUIREMENT T1
LEFT OUTER JOIN RICALM.VW_RQRMENT_ENUMERATION T2
ON T2.REQUIREMENT_ID=T1.REQUIREMENT_ID AND T2.NAME='Elec Status'
WHERE T1.PROJECT_ID = 2
 AND
(T1.ISSOFTDELETED = 0) AND
(T1.REQUIREMENT_ID <> -1 AND T1.REQUIREMENT_ID IS NOT NULL)

I tried it without the space as well, ElecStatus, even though there is a space in DNG, but the result was the same.

Thanks,

Richard