BO Notes

  1. Infoview can not connect to the server.Close the report panel and try to connect again or see your BusinessObjecrs administrator.
  2. we are upgrading from BOXIR2 to BOXI3.1. some of the complex formulae is not migrated properly.extra characters displays in deski reports.
  3. 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 dynamic link library TraceLog.dll
  4. I am using UserResponse(“Enter Date:”) function in a report. Date format is M/D/YYYY HH:MM:SS AM/PM(10/6/2009 12:00:00 AM)How to display the date format into 10/06/2009=formatdate(todate(UserResponse([Data Provider];”Enter Date:”);”M/d/yyyy hh:mm:ss a”);”MM/dd/yyyy”)
  5. BOXI3.1 log file after importing/Migrating the objects from BIAR:<Installed Drive>:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\Logging
  6. Differences between section and break:You apply a break to a table, you apply a section to a report.A section can have many tables or graphs, a table can have many breaks.A break allows you to group data in a table that you don’t want to see repeated.Grouping is also available in the Maps section, whereas breaks are not.
  7. Formula for this requirement :if [Sales]>0 [Sales] and [QuantitySold]<5000 then “Normal” esls if [Sales]>5000 [Sales] and [Sales]<=10000 then “Medium Sales”=If(([[Sales]]>0 [Sales] and [[QuantitySold]]<5000);”Normal”;If(([[Sales]]>5000 [Sales] and [[QuantitySold]]<=10000);”Medium Sales”;””High Sales))
  8. Deski report is working fine but when I refresh the same report in infoview or webi report is getting the below error:A database error occured.The database error text is:(CS) “DBDriver failed to load:C:\Program Files>BusinessObjects>BusinessObjects12.0>win32_x86>dataAccess>connectionServer>dbd_oci.dll file is not foundNeed to install the same Oracle client on the server as well, and configure it in the same way as we did on the PC.
  9. Do we have any formula in webi to not include the list of values for an object.
    This is just like ‘Inlist’?Need to use ‘Not’ before the object name.Here is an example of Not InList used in an IF statement:=NOT([Amount] Where (

    InList(;)))

    = If(Not([Object Name]InList( “text1; “text2; “text3”)) ; “Desired Text” )

    =[Amount] Where (

    Not In List(<value1>;<Value2>))
    =[Amount] Where (

    InList(;))

    =[Amount] – ([Amount]) Where (

    InList(<value1>;<Value2>)))

  10. Querybuilder query to show the list of users that belong to a group.select si_name
    from ci_systemobjects
    where children(“si_name = ‘usergroup-user'”, “si_name = ‘<GROUP NAME>'”)
  11. Order_Id Status
    1 10
    1 11
    1 122 13
    2 14
    2 153 16
    3 17
    3 114 18
    4 19
    4 20I want to show all Order_Ids for Status=11. How to show this?=If(Max([Order Status] In ([Order ID]) Where ([Status]=”11″))=”30″;”Keep”;”Hide”)
  12. Unable to open the report on my machine in webi rich client. No issues on other machines.Error: “The Document cannot be retrieved from the file repository server. (WIS 30951)”Resolution:

    I checked all ports related issues, any firewalls, BO user permissions etc.

    i) Exit the WebI Rich Client tool.

    ii) Check the ‘Windows OS User name’ with which log on to the client machine.

    iii) Provide Windows (OS, not BO Enterprise) ‘modify’ permission to this user account on the client machine operating system installation C drive.

    iv) Launch the WebI Rich Client tool

    v) Logon and Import the reports

  13. The BI Launchpad now has a really useful tabs style view, so that we can have multiple reports open at the same time.
    But this can not be done in CMC.
  14. As of now we can not select multiple objects (folders, universes, etc.), then click “User Security” to apply security to all of the
    selected objects in one action. This thing can not be done in BO as of now.
Advertisements

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.

 

SAP BOBJ BI4.0 - Loading webi screen - BI Lanchpad

I don’t have the choice to update the software to SP4 Patch 9, so I keep tried.

Now it is working by changing the PREFERENCES at BI Launch pad.

Selected the below options:

i)Desktop (Windows only) (installation required) 

ii)Rich Internet Application (download required) 

Installed jre-7u11-windows-i586.

