BO Notes

Infoview can not connect to the server.Close the report panel and try to connect again or see your BusinessObjecrs administrator. we are upgrading from BOXIR2 to BOXI3.1. some of the complex formulae is not migrated properly.extra characters displays in deski reports. When I open deski or webi rich client, I am getting the below error. The procedure entry point?Error@TraceLog@@3ABVImportant@1@B could not be located in the … Continue reading BO Notes

Showing continuously Loading message – Webi BI Lanchpad

I installed SAP BOBJ BI4.0 SP2 on my machine. Started working on it. All full client tools are working fine but unable load the universes in Webintelligence through BI Lanchpad. It is showing continuously Loading message as shown in screen. Really it was annoyed me. Checked all the possible ways to resolve this issue. But I noticed it is a piece of work.   I don’t have … Continue reading Showing continuously Loading message – Webi BI Lanchpad

Unable to open CMC and infoview in google chrome browser

Infoview: HTTP Status 404 – /BOE/portal/1211121324/InfoView/App/home.jsp type Status report message /BOE/portal/1211121324/InfoView/App/home.jsp description The requested resource (/BOE/portal/1211121324/InfoView/App/home.jsp) is not available. Apache Tomcat/6.0.24 CMC: HTTP Status 404 – /BOE/CMC/1211121324/InfoView/App/home.jsp type Status report message /BOE/CMC/1211121324/InfoView/App/home.jsp description The requested resource (/BOE/CMC/1211121324/InfoView/App/home.jsp) is not available. Apache Tomcat/6.0.24 Continue reading Unable to open CMC and infoview in google chrome browser

BusinessObjects Product versions

The build version of BO XI Enterprise can see at Settings area of the CMC. Build version of individual services can be obtained from the CCM. For Designer, DeskI…, right click on the executables (BusObj.exe, Designer.exe, etc.) and choose Properties -> Versions. (For a Windows installation, the executables are installed at the following path: <BO install dir>\win32_x86). SAP BI BusinessObjects 4.0 Product version: XI 4.0 … Continue reading BusinessObjects Product versions

Aggregate Awareness example

Say We have three tables: YearTable, MonthTable, DetailsTable In the tables, you have the columns: YearTable.Year YearTable.OrdAmountYr MonthTable.YrMonth MonthTable.OrdAmountMo DetailsTable.OrderDate DetailsTable.OrderAmount You would create three dimension objects, one for each of the date parts above, plust your one measure object “Order Amount” in the universe would be defined as: @AggregateAware( Sum(YearTable.OrdAmountYr), Sum(MonthTable.OrdAmountMo), Sum(DetailsTable.OrderAmount) ) This formula, plus the proper Agg Aware Navigation in Designer, sets … Continue reading Aggregate Awareness example

Businessobjects Notes

* # Getting unavailable error in webi in BEx on SAP BOBJ BI4.0 usually get when we use the measures which are coming out of BEx query universe. * YTD Measure: Sum ( Case when (table.Date) between trunc(sysdate,’yyyy’) and sysdate then fact table.measure end ) MTD measure: Sum ( Case when (table.Date) between trunc(sysdate,’mm’) and sysdate then fact table.measure end ) * Rank and sort can not be done … Continue reading Businessobjects Notes