Name some of the standard Business Intelligence tools in the market?

Correct Answer: A universe is a business-oriented mapping of the data structure found in databases: tables, columns, joins, etc It can represent any specific application, system, or group of users For example, a universe can relate to a department in a company such as marketing or accounting In the BusinessObjects User module, universes enable end users to build queries from which they can generate and perform analysis

Correct Answer: SSIS, SSAS and SSRS are the most important reporting systems that BI professionals work with On a detailed level, I have worked with data mining, master data management, data profiling and data cleansing and analysis

Correct Answer: Business intelligence is a concept that covers development of warehousing and business intelligence applications and databases that assist in diagnosing and repairing user issues as well as performance ones This is an extremely important set of procedures as it engenders quality end-user products and helps company representatives in understanding core issues and resolving them

Correct Answer: Yes Business Intelligence (BI) solution like 1KEY is designed to interoperate with data that exists in virtually any enterprise data source, such as Oracle, IBM DB2, or Sybase For example, you can use SQL Server 2005 Reporting Services to run reports on data stored in an Oracle database Also, SQL Server 2005 Integration Services can be used to extract data to or from any OLEDB data source 1KEY can connect to multiple database, multiple applications like ERP, CRM, SCM, HRM, financial accounting or any other core transactional application (SAP, Orracle E-Business Suite, PeopleSoft, JD Edwards, Siebel, QAD MFG/Pro, Microsoft Dynamics, Navision, Ramco, TallyERP)

Correct Answer: Dashboards are real-time business intelligence interfaces They allow a huge amount of data to be read in a single interface in order to analyse the success or failure of the business or project in question

Correct Answer: If you create an Aggregate with more than 16 characteristics, then we call that aggregate as FLAT Aggregate When an aggregate is active then new data is not available for reporting,These aggregates are called Flat Aggregates

Correct Answer: Catalog Manager supports command line options To move reports and dashboards, we need to use some general syntax using catalog manager eg: catalogmanager -online/offline -cmd {report | replace | export} {command line options} In extra, by keeping it online, This will automatically open up the catalog manager without having the need to enter the connection details every time

Correct Answer: There are lot of ways are there to use the conditional formatting, most of the Process flow maintains more attention in the loops, alias and contextCheers

Correct Answer: You can format the BO Reports by using various features available You can turn the table reports into a 2-Dimensional or 3-Dimensional charts You can apply an Alert to show some data in a different format , based on some business rule You can also create some prompts, which will asks user to give some input values before seeing the reports, this way they will see only filtered data There are many similar exciting options available to enhance the reports

Correct Answer: Because any Database will supports only 16 foreign keys in a database table It depends upon the Database limits provided to define the Foreign key constraint, eg in Sql Server 2005, the recommended max limit for foreign keys is 253, but you can define more