INTERVIEW QUESTIONS DATA WAREHOUSING BUSINESS OBJECTS DETAILS

Question: What is the difference between BoXIR2 and BOXIR3?

Answer: 1.XIR3 can use Excel document as a data provider which was not possible in XIR2.

2.We can open XIR2 universes using XIR3 Designer but XIR3 universe cannot be opened using earlier versions of designer.

1.XIR3 can use Excel document as a data provider which was not possible in XIR2.

2.We can open XIR2 universes using XIR3 Designer but XIR3 universe cannot be opened using earlier versions of designer. Source: CoolInterview.com

On the Administration front, all the servers can be maintained at the CMC, there is a new component call "Server Intelligence Agent".
So all the work of CCM is shifted to CMC.
From CCM.. stop, run or restart the Tom Cat and Server Intelligence Agent. Source: CoolInterview.com

• We can create universe from stored procedure in BOXI3 but not in BOXIR2
• Web intelligent report – when we save as excel report that report contains more than 65K rows it’s automatically populated to next sheet.
Source: CoolInterview.com

New in XI R3.0 (Titan):
- Better security (Custom Access Levels, "Trumping" of rights, etc.)
- Being able to prevent access rights from propagating to sub-objects (thereby avoiding the need to break inheritance)
- New GUI for the CMC
- Repository Federation (=replication of the repository to other BOE cluster)
- Repository Diagnostic Tool (to remedy inconsistencies between CMS database entries and files in the FRS)
- SIAs (new grouping/managing of servers, see also "bootstrap" files)
- Cloning Server Services
- Building Server Services templates (for cloning)
- The CMC is now the leading system, not the CCM
- Enhanced failover capabilities (session failover, etc.)

- Improved Import Wizard (better understandable options)
- Rich Client version of WebIntelligence (offline Webi), called WRC
- Tracking feature in WebIntelligence

- New Publishing features (close to BCAP of version 6.x)

- Multi-language support for universes
- Designer: Smart measures (or so called database delegated measures in the universe)
- Designer: Focing predefined conditions on the whole universe or on a universe class
- Optional prompts
- Database delegated search for LOVs (data type CHARACTER)
- Enhanced OLAP universes (see also SAP BW, etc.)
- Better performance against SAP BW OLAP based universes
- Being able to do an update to the structure of OLAP based universes with conflict resolution
- Being able to build universes using stored procedures
etc.

New in XI R3.1:
- LifeCycle Management (LCM) tool for promoting content from Dev --> Test --> Prod

New in XI R3.2:
- Input controls in WebIntelligence
- Increased support for SAP OLAP universes (see also SAP BusinessObjects Integration Solution (Integration Kit) such as MDX formula editor in universe designer, improved OLAP universe update wizard, etc.
- New Universe parameter SMART_AGGREGATE to force the usage of the most detailed fact tables (see also: smart measure/database delegated measure)
Source: CoolInterview.com

Hi,
There is a correction in the above posts. XI R2 allows you to create reports on Excel and Stored Procedure Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

• There should not be any Spelling Mistakes.
• There should not be any Gramatical Errors.
• Answers must not contain any bad words.
• Answers should not be the repeat of same answer, already approved.
• Answer should be complete in itself.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code: *
	Inform me about updated answers to this question