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…

BO 6.5 Repository Tables

BO 6.5 repository has 3 different domains and each one has different set of tables to hold the respective information in tables. These tables are exactly same as the database tables. Security Domain Document Domain Universe Domain Security Domain has 25 tables. 1. OBJ_M_ACTOR 2. OBJ_M_USRATTR 3. OBJ_M_DOCCST 4. OBJ_M_GENPAR 5. OBJ_M_MAGICID 6. OBJ_M_RESLINK 7.…

Index-aware prompt in SAP BI 4.o IDT

Index Awareness is the ability to take advantage of the indexes on key columns to speed up data retrieval. An index-aware prompt takes advantage of indexes on key columns in tables when accessing lists of values. You can define the index-aware prompt in IDT parameter section so that when running the query, you can see…