I am not sure which one has worked above the two and now I am happy.

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

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 and Build: 565 –> SAP BI BusObjects 4.0 SP02 Patch 12
version 14.04 and Build 738 –> SAP BI BusObjects 4.0 SP4 no patch
version 14.04 and Build 855 –> SAP BI BusObjects 4.0 SP4 Patch 5

BO XI 3.1 SP5
12.5.0.1190 –> XI 3.1 SP5

BO XI 3.1 SP4
12.4.0.966 –> XI 3.1 SP4
12.4.1.1188 –> XI 3.1 SP4 + FP 4.1

BO XI 3.1 SP3
12.3.0.601 –> XI 3.1 SP3
12.3.1.684 –> XI 3.1 + SP3 + FP3.1
12.3.2.753 –> XI 3.1 + SP3 + FP3.2
12.3.3.812 –> XI 3.1 + SP3 + FP3.3
12.3.4.895 –> XI 3.1 + SP3 + FP3.4
12.3.5.925 –> XI 3.1 + SP3 + FP3.5
12.3.6.1006 –> XI 3.1 + SP3 + FP3.6

BO XI 3.1 SP2
12.2.0.290 –> XI 3.1 + SP2
12.2.1.412 –> XI 3.1 + SP2 + FP2.1
12.2.2.441 or 12.2.2.453 –> XI 3.1 + SP2 + FP2.2
12.2.3.467 –> XI 3.1 + SP2 + FP2.3
12.2.4.507 –> XI 3.1 + SP2 + FP2.4
12.2.5.537 –> XI 3.1 + SP2 + FP2.5
12.2.6.567 –> XI 3.1 + SP2 + FP2.6
12.2.7.598 –> XI 3.1 + SP2 + FP2.7
12.2.8.638 –> XI 3.1 + SP2 + FP2.8
12.2.9.698 –> XI 3.1 + SP2 + FP2.9
12.2.10.810 –> XI 3.1 + SP2 + FP2.10

BO XI 3.1
12.1.0.882 –> XI 3.1
12.1.1.957 –> FP1.1
12.1.2.996 –> FP1.2
12.1.3.1028 –> FP1.3
12.1.4.1068 –> FP1.4
12.1.5.1096 –> FP1.5
12.1.6.1116 –> FP1.6
12.1.7.1144 –> FP1.7
12.1.8.1176 –> FP1.8
12.1.9.1290 –> FP1.9
12.1.10.1390 –> FP1.10
12.1.11.1454 –> FP1.11

BO XI 3.0
12.0.0.683.BOE_Titan_RTM –> XI 3.0
12.0.0.796.BOE_Titan_FP_RTM_REL –> FP 1
12.0.0.840.BOE_Titan_FP_RTM_REL –> FP 2
12.0.3.900 BOE_Titan_FP_RTM_REL –> FP 3

BO XI r2
11.5.0.313 –> RTM
11.5.3.417 –> SP1
11.5.7.608 –> MHF1
11.5.7.682 –> CHF13
11.5.7.723 –> CHF14
11.5.7.770 –> CHF15
11.5.7.811 –> CHF16
11.5.7.852 –> CHF17
11.5.7.1048 –> CHF20
11.5.8.826 –> SP2
11.5.8.826 –> FP2.1
11.5.8.939 –> FP2.2
11.5.8.963 –> FP2.3
11.5.8.998 –> FP2.4
11.5.8.1030 –> FP2.5
11.5.8.1061 –> FP2.6
11.5.8.1111 –> FP2.7
11.5.8.1187 –> FP2.8
11.5.8.1237 –> FP2.9
11.5.9.1076 –> SP3
11.5.9.1101 –> FP3.1
11.5.9.1138 –> FP3.2
11.5.9.1176 –> FP3.3
11.5.9.1202 –> FP3.4
11.5.9.1227 –> FP3.5
11.5.9.1265 –> FP3.6
11.5.9.1330 –> FP3.7
11.5.9.1378 –> FP3.8
11.5.9.1449 –> FP3.9
11.5.10.1263 –> SP4
11.5.10.1298 –> FP4.1
11.5.10.1322 –> FP4.2
11.5.10.1358 –> FP4.3
11.5.10.1404 –> FP4.4
11.5.10.1426 –> FP4.5
11.5.10.1460 –> FP4.6
11.5.10.1491 –> FP4.7
11.5.10.1554 –> FP4.8
11.5.10.1619 –> FP4.9
11.5.10.1681 –> FP4.10
11.5.10.1765 –> FP4.11
11.5.10.1854 –> FP4.12
11.5.11.1470 –> SP5
11.5.11.1545 –> FP 5.1
11.5.11.1578 –> FP 5.2
11.5.11.1610 –> FP 5.3
11.5.11.1639 –> FP 5.4
11.5.11.1673 –> FP 5.5
11.5.11.1732 –> FP 5.6
11.5.11.1797 –> FP 5.7
11.5.11.1856 –> FP 5.8
11.5.12.1838 –> SP6

