Question

3
Replies
1111
Views
Close popover
Krishna Chaitanya Dhilli (DhilliChaitanya)
Mindtree
Senior Engineer
Mindtree
AU
DhilliChaitanya Member since 2014 21 posts
Mindtree
Posted: February 26, 2019
Last activity: March 9, 2019
Closed

Report Definition is not fetching the data from Exposed Column

To improve the report performance , optimized the property which is in work class and data is saving to that exposed column but RD is still fetching data from BLOB.

In Property advanced tab,I could see it is optimized only for work class(TGB-FAS-Work) not to implementation classes (TGB-FAS-Work-AP) & (TGB-FAS-Work-EM).

If I try to optimize again,getting the error "Column names in each table must be unique. Column name 'TotalAmount' in table 'dbo.pc_TGB_FAS_Work' is specified more than once."

Tried below approaches:

1. Saved the Work class Database table after optimizing

2. Saved the RD to new Ruleset version

Any Suggestions to fix this?

Data Integration Reporting
Moderation Team has archived post