USA : +1 732 325 1626
IND : +91 800 811 4040
Mail ID : info@bigclasses.com

Pages

Online Training

Online Training on Business Objects

Organization Intelligence

Business Intellect has become a very essential activity in the firm arena irrespective of the domain due to the fact that professionals need to evaluate adequately to be able to face the difficulties.

Data seeking, details examining, getting the appropriate details for a given specifications, evaluating the risks and finally assisting the selection procedure are the primary elements of BI.

In a business perspective, core stakeholders need to be well aware of all the above stages and be superior on goals. The person, who is being allocated with the role of Organization Specialist (BA) for the BI effort either from the BI remedy providers' side or the firm itself, needs to take the full responsibility on ensuring that all the above actions are properly being performed, in a way that it would eventually provide the firm the predicted create use of. The control, who will be the customers of the BI remedy, and the firm stakeholders, need to connect with the BA properly and ornately on their goals and help him throughout the procedure.

Data seeking is an initial yet essential step that would have a direct impact on the program where getting details from several sources has to be performed. The details may be on text records such as memorandums, reviews, messages, and it may be on the types such as pictures, pictures, sounds, and they can be on more pc focused sources like directories, partitioned tables, web pages and URL lists. The key to details seeking is to obtain the details in electronic type. Therefore, typically readers, camcorders, data source issues, web queries, pc file access etc, would play considerable tasks. Operating perspective, focus should be placed on the recognition of the appropriate appropriate details sources, the granularity of the details to be produced, possibility of details being produced from determined sources and the verification that only appropriate and accurate details is produced and approved on to the details research level of the BI procedure.
Business focused share owners advised by the BA need to put in lot of thought during the evaluating level as well, which is the second stage. Synthesizing useful information from selections of details should be done in an systematic way using the in-depth business information whilst calculating current styles, developing and reviewing different details, verifying models of understanding, and forecasting missing details or upcoming styles. This procedure of details research is also known as details exploration or information development. Probability concept, mathematical research methods, functional research and artificial intelligence are the tools to be used within this level. It is not predicted that business focused share owners (including the BA) are experts of all the above theoretical concepts and program strategies, but they need to be able to guide the appropriate sources to experience the ultimate goals of BI, which they know best.

Identifying appropriate specifications, conditions and factors of review creation is completely depending on business specifications, which need to be well conveyed by the customers and properly taken by the BA. Ultimately, appropriate choice assistance will be triggered through the BI effort and it is designed to offer alerts on essential events, such as takeovers, market changes, and poor team performance, so that protective actions could be taken. It looks for to help evaluate and create better business choices, to improve revenue or customer care or team comfort. It presents the details that manager's need, as and when they need it.

In a business sense, BI should go several actions forward skipping the simple conventional confirming, which should describe "what has happened?" through guideline analytics. The value addition will be greater if it can produce illustrative analytics, which will describe "why has it happened?" and the value added to the firm will be much greater if predictive analytics could be provided to describe "what will happen?" Therefore, when providing a BI remedy, you should think in these additional value adding lines.

Data warehousing

In the perspective of BI, details warehousing (DW) is also a critical resource to be applied to increase the potency of the BI procedure. BI and DW are two terms that go in line. It has come to a level where a true BI program is worthless without a highly effective DW, to be able to comprehend the reality behind this declaration, it's essential to have an understanding in to what DW really is.

A details factory is one large details store for the firm in issue which has incorporated, time version, non unpredictable collection of details in assistance of management's selection procedure. It will mainly have transactional details which would assist in efficient querying, evaluating and review creation, which will would provide the control the required level of details for the selection.

The reasons to have BI together with DW

At this factor, it should be described why a BI tool is more efficient with a highly effective DW. To question, evaluate and produce deserving reviews, the techniques should have details available. Importantly, transactional details such as revenue details, hr details etc. are available normally in different applications of the business, which would obviously be physically held in different directories. Therefore, details is not at one particular place, hence creating it very difficult to produce brilliant details. The level of reviews predicted these days, are not merely independent for each department, but professionals these days want to evaluate details and relationships across the business so that their BI procedure is efficient. Therefore, having details coming from all the sources to one location by means of a details factory is essential for the success of the BI effort. Operating perspective, this message should be approved and sold to the conduite of businesses so that they comprehend the value of the financial commitment. Once spent, its profits could be obtained over several decades, in convert labels a higher ROI.

Investment costs for a DW in the temporary may look quite great, but it's essential to re-iterate that the profits are much greater and it will span over many decades to come. It also decreases upcoming development cost since with the DW any asked for review or perspective could be easily triggered. However, you should find the right business attract for the project. He or she needs to connect regularly with professionals to ensure that they comprehend the value of what's being built. Organization gives need to be major, take an enterprise-wide perspective and have the power to use their choices.

Process

Implementation of a DW itself overlaps with some stages of the above described BI procedure and it's worth noting that in a procedure perspective, DW falls in to the first few stages of the whole BI effort. Gaining highly valuable details out of DW is the latter part of the BI procedure. This can be done in many ways. DW can be used as the details data source of program hosts that run choice assistance techniques, control Information Systems, Expert techniques etc., through them, brilliant details could be obtained. But one of the latest techniques is to develop pieces out of the DW and allow customers to evaluate details in several measurements, and also offer with highly effective systematic assisting such as routine down details in to granular levels. Cut is a concept that is different to the traditional relational 2-dimensional tabular perspective, and it has several measurements, allowing a manager to evaluate details depending on several aspects, and not just two aspects. On the other hand, it allows the user to select whatever the sizing he wish to choose for evaluating requirements and not be limited by one fixed perspective of details, which is known as as piece & chop in DW language.

BI for a serious business is not just a stage of a computerization procedure, but it is one of the major techniques behind the whole business motorists. Therefore control should sit down and develop up a BI strategy for the firm and identify the details they require in each business direction within the business. Given this, BA needs to evaluate the business details sources to be able to develop up the most beneficial DW which would help the strategized BI procedure.

High level Ideas on Implementation

