Business Intelligence Questions

Q:

Why an infocube has maximum of 16 dimensions?

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, e.g. in Sql Server 2005, the recommended max limit for foreign keys is 253, but you can define more.

Report Error

View answer Workspace Report Error Discuss

0 1592
Q:

What are the challenges faced while successfully implementing Business intelligence?

Answer

Most companies grasp the potential value of successful business intelligence applications. However, a common challenge that IT professionals encounter is how to find successful BI application that are adopted by users and make a positive impact on the organization and on the bottom line. It can be difficult to structure effective BI project teams, select the right BI application, manage business-IT communications and measure BI success. BI is robust application, developing and optimizing successful BI application is always a challenge which involves structuring BI teams and managing business-IT communication.

Report Error

View answer Workspace Report Error Discuss

2 1342
Q:

What is hierarchy relationship in a dimension. whether it is: 1) 1:1 2) 1:m 3) m:m

Answer

1:m

Report Error

View answer Workspace Report Error Discuss

2 1327
Q:

How do we enhance the functionality of the reports in BO?

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.

Report Error

View answer Workspace Report Error Discuss

0 1322
Q:

Does Business Intelligence (BI) works with existing applications and databases?

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, Tally.ERP)

Report Error

View answer Workspace Report Error Discuss

0 1276
Q:

Explain the SQL Server 2005 Business Intelligence components.

Answer

- SQL Server Integration Services:- Used for data transformation and creation. Used in data acquisition form a source system.


- SQL Server Analysis Services: Allows data discovery using data mining. Using business logic it supports data enhancement.


- SQL Server Reporting Services:- Used for Data presentation and distribution access. 

Report Error

View answer Workspace Report Error Discuss

0 1275
Q:

Who are BI systems intended for?

Answer

For any member of the company who makes decisions based on transactional systems' data. Such systems may be oriented to different levels (analysts, managers, directors, auditors, etc.), providing different kinds of information in each case.

Report Error

View answer Workspace Report Error Discuss

0 1234
Q:

Which industries can benefit from BI?

Answer

Companies across all the industries like Manufacturing, BFSI, Retail, Service, Telecom, ITES, Pharma & Healthcare, Infrastructure & Construction, Automotive, Education, Government, Public Sector, etc. can benefit from BI.

Report Error

View answer Workspace Report Error Discuss

0 1233