Question

3
Replies
1285
Views
Krishna Chaitanya Dhilli (DhilliChaitanya)
Mindtree
Module Lead
Mindtree
AU
DhilliChaitanya Member since 2014 21 posts
Mindtree
Posted: February 26, 2019
Last activity: March 9, 2019
Posted: 26 Feb 2019 7:15 EST
Last activity: 9 Mar 2019 15:33 EST
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, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.