At the heart of the details warehousing procedure is the extract, transform, and load (ETL) procedure. Execution of this merely is a technical issue but it's a business issue to create sure it is designed in such a way that it eventually helps to satisfy the firm specifications. This procedure is responsible to get in touch to and getting details from one or more transactional techniques (source systems), changing it according to the firm rules defined through the firm goals, and running it into the all essential info model. It is at this factor where details quality should be obtained. Of the many required the details factory, the ETL procedure symbolizes a good portion of all the moving parts of the warehousing procedure.



Contact Us

#516,Annapurna Block,
Aditya Enclave, Ameerpet,
Hyderabad-500016.
IND       : +91-40- 64600330
Mobile  : +91 800  811  4040
USA      : +1  732  325  1626

History

Business objects is a French enterprise software company, specializing in business intelligence (BI). The company claimed more than 46,000 customers worldwide in its final earnings release. Its flagship product is BusinessObjects XI, with components that provide performance management, planning, reporting, query and analysis and enterprise information management.
1990    Business Objects is founded in Paris, France.
1991    France Telecom becomes the first customer after viewing a prototype of Business Objects’ initial product offering.
1994    Business Objects launched BusinessObjects v3.0 and goes public on NASDAQ – the first European company in history to do so.
1995    Business Objects is the first software company to focus on enterprise-scale business intelligence (BI) deployments.
1996    Business Objects enters OLAP market and launches BusinessObjects v4.0.
Bernard Liautaud is named one of Business Week’s “Hottest Entrepreneurs of the Year.”
1997    BusinessObjects Web Intelligence is introduced.
1999    Business Objects is publicly listed in France on the Premier Marche.
2000    Business Objects delivers the industry’s first interactive mobile business intelligence solution.
2001    Business Objects opens offices in San Jose, California.
signs an OEM and reseller agreement to bundle Crystal Reports.
2002    Business Objects acquires Blue Edge Software and Acta Technologies.
Bernard Liautaud named to Business Week’s “Stars of Europe.”
Business 2.0 names Business Objects as one of the “100 Fastest Growing Tech Companies.”
Leading direct retailer Lands’ End deployed one of the first executive dashboards, resulting in a 33% reduction in lost sales over the year.
2003    Business Objects acquires Crystal Decisions and releases Dashboard Manager, BusinessObjects Enterprise 6, as well as BusinessObjects Performance Manager.
2004    Business Objects launches Crystal v10 and BusinessObjects v6.5.
2005    Revenues reaches more than a billion US dollars.
John Schwarz joins Business Objects as chief executive officer.
BusinessObjects XI and Crystal Xcelsius are launched.
Business Objects acquires SRC Software, Medience, and Infommersion.
2006    Business Objects acquires Firstlogic, Inc., Armstrong Laing Limited (ALG), and nSite.
Business Objects releases crystalreports.com and BusinessObjects Data Quality XI.
2007    Business Objects acquires Cartesis.
2008    acquires Business Objects to lead emerging market for business performance optimization.
2002 More birthday cake: Thirty years after its foundation,  is the third-largest independent software provider in the world and a paragon of the German economy. The  brand stands for high-quality business software.
A rising star: ‘s portfolio is not the only thing witnessing constant growth. The company’s workforce also increases to around 29,000 by the end of 2002. Approximately 1,300 employees move into the new star-shaped building that has opened directly adjacent to ‘s headquarters in Walldorf.
New blood at the top: The Executive Board bolsters its ranks with Shai Agassi, who assumes responsibility for new technologies, and Léo Apotheker, who takes over global sales.
2003
End of an era: Hasso Plattner resigns from the Executive Board and is elected chairman of the Supervisory Board. Plattner is the final  co-founder to leave the company’s management team, but remains with  in an advisory role. Upon taking his leave, the nautical enthusiast receives a special gift – a sail signed by all of ‘s employees, which they hope will carry him to further success.
Technology of the future: What began in the “new economy” as my.com and evolved to my technology reaches a new pinnacle in  NetWeaver. This technology enables  to offer fast, open, and flexible business applications that support end-to-end business processes – no matter whether they are based on systems from  or other providers.
Global developments: Labs China marks the ninth opening of a development location outside of Walldorf. This and the other research centers in India, Japan, Israel, France, Bulgaria, Canada, and the United States help  convert IT expertise into business utility for its customers. The company now employs around 30,000 employees, approximately 17,000 of whom work outside of Germany.
2004
Major success: brings the first version of  NetWeaver to market. The response to this new integration and application platform is overwhelming. By the end of the year, well over 1,000 customers acquire the product, with even more on the way. Meanwhile, more than 24,000 total customers are running 84,000  software installations in over 120 countries.
Joining forces: announces its intention to acquire the remaining shares of its consulting subsidiary  SI and to merge the company into its corporate group. This move strengthens ‘s global portfolio of strategic IT consulting and integration services and makes  the go-to provider of many customers – especially those in Germany, Switzerland, and the United States.
A clear vision: plans its future around the concept of enterprise service-oriented architecture (enterprise SOA). According to CEO Henning Kagermann,  will make all of its business applications service-based in the medium term to provide its customers with the most flexibility possible. In doing so,  sets the standard for the rest of the market.
Strong statistics: Under Kagermann’s leadership, quarterly revenue gains and a constantly increasing market share keep  at the head of the pack in the rejuvenated IT market. Business Week names Kagermann one of the 25 best business managers in Europe, praising his customer-oriented corporate philosophy.
2005
Excellence recognized: A study conducted on behalf of the business magazine Capital names  Germany “Best employer of 2005″ among other companies with 5,000 employees or more. “I accept this award with pride and gratitude on behalf of the more than 32,000 people who work at . For us as a company, it will mainly serve as motivation for the future. After all, ‘s success will continue to depend on the skills, drive, and dedication of our current and future employees,” declares  Executive Board member Claus Heinrich upon receiving the award from Wolfgang Clement, Germany’s Federal Minister of Economics and Technology.
Something cooking in the east: In February,  officially opens its new research and development facility in the Hungarian capital of Budapest.  Labs Hungary and its some 50 developers join ‘s global network of research locations, which incorporates the brightest minds in IT all over the world.
Organic growth: The year 2005 is marked by a series of acquisitions. While its competitors initiate their own major takeovers,  focuses on organic growth by acquiring smaller companies whose specific solutions augment its portfolio in sensible ways. These companies include the two retail providers Triversity and Khimetrics.
Impressive numbers: The company’s software license revenues increase by 18%, and it records particularly high rates of growth in the Americas. The more than 35,800  employees around the world generate total revenues of €8.5 billion.
2006
International recognition: once again garners numerous employer accolades. Along with  Germany,  Austria,  Chile,  Andina y del Caribe,  Mexico, and  Region Sur win the “Great Place to Work” award from the institute of the same name. In addition,  Labs India receives the distinction “Recruiting and Staffing Best in Class” from the Indian Institute of Management Studies & Research for its innovative methods in workforce planning and management.
Harmonious partnership: and Microsoft introduce Duet, the first product of the two companies’ joint efforts in development, support, sales, and marketing. This software enables users to quickly and easily integrate Microsoft Office and -supported business processes. The partners sell 200,000 licenses in just the first three months.
Onward to further success: At the first PHIRE event of the year in Orlando, Florida,  announces the general release of its flagship application,  ERP. ” ERP constitutes the foundation of ‘s industry solutions and a springboard to enterprise SOA,” says  Executive Board member Léo Apotheker.
Good news from the midmarket: noticeably expands its share of the midmarket with the solutions  All-in-One and  Business One. In June, the company announces that the latter solution has gained its 10,000th customer.  also has generates around 30% of its €3.1 billion in total software licensing revenues from companies with fewer than 2,500 employees.
2007
Seizing new opportunity: When an acquisition makes sense in enhancing its product portfolio,  does not shy away from the investment required. The company buys Pilot Software – a private California provider of strategy management software – as well as Yusa, OutlookSoft, Wicom, and MaXware.  also announces its intention to purchase Business Objects, a company specializing in business intelligence applications.
Restructure of the Executive Board: Leo Apotheker is named ‘s deputy CEO at the end of March.  also forms an Executive Council, which comprises corporate officers who share responsibilities for market and product strategies and report to the Executive Board. This restructuring follows Shai Agassi’s departure from the Executive Board.
Another year, another employer accolade: In its 35th year,  takes home the title of “Germany’s Best Employer” for the third time in the annual “Great Place to Work” awards. The company also receives a special prize for its comprehensive health management program.  Labs India also ranks eighth among other employers in India.
Head start in the midmarket: As part of a special event in New York City,  reveals  Business By Design, a product designed specifically for small businesses and midsize companies.  CEO Henning Kagermann states that this new offering “represents ‘s ambitious attempt to create an all-new solution for an untapped market.”
2008
In the bag: successfully completes its acquisition of Business Objects. Purchasing the French provider of business intelligence solutions expands ‘s software portfolio and makes it the market leader in business software, enterprise performance management, and business intelligence.
The choice of skilled employees: For the fourth time,  is named “Germany’s Best Employer” among companies with at least 5,000 employees. The company also receives numerous awards in other countries, including China, Bulgaria, Denmark, India, Japan, and Mexico.
A global focus: The  Supervisory Board names Léo Apotheker co-CEO alongside Henning Kagermann. Two longstanding members, Peter Zencke and Claus Heinrich, resign from the Executive Board. The board then welcomes Ernie Gunst, Bill McDermott, and Jim Hagemann Snabe, whose international backgrounds will enrich ‘s executive management.
Sustainable business: proves its commitment to sustainable business practices, releasing its first Sustainability Report. As the leader in its market,  is in a unique position to provide information technology that helps companies and organizations of all sizes improve their track records and achieve long-term sustainability.
2009
Difficult times: With the effects of the global financial crisis having reached the real economy in 2008, the business world faces its own plight. Susceptible to the situation at hand,  initiates personnel cutbacks and other cost-saving measures. As of Q3 2009,  still employs some 47,800 people. Meanwhile, the company supports its customers with special programs designed to help them emerge from the crisis with the strength to succeed. Thanks to these programs and its cutbacks,  is able to improve its operating margin despite the difficult circumstances.
Another business milestone: At a launch event at its offices in New York City,  unveils its  Business Suite 7 software, which is designed to help businesses optimize their performance and reduce IT costs. A condensed ramp-up phase enables the first customers to go live with the software in March. In early May, the next generation of the suite is released to the rest of the world.
Passing the torch:  After 27 years at the company – including 18 years on the Executive Board – Henning Kagermann bids farewell to .  Léo Apotheker becomes the company’s sole CEO. In his inaugural address to ‘s employees in June, he stakes out a clear new path for the company, including his plans for ‘s future, its purpose, and the associated values.
In it for the long haul: demonstrates how important it considers social involvement by supporting PlaNet Finance, an international non-profit organization that aids microfinance institutions (MFIs).  and PlaNet Finance aim to optimize the microfinance sector with a combination of financing, new technologies, and expanded value chains. In advance of the 15th United Nations Climate Change Conference in Copenhagen (COP15),  also offers its assistance to the U.N.’s Hopenhagen initiative. Last but not least,  employees continue to volunteer their time in support of social projects all over the world.
2010
Dynamic duo: In February, the Supervisory Board names Bill McDermott and Jim Hagemann Snabe co-CEOs of the company. Chief technology officer Vishal Sikka also joins the Executive Board. Angelika Dammann follows Sikka in July, becoming the first woman to serve on the Executive Board as she assumes responsibility for global human resources and labor relations.
Business Objects pioneered the business intelligence (BI) industry with the invention of the semantic layer, which shields BI users from the complexity of databases.
Business Objects is once again ushering in a new era of BI by delivering a breakthrough innovation that allows anyone to unthinkingly ask business questions, without the need to build a query or know the underlying systems or data. Intelligent Question is the industry’s first structured questioning environment and is designed to work the way people think. With Intelligent Question. Business Objects is the first vendor to solve this problem by delivering breakthrough ease of use. Just like the introduction of the easy-to-use Apple iPod has led to an explosion in demand for MP3 players, Intelligent Question has the potential to introduce millions of people to the benefits of business intelligence. “The majority of people consuming reports are not technical enough, laymen to create an ad hoc query,” said Philip Russom, senior manager of research and services at The Data Warehousing Institute (TDWI). “This is a problem when end-users need to discover information quickly and standard reports do not contain the answer. These people need an information discovery mechanism that’s as fast, easy, and spontaneous as a search engine, while applying structure to the answer the way parameterized reports do. BusinessObjects Intelligent Question addresses this problem by enabling people to ask an English-language question. Under the hood, Intelligent Question converts the question to an ad hoc or parameterized query, and then returns information in an easy-to-digest format. With this kind of technology, BI users can find information in their reporting systems based on their immediate needs, in a quick, self-service fashion.” When critical business questions arise, people want fast, precise answers. Unfortunately, people often do not know how to best structure their questions to ensure they receive the right information. Intelligent Question’s structured questioning environment allows people to select from a series of options to create anything from simple to very complex business questions. For example, an executive at a retail organization could ask: What are my top 15 customers, based on average weekly spend for my stores over the past 12 months? Or, a supplier for a computer hardware company could easily craft a question via an extranet to ask: Which of my parts have experienced a 10 percent increase in demand this month over last month? With Intelligent Question, as people select from the preset options, the remaining choices are automatically filtered to guarantee that the user can only create an “intelligent question.” A correct, relevant, and trusted answer is provided every time, with just one click.  BusinessObjects Intelligent Question is the first solution that will finally break down the barrier to broader BI adoption, and truly meet the needs of those users who have not experienced the benefits of BI because they were intimidated by the complexity.

