EEC note: I have already described the setting in Article BI Answers - Tips / tricks with the PivotTable . Unfortunately, it is stated at the end, so it's easy to overlook - because once again and get:
Oracle BI enables reporting to a report in the form of contingency tables. Build a PivotTable is far easier than in Excel. For larger amounts of data, however, may easily happen that exceeds the "default" limits that are set for the pivot table after installing Oracle BI. default for PivotTable melting process than 20,000 lines and 150,000 display cells. For easy display the report in the form PivotTable modification is necessary in the configuration file ... \ OracleBIData \ web \ config \ instanceconfig.xml . A larger parameter values by one to two orders:
Contents configuration file will be adjusted as follows:
Oracle BI enables reporting to a report in the form of contingency tables. Build a PivotTable is far easier than in Excel. For larger amounts of data, however, may easily happen that exceeds the "default" limits that are set for the pivot table after installing Oracle BI. default for PivotTable melting process than 20,000 lines and 150,000 display cells. For easy display the report in the form PivotTable modification is necessary in the configuration file ... \ OracleBIData \ web \ config \ instanceconfig.xml . A larger parameter values by one to two orders:
- CubeMaxRecords
- CubeMaxPopulatedCell
- MaxCells
Contents configuration file will be adjusted as follows:
Posts
