Scheduled WebI Report / Document is not generating .csv format file for report data, but creating csv file with data providers (queries) data

Scheduled WebI doc is not generating .csv format file for report data, but creating csv file with data providers (queries) data and its behavior of Webi report from beginning. Meaning CSV format always generate complete data providers data not the formatted / calculated report data. Save As/Schedule to CSV will give the raw data of…

SAP Business Object BI 4.3

SAP Business Object BI 4.3 SAP BO BI 4.3 RTC (restricted shipment) will be available in late 2019, with GA (general availability) in mid-2020. Mainstream maintenance will continue through 2026 or longer. BI 4.3 plans to incorporate significant changes in their new release. • A major improvement is the new default Fiori launchpad, which will…

SAP BO BI 4.2 SP6 Future Roadmap

SAP is planning to release SAP BO BI 4.2 SP6 in Agust 2018 and there will be many more new functions and futures involved in that release. below are some highlights from that release. Quickly build ad-hoc queries and interactive reports without a knowledge of SQL or the underlying data structure Access to heterogeneous data…

@DerivedTable Function in IDT

@DerivedTable is a new function in IDT and its used within the derived Table and also called as “’derived table on a derived table”. @DerivedTable function in the definition of nested derived tables and is a table that is derived from at least one existing derived table. The syntax of the @DerivedTable function is: @DerivedTable(<Derived…

Oracle 11g to Oracle 12c Upgrade – BO Webi Report issue (ORA-04030: out of process memory & ORA-00920: Invalid Relational Operator)

Business Objects Webi reports with huge number of objects (huge SQL) which was refreshed successfully when the report runs on Oracle 11g database. As part of the organization upgrade program, all the Oracle databases have been upgraded to Oracle 12c. Post upgrade, some of BO reports with huge SQL are not refreshed and throws “ORA-04030:…