Sap Bo Questions 4a6e1o

SAP BO Interview questions Which is latest version available in market for SAP BO ? SAP BO BI 4.0 SP6 on 30th April 2013 Difference between SAP BO 3.1 and SAP BO 4.0 B0 XI 3.1

BO 4.0

create one connection at a time in the univers

Create multi source universe with new extn .UNX.

migration can be done by Import Wizard or LCM

no import wizard

desktop intelligence

no desktop intelligence

Graphs

More graphs options

Not available

Direct connection between SAP BW BEx query to Webi by BICS connection

Data Federator

Data Federator is replaced by Multi source universe

Column Hiding

Show Hide column direct option in the Webi

What is new features in SAP BO 4.0 Previous Version

New Version

Sap web intelligence

Web intelligence

SAP voyager

Advance Analysis Web addition

SAP Xcelsius

Dashboard Design

SAP Dashboard Builder

BI Workspace (Content Linking function has been change. Its GUI is more graphical.)

SAP Info view

BI Launch Pad (can open multiple reports at the same time like tabs and facet searching)

-

Information Design Tool– multiple databases on one connection and Universe extension chan

-

Upgrade Management Tool (for up-gradation of 3.1 data into 4.0)

-

Monitoring:-To monitor all server performance and KPI based view

Crystal Reports

Crystal Reports:- included in package and GUI has been changed.

What is node ? A node is a group of SAP BusinessObjects Business Intelligence platform servers that run on the same host and are managed by the same Server Intelligence Agent (SIA). All servers on a node run under the same . One machine can contain many nodes, so you can run processes under different s. One SIA manages and monitors all of the servers on a node, ensuring they operate properly. Full form of SAP BO components CMC:- Central Management Console CCM:- Central Configuration Management CMS:- Central Management Service Web Application Server port, default 8080 Server Intelligence Agent (SIA) port, default 6410 Central Management Server (CMS) port, default 6400 What is default url for SAP BO CMC and Infoview ? 3.1 CMC Path:- http://hostname/cmcApp/.jsp Infoview:- http://hostname/InfoViewApp/.jsp 4.0 CMC Path:- http://servername/BOE/CMC/ Launch Pad:- http://servername/BOE/BI What is location of data folder in SAP BO ? C:/Program File/Business Objects/BusinessObjects Enterprise 12.0/ Data folder contain temp data Logging folder contain log files What are new component available in SAP BO 4.0 CMC ? 1. 2. 3. 4. 5. 6. 7.

Attribute Management Visual Difference Auditing Monitoring Cryptography Key Promotion Management Version Management

What is Visual Difference ? Visual Difference enables you to view the differences between two versions of a ed file type(LCM BIAR) or a ed object type(LCM Job) or both. You can use this feature to determine the difference between files or objects to develop and maintain different report types. This feature gives a comparison status between the source and the destination versions. For example, if a previous version of the

report is accurate and the current version is inaccurate, you can compare and analyze the file to evaluate the exact issue. Following are the three types of visual difference from which you can detect the file or an object: • Removed – In a report, if an element is missing in one of the file versions, the type of difference is shown as Removed. For example, the element could be a row, section instance, or even a block. • Modified – In a report, if there is a different value between the source version and the destination version, the type of difference is shown as Modified. For example, the value could be the cell content or the result of a local variable. • Inserted – In a report, if there is an element in the destination version but is not present in the source version, the type of difference is shown as Inserted. What is Auditing in BO 4 ? Auditing allows you to keep a record of significant events on servers and applications, which helps give you a picture of what information is being accessed, how it’s being accessed and changed, and who is performing these operations. This information is recorded in a database called the Auditing Data Store (ADS). Once the data is in the ADS, you can design custom reports to suit your needs. You can look for sample universes and reports on the SAP Developer Network. For the purposes of this chapter, an auditor is a system responsible for recording or storing information on an event, and an auditee is any system responsible for performing an auditable event. There are some circumstances where a single system can perform both functions. What is Monitoring in BO 4 ? Monitoring allows you to capture the runtime and historical metrics of SAP BusinessObjects Business Intelligence platform servers, for reporting and notification. The monitoring application helps system s to identify if an application is functioning normally and if the response times are as expected. Monitoring allows you to: 1. Check the performance of each server 2. Check system availability and response time 3. View the entire BI platform deployment based on Sever Groups, Service Categories and Enterprise nodes in graphical and tabular format. 4. Check health of server Which services should be in running mode at time of upgradation of SP and FP in Business Objects ? 1. CMC 2. Input File Repository 3. Output File Repository. What is default session time out in SAP BO for web tier ? 20 Minute What are tables available In CMS database in BO ? There are 6 tables on the database level to store the metadata.

 









CMS_VersionInfo The table contains the current version of BOE. CMS_InfoObjects6 This is the main table in the repository. Each row in this table stores a single InfoObject. The table contains the following columns: ObjectID, ParentID, TypeID, OwnerID, Version, LastModifyTime, ScheduleStatus, NextRunTime, CRC, Properties, SI_GUID, SI_CUID, SIRUID, SI_INSTANCE_OBJECT, SI_PLUGIN_OBJECT, SI_TABLE, SI_HIDDEN_OBJECT, SI_NAMED, SI_RECURRING, SI_RUNNABLE_OBJECT, SI_PSS_SERVICE_ID, ObjName_TR, SI_KEYWORD, SI_KEYWORD_TR, LOV_KEY. CMS_Aliases6 This table maps the alias(es) to the corresponding ID. A has an alias for each security domain in which they are . For example, a may have both a Win NT alias and an LDAP alias. Regardless of the number of aliases a may have, in the BI Platform each has only one ID. The map is stored in a separate table to enable fast s. CMS_IdNumbers6 The CMS uses this table to generate unique Object IDs and Type IDs. It has only two rows: an Object ID row and a Type ID row. The CMSs in a cluster use this table when generating unique ID numbers. GUIDs, RUIDs and CUID are generated with an algorithm that does not use the database. CMS_Relationships6 Relationship tables are used to store the relations between InfoObjects. Each row in the table stores one edge in the relation. For example, the relation between a Web Intelligence document and a Universe would be stored in a row in the WebI – Universe Relation table. Each relationship table has these columns: Parent Object ID,Child Object ID,Relationship InfoObject ID ( this Default InfoObject “DFO” describes the properties of the link between the two objects.), member, version, ordinal, data. Relationship tables are defined by default objects. CMS_LOCKS6 This is a auxiliary table of CMS_RELATIONS6

How to enable tracing without restarting servers ? By modifying BO_trace.ini file.