Jobs

Famous Places for Business Objects Jobs:
Refer also:

FAQs

FAQ) on  Business Objects:
1. What changes are upcoming for the  BusinessObjects certification program?
Effective April 30, 2010, there will be new  BusinessObjects certification exams available after realignment with the  certification program.  All existing  BusinessObjects exams will be retired at the end of April and will be replaced by the following three exams:
C_BOCR_08 –  Certified Application Associate Crystal Reports 2008
C_BOE_30 –  Certified Application Associate  BusinessObjects Enterprise XI 3.x
C_BOWI_30 –  Certified Application Associate BusinessObjects Web Intelligence XI 3.x
2. Do current certificates keep their value?
Absolutely; individuals holding a current valid Business Objects certification will not need to recertify.
3. If a test taker has already passed 3 out of 4 papers for BusinessObjects Certified Professional – Business Objects Enterprise and is only left with the XI 3-1 upgrade exam (SABE 501) what should he/she do?
To avoid taking the full certification exam after the retirement of the XI 3-1 upgrade exam the final exam should be taken prior to its retirement at the end of April.
4. What has changed in the new exams?
There are some minor content updates and the scoring model has been changed to dichotomous scoring. The dichotomous scoring model scores multiple response questions as either correct or incorrect and does not give partial grades for responses. This better reflects the need for  customers and partners to know whether a certified individual can perform a task to the complete satisfaction of all concerned. Leaving a question blank is equivalent to a false response. In addition there is now only one exam required to gain the full certification.
5. Will the current certification holders automatically be considered at  Associate level?
Yes, those holding the existing certification BusinessObjects certification are entitled to use the  Associate certification logo and title. The former BusinessObjects Certification branding and logo will no longer be used by  or provided to test takers.
6. For those who already possess the BOCP-CR XI, there is currently a delta BOCP-CR 2008 update exam to update to CR2008. Will a CR delta exam exist after this realignment?
No, after the realignment there will no longer be a delta exam to update to CR2008. This will be retired in April and not replaced.
7. Will the exam duration change?
The exam duration will be aligned with the rest of the  Global Certification program. There will be 80 questions in 3 hours.
8. Why is the series of exams for each BusinessObjects product line being compressed into single exams?
This is a step to align the BusinessObjects exam format with the rest of the  Global Certification program.
9. How many times can the test taker take the certification exam?
He/she can sit for an  certification exam a maximum of three times. If he/she is unsuccessful in passing your certification exam after two attempts, and has not previously taken  training classes, we highly recommend that they complete the training. The fee for certification retakes is the same as the initial exam. No candidate may sit for the same examination for the same release more than three times. A candidate who has failed an examination three times for a release may not attempt that examination again until the next release. There are no rules on waiting periods prior to a retake.
10. A test taker just missed reaching a passing grade and would like  to review my exam for possible rescoring. What is the appeals process?
Unless there were technical system difficulties experienced while taking the exam, exams will not generally be reviewed for rescore. If however a test taker feels that there are grounds for appeal it is necessary to submit that appeal to the local  Education team as soon as possible – but at the latest up to 3 months – after the testing event.
11. Where can  BusinessObjects tests be taken?
From April 30, 2010  BusinessObjects certification exams will no longer be available via Pearson VUE test centers in Germany, Austria, Switzerland, the Netherlands, Belgium and Luxembourg. However the exams will continue to be available via Pearson VUE test centers in the rest of the world. From April onwards the registration for an  BusinessObjects exam at a Pearson VUE Test Center will no longer be possible athttp://www.vue.com/busobjects. All future registrations must be made via http://www.vue.com/. In addition to this, the  BusinessObjects exams will also be available in  Education Centers around the world from April 2010 onwards. Registration for this can be arranged viahttp://www..com/certification/ or by contacting your local  Education representative.
12. Is there any difference in the certification exam at an  Education center or through ’s delivery partner, Pearson VUE?
No. Certification exams are the same no matter where the test is taken.
13. Does the test taker need to enter a  user ID when registering for a certification exam and does he/she need to be affiliated with an  customer or partner in order to take an exam?
The test taker does not need to be affiliated with an  customer or partner in order to take an exam, but does have to apply for a so-called S-User ID (or in the case of internal employees an I, D or C-user ID) from  prior to registering. Instructions on how to apply for that ID and register for the exam can be found at http://www.vue.com/.
14. How does a test taker obtain the actual certificate?
On successfully passing the exam, the certificate will be sent to the test taker within 4-6 weeks.
15. Are professional and master exams planned for  BusinessObjects certifications?
There are not currently plans for professional and master exams.
16. Can  BusinessObjects vouchers be ordered for taking tests at VUE?
Yes. Vouchers can be ordered online here http://www.vue.com/vouchers/pricelist/
17. Will the pricing change?
The pricing will be aligned with the rest of the  Global Certification program to reflect the increased exam duration and the single exam per certification scenario. Pricing will not differ between an exam taken at a VUE test center or an  Education Center.
18. How can a test taker get information about recommended training offerings to prepare for the tests?
The recommended training alternatives are listed in the test section on http://www..com/services/education/certification
19. Are Academies or eAcademies planned as part of the  BusinessObjects curriculum?
Academies are planned for launch in 2011.
20. Explain the concepts and capabilities of Business Object.
A business object can be used to represent entities of the business that are supported in the design. A business object can accommodate data and the behavior of the business associated with the entity…………………
21. What is broad cast agent?
A broadcast agent allows automation of emails to be distributed. It allows reports to be sent to different business objects. It also users to choose the report format and send via SMS, fax, pagers etc. broadcast………….
22. Explain the functional differences between BO and COGNOs.
Business objects in business intelligence are entities of the business. COGNOS makes BI and performance planning software……………
23. What is a universe? Explain the types of universes in business objects.
A universe connects the client to the data warehouse. It is a file defining relationships amongst the tables in the warehouse, classes and objects, database connection details……………
24. What is security domain in Business Objects?
Security domain in business objects is a domain containing all security information like login credentials etc. It checks for users and their privileges………………
25. What is batch processing in Business Objects?
Batch processing can be used to schedule reports. Objects can be also be used for batch processing. Batch processing can be used to also select the objects to be processed……………..
26. What are the functional & architectural differences between business objects and Web Intelligence Reports?
Functional differences – Business objects, for building or accessing reports, needs to be installed on every pc. On the other hand, Web intelligence reports needs a browser and a URL of the server from where Business……………….
27. What is slicing and dicing in business objects?
Slicing and dicing of business objects is used for a detailed analysis of the data. It allows changing the position of data by interchanging rows and columns………….
28. What is the security level used in BO?
Security level used in BO:- Row Level, Column Level……………
29. What is Object qualification?
Object qualification is an attribute of an object that helps to determine how it can be used in multidimensional analysis………….
30. What is BOMain.Key?
A BOMain.key file contains all relevant information about the repository. It contains the address of the repository security domain………………
31. OLAP database objects
The following are the OLAP database objects:
Cubes: Data in cubes are persisted in a summarized version that helps to analyze data quickly. The data is persisted, through which reporting can be done easily………………
32. Cubes
A data cube stores data in a summarized version which helps in a faster analysis of data. The data is stored in such a way that it allows reporting easily…………….
33. Data Sources
Data source is where the data comes from in data warehousing. The data collected from various sources and is cleaned…………..
34. Fact Tables
Data in a warehouse comes from the transactions. Fact table in a data warehouse consists of facts and/or measures. The nature of data in a fact table is usually numerical. e.g. If I want to know the number…………..
35. Database roles
Database level roles are used to manage the security of the database. The role can be either fixed or flexible……………
36. Explain the concepts and capabilities of OLAP.
Online analytical processing performs analysis of business data and provides the ability to perform complex calculations on usually low volumes of data. OLAP helps the user gain an insight on the data…………..
37. Explain the functionality of OLAP.
Multidimensional analysis:- OLAP helps the user gain an insight on the data coming from different sources. OLAP helps faster execution of complex analytical and ad-hoc queries……………
38. What are MOLAP and ROLAP?
Multidimensional Online Analytical Processing and Relational Online Analytical Processing are tools used in analysis of data which is multidimensional………………
39. Explain the role of bitmap indexes to solve aggregation problems.
Bitmap indexes are useful in connecting smaller databases to larger databases. Bit map indexes can be very useful in performing repetitive indexes…………..
40. Explain the encoding technique used in bitmaps indexes.
For each distinct value, one bitmap is used. The number of bitmaps can be reduced using log(C) bitmaps with to represent the values in each bin…………….
41. What is Binning?
Binning can be used to hold multiple values in one bin. Bitmaps are then used to represent the values in………….
42. What is candidate check?
Binning process when creates the binned indexes, answers only some queries. The base data is not checked. The process of checking the base data is called as a candidate check. Candidate check at times………….
43. What is Hybrid OLAP?
In a Hybrid OLAP, the database gets divided into relational and specialized storage. Specialized data storage is for data with fewer details while relational storage can be used for large amount of data…………..
44. Explain the shared features of OLAP.
OLAP product by default is read only. If multiple access rights are required, admin needs to make necessary changes………………
45. Compare Data Warehouse database and OLTP database.
Data Warehouse is used for business measures cannot be used to cater real time business needs of the organization and is optimized for lot of data, unpredictable queries. On the other hand, OLTP database is for……………..
46. What is the difference between ETL tool and OLAP tool?
ETL is the process of Extracting, loading and transforming data into meaningful form. This data can be used by the OLAP tool for to visualize data in different forms. ETL tools also perform some cleaning of data………………
47. What is the difference between OLAP and DSS?
Data driven Decision support system is used to access and manipulate data. Data Driven DSS in conjunction with On line Analytical Processing
48. Explain the concepts and capabilities of Business Object.
A business object can be used to represent entities of the business that are supported in the design. A business object can accommodate data and the behavior of the business associated with the entity…………………
49. What is broad cast agent?
A broadcast agent allows automation of emails to be distributed. It allows reports to be sent to different business objects. It also users to choose the report format and send via SMS, fax, pagers etc. broadcast………….
50. Explain the functional differences between BO and COGNOs.
Business objects in business intelligence are entities of the business. COGNOS makes BI and performance planning software……………
51. What is a universe? Explain the types of universes in business objects.
A universe connects the client to the data warehouse. It is a file defining relationships amongst the tables in the warehouse, classes and objects, database connection details……………
52. What is security domain in Business Objects?
Security domain in business objects is a domain containing all security information like login credentials etc. It checks for users and their privileges………………
53. What is batch processing in Business Objects?
Batch processing can be used to schedule reports. Objects can be also be used for batch processing. Batch processing can be used to also select the objects to be processed……………..
54. What are the functional & architectural differences between business objects and Web Intelligence Reports?
Functional differences – Business objects, for building or accessing reports, needs to be installed on every pc. On the other hand, Web intelligence reports needs a browser and a URL of the server from where Business……………….
55. What is slicing and dicing in business objects?
Slicing and dicing of business objects is used for a detailed analysis of the data. It allows changing the position of data by interchanging rows and columns………….
56. What is the security level used in BO?
Security level used in BO:- Row Level, Column Level……………
57. What is Object qualification?
Object qualification is an attribute of an object that helps to determine how it can be used in multidimensional analysis………….
58. What is BOMain.Key?
A BOMain.key file contains all relevant information about the repository. It contains the address of the repository security domain………………
59. OLAP database objects
The following are the OLAP database objects:
Cubes: Data in cubes are persisted in a summarized version that helps to analyze data quickly. The data is persisted, through which reporting can be done easily………………
60. Cubes
A data cube stores data in a summarized version which helps in a faster analysis of data. The data is stored in such a way that it allows reporting easily…………….
61. Data Sources
Data source is where the data comes from in data warehousing. The data collected from various sources and is cleaned…………..
62. Fact Tables
Data in a warehouse comes from the transactions. Fact table in a data warehouse consists of facts and/or measures. The nature of data in a fact table is usually numerical. e.g. If I want to know the number…………..
63. Database roles
Database level roles are used to manage the security of the database. The role can be either fixed or flexible……………
64. Explain the concepts and capabilities of OLAP.
Online analytical processing performs analysis of business data and provides the ability to perform complex calculations on usually low volumes of data. OLAP helps the user gain an insight on the data…………..
65. Explain the functionality of OLAP.
Multidimensional analysis:- OLAP helps the user gain an insight on the data coming from different sources. OLAP helps faster execution of complex analytical and ad-hoc queries……………
66. What are MOLAP and ROLAP?
Multidimensional Online Analytical Processing and Relational Online Analytical Processing are tools used in analysis of data which is multidimensional………………
67. Explain the role of bitmap indexes to solve aggregation problems.
Bitmap indexes are useful in connecting smaller databases to larger databases. Bit map indexes can be very useful in performing repetitive indexes…………..
68. Explain the encoding technique used in bitmaps indexes.
For each distinct value, one bitmap is used. The number of bitmaps can be reduced using log(C) bitmaps with to represent the values in each bin…………….
69. What is Binning?
Binning can be used to hold multiple values in one bin. Bitmaps are then used to represent the values in………….
70. What is candidate check?
Binning process when creates the binned indexes, answers only some queries. The base data is not checked. The process of checking the base data is called as a candidate check. Candidate check at times………….
71. What is Hybrid OLAP?
In a Hybrid OLAP, the database gets divided into relational and specialized storage. Specialized data storage is for data with fewer details while relational storage can be used for large amount of data…………..
72. Explain the shared features of OLAP.
OLAP product by default is read only. If multiple access rights are required, admin needs to make necessary changes………………
73. Compare Data Warehouse database and OLTP database.
Data Warehouse is used for business measures cannot be used to cater real time business needs of the organization and is optimized for lot of data, unpredictable queries. On the other hand, OLTP database is for……………..
74. What is the difference between ETL tool and OLAP tool?
ETL is the process of Extracting, loading and transforming data into meaningful form. This data can be used by the OLAP tool for to visualize data in different forms. ETL tools also perform some cleaning of data………………
75. What is the difference between OLAP and DSS?
Data driven Decision support system is used to access and manipulate data. Data Driven DSS in conjunction with On line Analytical Processing

