Question
Anthem
US
Last activity: 18 Apr 2022 7:48 EDT
Easy process to identify all the columns which are required to be exposed.
Hi Team,
For one of our applications, I see lots of reports running on BLOB data, Is their any easy process or API to identify all the columns which are required to be exposed so as to avoid using the UDF’s.
Please suggest.
Thank you.
Anthem Inc
IN
@PradeepPydi you can easily right an utility to run all the reports in the application to see if pr_read_stream functions being used which will tell you a column is not exposed.
Ernst & Young LLP
MT
Not aware of any OOTB report to produce list of such report def rules, but you may follow these solution -
Normally when you save a Report def rule with reference to a property in BLOB, PRPC adds a guardrail warning to that rule (e.g. "These properties are not optimized: .pxDebugSwitch. Displaying them may result in poor performance. Consult your system administrator about optimizing properties for reporting.").
You can download the list of guardrail warnings from that application and look for such warnings.
Hope it helps.