Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Custom fields in Report Builder

Questions
Tags
Users
Badges
Elaine Humphreys
(23●3●7) Oct 26 '17, 10:49 a.m.

Hi -

I have built a report using report builder. A number of fields in the report are custom enumerations. A number of these fields are showing blank for all results even though all have values assigned. Do you have any advice on what could be the issue?

Thanks.

Best Regards,
Elaine.

0 votes

Comments
Kenji Sarai
Oct 26 '17, 8:48 p.m.

Hi Elaine,
We need more information as below
- What is the version of JRS? Old version might not support custom attributes.
- Where is the custom attribute? (eg. Workitem, Requirement) Does problem happen only in specific enumeration attribute or all custom attributes?
- What is the data source (Data warehouse or LQE)?
- Do you run the job (DCC or LQE) successfully after you made changes in this attribute?

Elaine Humphreys
Oct 30 '17, 5:17 p.m.

Hi Kenji -

The details are below - let me know if I have missed anything.

- What is the version of JRS? Old version might not support custom attributes.
I am using Java 7.
- Where is the custom attribute? (eg. Workitem, Requirement) Does problem happen only in specific enumeration attribute or all custom attributes?
The custom attribute is in a custom built work item type called 'Change Request'. the enum attributes we are having problems with only exist in the Change Request work item type.
- What is the data source (Data warehouse or LQE)?
I think this is Data Warehouse - how can I confirm?

- Do you run the job (DCC or LQE) successfully after you made changes in this attribute?
I don't run any job personally - again how do I confirm this?

Thanks.

Best Regards,
Elaine.

1 answer
1,369 views
0 votes

One answer

Permanent link
Kenji Sarai
(960●3●9) Oct 30 '17, 9:03 p.m.

Hi Elaine,

1. Firstly check the data source in Report Builder > BUILD > Choose report type. You can select either Data warehouse or LQE. if it is not clear, go to ADMIN > Data source to verify, or contact your system admin.

2. if it is a data warehouse, custom enumeration for workitem is stored in RICALM.VW_RQST_ENUMERATION table (view). In BUILD > Format Result > Advanced, run some SQL queries like
select ENUMERATION_NAME, LITERAL_NAME, PROJECT_ID from RICALM.VW_RQST_ENUMERATION
and find what you are after. If it is not found, it could be caused by DCC job.

3. DCC job for data warehouse can be checked from https://[server]:[port]/dcc/web . If you do not have a permission, contact your system admin. It could be that this job is not executed recently, and no data is updated into data warehouse.

4. The JRS (Report Builder) version is something like 6.0.x. if you are using old version such as 5.0.x. custom attributes might not be available in the report.

0 votes

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Oct 26 '17, 10:49 a.m.

Question was seen: 1,369 times

Last updated: Oct 30 '17, 9:03 p.m.

Confirmation Cancel Confirm