Interview Questions

Business Objects Interview Questions
1. What is ‘business objects’?
BUSINESSOBJECTS is an integrated query, reporting and analysis solution for business professionals that allow them to access the data in their corporate databases directly from their desktop and present and analyze this information in a BUSINESSOBJECTS document.
It is an OLAP tool that high-level management can use as a part of a Decision Support Systems (DSS).
BUSINESSOBJECTS makes it easy to access the data, because you work with it in business terms that are familiar to you, not technical database terms like SQL.
2. What are the various Business Objects products?
User Module, Designer, Supervisor, Auditor, Set Analyzer, Info View (Web Intelligence), Business Objects Software Development Kit (SDK), Broadcast Agent etc.
3. What are the advantages of Business Objects over other DSS?
User Friendly.
Familiar Business Terms.
Graphical Interface
Drag and Drop.
Powerful reports in less time.
Enterprise wide Deployment of documents using WebI
Customized dashboards using Application foundation and Business Objects SDK.
4. How many modes are there in BO & Designer
There are 2 types: Enterprise Mode, Workgroup
5. What are Enterprise and Workgroup modes?
Designer lets you save universes in either enterprise or workgroup mode. Enterprise mode means that you are working in an environment with a repository. Workgroup mode means that you are working without a repository. The mode in which you save your universe determines whether other designers are able to access them. By default, a universe is saved in the mode in which you are already working. For example, if you launched a session in enterprise mode, any universe you save is automatically in that mode.
6. How do you save a Business Objects document which can be accessed by all users in workgroup mode?
If we want to make a universe accessible to another designer working without a repository, then click the “Save For All Users” check box in the Save as universe dialog box.
7. What is online and offline mode?
If you want a universe to be accessible in offline mode, you must firstly ensure that the
universe has been opened at least once in online mode, and that it has been saved with the Save for All Users check box selected in the Save Universe As box. To make Offline mode available:
Mode Description
Online Default mode of operation for Designer when you are working in an
environment with a repository.
Offline Mode of operation for Designer when you are not connected to a repository.
• Only available if you have previously connected in online mode.
• In offline mode you can open universes that are stored on your local computer only if those universes have been opened previously in online mode.
• You can access databases where the connection and security information are stored on your local machine (personnel and shared connections.)
• You can use offline mode when you do not have access to the repository, for example when working with a laptop off site, or when the network is not available.
8. What is a universe?
Universe provides a semantic layer between you and the database. It consists of classes and objects named in business terms. It is basically a mapping of table and the columns in the database to classes and objects respectively in the query panel.
Alternatively, It is logical mapping of data in business terms.
In the BusinessObjects User module, universes enable end users to build queries from which they can generate and perform analysis. Universes isolate end users from the complexities of the database structure as well as the intricacies of SQL syntax.
9. Can a Universe connect to multiple databases?
NO
10. How do you define universe parameters?
The first step in creating a universe is to specify its parameters. These parameters include the definition of a universe, which is comprised of: the universe name, a description of the universe, a connection to an RDBMS. You enter universe parameters from the Universe Parameters dialog box. This dialog box also lets you set up database options, external strategies, graphic options, and print settings.
11. What is a database connection?
A connection is a set of parameters that provides access to an RDBMS. These parameters include system information such as the data account, user identification, and the path to the database. Designer provides three types of connections: secured, shared, and personal.
12. What are the types of connections we use when connecting to the database?
There are three types of connections namely: – Secured, Shared and Personal.
A secured connection is used to centralize and control access to sensitive or critical data. It is the safest type of connection for protecting access to data.
A shared connection is used to access common resources such as universes or documents. Several users can thus use it.
A personal connection is specific to one user and can be used only from the computer on which it was created.
13. What are different types of joins available in Universe design? Explain each
Equi or Inner or Natural or Simple join: is based on the equality between the values in the column of one table and the values in the column of another. Because the same column is present in both tables, the join synchronizes the two tables.
Self-Join: join a table to itself i.e create a self-join to find rows  in a table that have values in common with other rows in the same table.
Theta or Non-Equi join: links tables based on a relationship other than equality between two columns. A join is a relational operation that causes two or more tables with a common domain to be combined into a single table. The purpose of joins is to restrict the result set of a query run against multiple tables.
Outer join: links two tables, one of which has rows that do not match those in the common column of the other table.
Left Outer Join: All records from first table with matching rows from second.
Right Outer Join: All records from second-named table with matching rows from left.
Full outer join: All rows in all joined tables are included, whether they are matched or not.
Shortcut join: can be used in schemas containing redundant join paths leading to the same result, regardless of direction. Improves SQL performance.
14. How do you design a universe?
The design method consists of two major phases.
During the first phase, you create the underlying database structure of your universe. This structure includes the tables and columns of a database and the joins by which they are linked. You may need to resolve loops which occur in the joins using aliases or contexts. You can conclude this phase by testing the integrity of the overall structure.
During the second phase, you can proceed to enhance the components of your universe. You can also prepare certain objects for multidimensional analysis. As with the first phase, you should test the integrity of your universe structure. Finally, you can distribute your universes to users by exporting them to the repository or via your file system.
15. What are the components of the Designer interface?
In Designer, you create a universe using three areas: the Universe pane, the Structure pane, the Table Browser.  The Universe pane displays the components of the universe from the point of view of BusinessObjects; that is the classes, objects, and conditions. The Structure pane reflects the underlying database structure of the universe including the tables, columns, and joins. The Table Browser is the component that lets you create the classes and objects of the universe from the tables and columns of a database.
16. What are classes/objects?
An object maps to data or a derivation of data in the database. For the purposes of multidimensional analysis, an object can be qualified as one of three types: a dimension, detail, or measure.
A class is a collection of objects based on business categories.
A universe is a set of classes and objects intended for a specific application or group of users.
17. What are classes?
A class is a logical grouping of objects within a universe. In general, the name of a class reflects a business concept that conveys the category or type of objects. For example, in a universe pertaining to human resources, one class might be Employees. A class can be further divided into subclasses. In the human resources universe, a subclass of the Employees class could be Personal Information. As designer, you are free to define hierarchies of classes and subclasses in a model that best reflects the business concepts of your organization.
18. What are objects?
An object is the most refined component in a universe. It maps to data or a derivation of data in the database. Using objects, end users can build queries to generate reports. The name of an object suggests a concept drawn from the terminology of a business or discipline. For a human resources manager, objects might be Employee Name, Address, Salary, or Bonus, while for a financial analyst, objects might be Profit Margin, Return on Investment, etc. For the purposes of multidimensional analysis, objects are qualified as one of three types: dimension, detail, or measure.
19. What are Dimension-Measure-Detail Objects?
When creating universes, universe designers define and qualify objects. The qualification of an object reveals how it can be used in analysis in reports. An object can be qualified as a dimension, a detail, or a measure.
A dimension object is the object being tracked; in other words, it can be considered the focus of the analysis. A dimension can be an object such as Service, Price, or Customer.
Dimension objects retrieve the data that will provide the basis for analysis in a report. Dimension objects typically retrieve character-type data (customer names, resort names, etc.), or dates (years, quarters, reservation dates, etc.)
A detail object provides descriptive data about a dimension object (or attribute of a dimension). It is always associated with a specific dimension object. However, a detail object cannot be used in drill down analysis. E.g. Address & phone number can be attributes about the customer dimension.
A measure object is derived from one of the following aggregate functions:
Count, Sum, Minimum, Maximum or average or is a numeric data item on which you can apply, at least locally, one of those functions. This type of object provides statistical information. Examples of measure objects include the following:
Revenue, unit price etc
20. What us hierarchy
Groups of related dimension objects are referred to as dimension hierarchies. An example of a dimension hierarchy is Geography, which can consist of City, Region, and Country.(Hierarchy is an ordered series of related dimensions, which can be used, in multidimensional analysis) Good examples of hierarchy are geography and time
21. How to create hierarchies in BO?
A hierarchy, which the designer sets up when creating the universe, consists of dimension objects ranked from “less detailed” to “more detailed”. The objects that belong to hierarchies are the ones you can use to define scope of analysis.
22. Can a Universe have more than 1 fact Table?
Yes. Typically a universe can have more than 1 fact table and numerous aggregated tables.
23. What are Contexts?
A context is a rule that determines which of two paths can be chosen when more than one path is possible in the database from one table to another. It helps in resolving the loops created by various joins in the universe tables.
With certain database structures, you may need to use contexts rather than aliases to resolve loops. A situation where this commonly occurs is a transactional database with multiple fact tables (“multiple stars”) that share lookup tables.
24. What are aggregated tables and how would you use it in BO Universe
Aggregate table
Aggregate tables are table which contains summarized data at different level depending on the need of reports. Imagine a fact table which contains granular data up to minute’s transaction. Now if you are developing a reports which has hour, day, week, month, quarter, year level summaries. Queries to get these summary values will scan millions of records which would in turn result in poor performance of reports. One can address this issue by creating aggregate summary table.
Possible problems of using Aggregate table
Aggregate table are good to achieve performance for high level summery queries. However if there are multiple aggregate tables which contains summary values then using aggregate table might be an issue.
Consider following example
e.g. you have two aggregate table
Table 1
AggregateID    Year    Quarter     Month    Sales Revenue
Table 2
AggregateID    Year    Quarter    Month    ServiceType    Sales Revenue
Now if you have a requirement wherein one of your report is displays year wise sales revenue whereas other report is displays Year wise ServiceType “sales revenue”. How would you tell report to use table1 for “year wise” “sales revenue” and use table 2 for another report.
Using Aggregate Table in Business Objects
Business Objects provides a wonderful function to use aggregated tables.
Aggregate_aware(). This function determines which aggregate table to use based on the attributes used in the query.
Syntax:
Aggregate_aware(<expression1>,
<expression2>,
—-
—-)
Expression = field or valid SQL expression or calculation
e.g. so formula for sales revenue might be.
Aggregate_aware (table1.salesrevenue,
table2.salesrevenue,
sum(sometable.column)
)
Notice the arrangement of column used in function. It is highest summarized to least summarized.
Now if while creating report if you use only year attribute and sales revenue. Aggregate_aware will use table1 to get the sales revenue, if used service type in report It will use table2, in all other cases it will use sum(sometable.column) which could be a fact table.
Rules to use aggregate_aware
1.If the object is at the same level of aggregation or higher, it is OMPATIBLE with the summary table.
e.g. In above example none of the table contains aggregated value for “Article” so article object will be incompatible.
You can not use aggregate_aware with “Article object”
2.If the object is at a lower level of aggregation, it is INCOMPATIBLE.
3.If the object has nothing to do with the summary table, it is INCOMPATIBLE.
25. What is Incompatibility?
The set of incompatible objects you specify determines which aggregate tables are disregarded during the generation of SQL. With respect to an aggregate table, an object is either compatible or incompatible. The rules for compatibility are as follows:
When an object is at the same or higher level of aggregation as the table, it is compatible with the table.
When an object is at a lower level of aggregation than the table (or if it is not at all related to the table), it is incompatible with the table.
26. What is the typical strategy employed in developing/maintaining/distributing Universes?
Phase 1: Break down the informational system into functional areas.
Phase 2: Analyze the information needs of users.
Phase 3: Design a conceptual schema
Design the specification of the user.
Phase 4: Create a Universe with designer.
Test the Universe with the Business Objects module.
Distribute the Universe.
Repeat the other steps for other Universes.
Phase 5:  Update and maintain the Universe.
Notify end users of changes.
27. I have Customer dimension table and a fact table with cust_to_ship_key and cust_to_bill_key. How do I get the corresponding customer names?
Create an Alias table for Customer dimension table. Join the cust_to_ship_key with a customer key of Actual customer table and join the cust_to_bill_key with customer key of the Alias.
28. What are strategies?
A strategy is a script that automatically extracts structural information from a database or flat file.
29. What are the different types of Strategies?
In Designer we can specify two types of strategies:
1)    Built-in strategies and
2)    External strategies
Built-in Strategies: Designer provides a number of default strategies which we can use. These are strategies for extracting joins, detecting cardinalities, and creating default classes and objects. Options for indicating default strategies are located in the Database tab of the Options dialog box.
External Strategies: We can also create our own strategies. Such strategies are referred to as external strategies. With an external strategy, we can specify the exact way that objects and joins are to be extracted from the database structure. The strategy we use, for example, can be a script generated from a CASE Access tool. An external strategy is specific to one RDBMS.
30. How do you specify external strategies?
With an external strategy, you can specify the exact way that objects and joins are to be extracted from the database structure. All external strategies are contained within the same text file. The name of this text file is indicated in the .prm file specific to your RDBMS. In the .prm file, the strategy file is declared as follows:  STG=[StrategyFileName] where StrategyFileName is the name of the strategy file.
An external strategy, whether for objects or for joins, is made up of the following sections:
a name and description (These are visible in the Strategies tab of the Universe Parameters dialog box.)
a type parameter: object or join
an SQL parameter or file parameter
an optional parameter that points to a connection other than the universe connection.
An external strategy can be based on SQL or a file.
31. What are the visualization options available?
Designer contains a variety of features for organizing and viewing the tables and columns in the Structure pane. Among these features are: List Mode, which adds three panes to the Structure pane. These panes are for viewing the names of tables, joins, and contexts. When you click a component in a pane, its corresponding graphical representation in the schema is highlighted. Graphic options, which let you customize the shape or appearance of the tables, columns, joins, and cardinalities in the Structure pane.
Arrange tables, a feature that reorganizes the tables in the Structure pane so as to produce an orderly display. Gridlines, a command that displays a grid, which you can use to align tables in the Structure pane.
Table (Column) Values, commands that display the data values associated with a particular table or column.
32. What is Join Path Problem?
A one to many join links a table, which is in turn linked by a one to many join. This type of fanning out of one to many joins can lead to a join path problem called a fan trap.
The fanning out effect of “one to many” joins can cause incorrect results to be returned when a query includes objects based on both tables.
33. How to add aggregate table in universe in real life scenario?
Decide the reports which are using high aggregates
Create Aggregate table in DB
Insert them in Universe
Join them with dimension table
34. If we have a user group and we want to give the access to the report from 1990 to 2000. and from that group we want one user to restrict to see the report from 1990 to 1995. Then what to do in BO designer, so that this can be possible( Not in report level).
This can be done using row level security in universe parameter.
35. What is shortcut join. What is its use explain with an example
A shortcut join is a join which links two table by bypassing intervening tables that exists in the universe. This is used when it is possible in certain circumstances to make SQL more efficient.
e.g. in Above example if you want get the client list and there countries you can simple join country ID from client table to country id from country table. However this would introduce a loop. So instead of using normal join you make it as shortcut join. So if query contains object from client table and country table it would you shortcut join. This would result in efficient query avoiding extra join of region.
36. What is isolated join, explain with an example.
Isolated joins means the joins which are not included in
any context. suppose you have 15 joins in ur universe. in
context A you included 7 joins and in context B 7 joins.
The rest means one join is ur isolated join.
37. What is cardinality and its significance in BO universe
Cardinality expresses the minimum and maximum number of instances of an entity B that can be associated with an instance of an entity A. The minimum and the maximum number of instances can be equal to 0, 1, or N.
Because a join represents a bi-directional relationship, it must always have two cardinalities.
There are two main methods for detecting or editing cardinalities:
• Detect Cardinalities command
• Edit Join dialog box
If you selected the Detect cardinalities in joins options in the Database tab of the Options dialog box, Designer detects and retrieves the cardinalities of the joins. If you do not use this option, you can still retrieve the cardinalities for one or all joins in the universe.