Attributes in Report Builder

Hi Richard,

We need more information to answer correctly:
- What version of JTS, DNG, JRS are you using?
- Are you using data warehouse or LQE data source?
- Are these missing attributes custom attributes you have defined in DNG? If not, what kind of attributes are present and what are missing?

Possible causes are:
- 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).
- 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.
- It could be that schema RICALM is not present in DW database somehow, and custom attributes are not loaded into DW (data warehouse).
- It could be that these missing attributes never have values in DNG, so it is ignored by JRS.

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

Hi Richard,

If you got "No result found", then it means the RICALM schema exists but no data inside. It is less likely caused by repotools-jts.

The first (original) query you presented is nothing related to custom attributes. If you get empty result with this query, then I am afraid you have not run DCC job ever.  The first query is retrieving data from Data-mart jobs (as opposed to ODS jobs), so ensure if you run DCC job ( both ODS and meta-data) successfully. If you have not run DCC job, then of course custom attributes are not listed in the condition. You can run DCC job from https://servername:port/dcc/web

For troubleshooting further, there are four types of JRS reports:
1. ODS (Current data) with standard attributes
2. ODS (Current data) with custom attributes
3. Data-mart (Historical trend) with standard attributes
4. Data-mart (Historical trend) with custom attributes

Let me know which is is successful and which one is not.