DhilliChaitanya Member since 2014 20 posts
Posted: 1 year ago
Last activity: 1 year 6 months ago

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
Share this page LinkedIn