Categories
Option to Exclude Columns in the XML Extract of BI Report
Organization Name
Oracle
Description
In the old Reports Builder tool, there used to be an option "Include in XML". Setting this property would include or exclude the value in the final XML generated.
It would be very useful if we have a similar option in the Data Model to include / exclude the filed in the XML. One suggestion to add an option in the Structure Pan of the Data Model. In the XML View , we can have an additional column "Include in XML" which will be a checkbox (Selected ON by default). The User can uncheck this option to ensure that the filed is excluded in the XML
Use Case and Business Need
In many cases of BI Report, we include a number of columns in the SELECT expression which would not be used in the actual Output. The would be internally used with the data model for custom elements (functions). Also many seeded reports are build with generic columns which increases the overall size of the XML.
For example, the Seeded Asset Register Report included a lot of columns which are not displayed in the Report. This resulting in Report generating a XML file of more than 500 MB for 100,000 Records. This can be avoided if some of the columns are excluded by default in the seeded Job.
Also this would be helpful when the customer requires a customized version of the Report based on the similar data model. The Implementer / Technical Team can include / exlude any columns that are relevant to their specific requirement.
Original Idea Number: 834dae88fb
Comments
-
Much needed!
0 -
0