nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Data Model not display expected Computed Column : Data Object

RRK

Hi,
 
I am trying to use a data model in a report which is connected to a Data Object as a Data source.
 
The problem I am getting here is that the computed column "AVERAGE_AMOUNT" is not getting displayed in data model.
 
Please find attached files which will show old and new scenario which I tried.
 
Data_Object.datadesign : I have created this data design file which will generate .data file : Data_Object.data
 
Data_Object.data : Generated from Data_Object.datadesign
 
BIRT_REPORT.rptdesign : Report which is using Data_Object.data as Data source but getting problem in fetching AVERAGE_AMOUNT column in data model.
 
Also I have attached screen shots which will explain the problem.
 
Problem : When a new computed column is created in existing data design it does reflect this computed column when used in BIRT report.
 
Please note : Create a new .data file before generating this report as its not allowing to add .data file to this post.
 
I guess this is some referencing issue but not quit sure.
 
 
Please let me know if I am doing something wrong in this case.
 
Thanks in Advance!!!

Find more posts tagged with

Comments

RRK

could some one look into this ?
 
Thanks in advance

pricher

Hi,
 
You have probably created the computed field AVERAGE_AMOUNT after you already created your Data Model. In that case, you need to add the new column manually to the list that appears in the Categories listing. To do so:
 
1. Right click on the category where you want to add the field and choose New Column:

RRK

Thanks Pierre this what I was looking for!!!!