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:…

@Execute Function in IDT

@Execute is a new function in IDT and can be used to filter the report data based on pre-defined condition and also it can be used to filter the report data based on the user using ‘BOUSER’ function. @execution function uses to execute the list of values and it can work only in WHERE clause…

SAP Business Objects BI 4.2 SP5 What’s New

This post summarizes the SAP BO BI 4.2 SP5 features. Many enhancements were introduced in SAP BI 4.2 SP4 and its support packages. SAP continued their enhancements and innovation efforts in SAP BI platform, Web Intelligence, Semantic Layer, Report Conversion tool, BI Launch Pad, etc., and the enhancements are released in SAP BO BI 4.2…

System Variable functions / @Variable function in IDT

System variable functions are existing features which are not displayed in Universe designer and added as a separate section in IDT. System variable functions can be assigned to @variable to retrieve the respective values. It is essential note that @Variable is a universe function along with @Prompt, @Select, @Where, @aggregate_aware to be used in the…

Query Builder in BO – Additional Queries

I have already shared complete details on the Query builder CMS tables in the below blog https://dwbicastle.com/2014/01/27/query-builder-in-bo-browse-query-bo-repository/ here added additional queries to get more details from the CMS. To get cluster server details: SELECT SI_CLUSTER_MEMBERS FROM CI_SYSTEMOBJECTS WHERE SI_ID=4 To get public folder and their subfolder details. SELECT * FROM CI_INFOOBJECTS WHERE SI_PARENTID=23 Public folder…