RTM = Release To Market (first release, without any patches).
MHF = Monthly Hot Fix.
CHF = Critical Hot Fix.
SP = Service Pack.
FP = Fix Pack.

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 you up for the following…

If you select only the obects for YearTable.Year and “Order Amount”, the SQL generated will be automatically for Sum(YearTable.OrdAmountYr).

If you select only the obects for MonthTable.YrMonth and “Order Amount”, the SQL generated will be automatically for Sum(MonthTable.OrdAmountMo).

If you select only the obects for DetailsTable.OrderDate and “Order Amount”, the SQL generated will be automatically for Sum(DetailsTable.OrderAmount).

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 or applied at the same time on a field in a webi report table.

Should give up on either one.

*  I wanted to install FP to client BO, for this which one I should select the option from ‘repair’ or ‘remove’ while installing steps?

* Calculating no of days between 2 days Date1 and Date2?

=DaysBetween(RelativeDate([Date1];Floor(DayNumberOfWeek([Date1])/6)*(8-DayNumberOfWeek([Date1])));RelativeDate([Date2];Floor(DayNumberOfWeek([Date2])/6)*(8-DayNumberOfWeek([Date2]))))-(Floor(DaysBetween(RelativeDate(RelativeDate([Date1];Floor(DayNumberOfWeek([Date1])/6)*(8-DayNumberOfWeek([Date1])));(DayNumberOfWeek(RelativeDate([Date1];Floor(DayNumberOfWeek([Date1])/6)*(8-DayNumberOfWeek([Date1]))))+1)*-1);RelativeDate([Date2];Floor(DayNumberOfWeek([Date2])/6)*(8-DayNumberOfWeek([Date2]))))/7)*2)

* How to convert number of seconds into HH:MM:SS time format?

=FormatNumber(Floor(<number of seconds>/3600) ,”00″) & “:” &
FormatNumber(Floor(Mod(<number of seconds> ,3600)/60) ,”00″) & “:” &
FormatNumber(Mod(Mod(<number of seconds> ,3600) ,60) ,”00″)

* How to round off a date to next month or next Quarter begin date?

i) For example if date is: 30/03/2009 , should get 01/04/2009. 

ii) If I have a date: is 01/02/2009, should get 01/04/2009 

How to achieve this?

=ToDate(
Left(Concatenation(“01/”+ If(MonthNumberOfYear(CurrentDate())<4;”04/” ;If(MonthNumberOfYear(CurrentDate())<7;”07/”;If(MonthNumberOfYear(CurrentDate())<10;”10/”;If(MonthNumberOfYear(CurrentDate())<=12;”01/”))));
If(MonthNumberOfYear(CurrentDate())<>12;
Year(CurrentDate());(Year(CurrentDate())+1))
);7)
+
Right(Concatenation(“01/”+ If(MonthNumberOfYear(CurrentDate())<4;”04/” ;If(MonthNumberOfYear(CurrentDate())<7;”07/”;If(MonthNumberOfYear(CurrentDate())<10;”10/”;If(MonthNumberOfYear(CurrentDate())<=12;”01/”))));
If(MonthNumberOfYear(CurrentDate())<>12;
Year(CurrentDate());(Year(CurrentDate())+1))
);3);
“dd/MM/yyyy”)

* How to create a variable to find duplicate records?

Var_duplicate=Count([MeasureColumn]) In ([Dimension1];[Dimension2];[Dimension3])

and apply the filter if Var_duplicate >1

* How to show last 3 months data in a report?

Create a variable X = DaysBetween(TIMESTAMP; CurrentDate())

We can apply a filter on this like X < 90 to get 3 month data.

Month=Floor(X/30)+1

Filter like Month <= 3