-
Features and Benefits of Business Intelligence
1. What is Business Intelligence?
2. Why Business Intelligence is required?
3. What are the Features of Business Intelligence
4. What are the Benefits of Business Intelligence
5. What is Business Analysis?
6. What is Business Analytics?
7. What is Bench marking in Business?
8. What are BI Tools?
9. List few Business Functions
-
Explain the role of DEGENERATED Dimension in Data Warehouse?
Thiru
- Oct 4th, 2007
Degenerated dimension keys are keys in the fact table that are not dimension keys (Foreign keys to the Hiearchy/dimension tables) and measurements. Like, Order Number, Invoice Number etc.
sithu
- Mar 24th, 2007
A Degenerate dimension is a Dimension which has only a single attribute.This dimension is typically represented as a single field in a fact table.Degenerate Dimensions are the fastest way to group sim...
-
How do you make a column drillable if its not a dimension hierarchy level?
ravimantur
- Jun 12th, 2009
Create a Alternate Drill down like if region is the name of dimension and the hierarchy is RegionCountry Branch NameBranch Name &...
-
How would you handle conditional formats in BI
idanh79
- Dec 1st, 2009
You can use calculated members in OLAP cube?and change the format?accordingly the value of the cell.Idan Halfon?
sithu
- Mar 24th, 2007
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,Sithusithusithu@hotmai.com
-
-
What is the main use of business content? How data can be loaded into business content after installation?
maheswarrlasekharr
- Apr 10th, 2013
Just install the ready made business objects and activate it, replicate into bw install suitable info source then onwards extract the data from R/3 to bw run info package.
Sleekpage
- Dec 20th, 2009
Business content can come from various parts of your business operations. Some from the finance department and some from the sales department.If these business content are consistent and can be used b...
-
Dashboard in the business intelligence
I would like to know the exact definition of the term Dashboard. As of late there has been a great deal of confusion on the overuse of this term in my workspace. I was under the impression that this term referred to analytical graphs that were designed to mimic speedometer displays like a dashboard in a car. Lately, it seems that people are using this term to apply to any form of analytic graph...
sithu
- Jan 10th, 2008
Dashboard is a user interface that organizes and presents information in a way that is easy to read. In regards to Business intelligence dashboard is a reporting tool that consolidates aggregates and ...
jd_usnj
- Dec 24th, 2007
I agree with you that it's like a car dashboard you can visualize every thing. but it works diffrent here. In detail we monitor our enterprise business process goals. In technical way KPI and then...
-
T-codes
Explain about T-Codes and where can you find the list of T-CodesRaakesh
balaramtripathy
- Nov 16th, 2010
T-Code are Transactional Codes in SAP it will quick navigate to a particular screen.We will find all the T-codes, on the following steps,Got to SE16(t-code)then type TSTC on barthen executive, and ag...
suyogpatil09
- Jan 7th, 2010
T-Code are Transactional Codes in SAP, it facilitates the quick navigation to a particular screen by entering the T-code for that transaction in the textbox provided on left side top corner.&nbs...
-
Dimensional Modelling
Explain the design of dimensional model for Internet selling
Ramanagoud
- Mar 17th, 2013
Dimensional model will be having original tables and will be joined directly to other tables using primary key. As in ER modelling we will not do any normalization here. We don't bother about any memo...
BIchick
- Feb 5th, 2010
This is simple layout without stocking/restocking data, also without GL, specials handling, etc...You would have to have these dimensions:Date (including, excluding time - based on how grainual you ne...
-
Conditional Reports
Can any one explain conditional reports in detail
clarkpca
- Jun 14th, 2010
A conditional report is based on the data gathered, then analyzed during the report generation, which reports out results of the analysis in the report's output.
ramandeep singh
- Dec 1st, 2008
In the conditional reports we can make the hardcopy of reports which we want in any angle of database.
-
An Agent and A Broker
What is the difference between an agent and a broker?
Inclus12
- Oct 27th, 2009
Yes there is. Let me clarify:-1. An? ?agent represents one? ?Company while a Broker represents the Customer and takes the customer details and goes to multiple?companies to get the best quote and...
smsreddy
- May 20th, 2009
Broker is individual and not a part of any organization/company.Agent works for a company for eg : LIC agent works for LIC.
-
-
Has Hyperion got the ability of doing ETL process also? (or) is it only a OLAP toolHow Hyperion differs from other tools?Does MOLAP capability let it lead?
-
-
Why we can't create an aggregate on an ODS Object?
sithu
- Jan 10th, 2008
ODS Data will be keep on changing...that only we are unable to do
Cheers, SithuJavid
- May 3rd, 2007
Hi,This is a common question, asked anywhere.While loading into the Datawarehouse we gather data(source) from different source systems and place it in a STAGING area - which is literally called as ODS...
-
What are major d/f's b/w Reporting tools(e.g. Crystal report) and OLAP reporting Tools(e.g. Hyeprion,Cognos )?
attiliasp
- Sep 19th, 2008
OLAP?reporting?(online?analytical?process)?in?this?reporting?can?do?simple?anyalsis?of?the?data?in?report?like?graphical?and?physical processing?of? the?company.Reporting?tools:?In?this?we?can?only?see?the?reports? we?cannot?modify?them.
Varun
- May 25th, 2007
I guess with Cognos Report Net report bursting is possible ie splitting one report and sending to multiple people, Which I suppose is not possible in other tools.And the architecture of Reportnet is diff from the rest.
-
Catalog Manager.
What is Catalog Manager? How to move reports and dashboards using Catalog Manager?
pnagarjuna.technical
- Oct 3rd, 2012
Leodin is correct and the catalog manager is that which stores the objects like reports, dashboards, pages, filters.
leodingzy
- Jan 14th, 2011
When you migrate reports and dashboards from one environment to another, you can open the catelog side by side. Then select all the reports from the source catelog, right click on it and click on the ...
-
What is OLAP, MOLAP, ROLAP, DOLAP, HOLAP? Examples?
Read Best Answer
Editorial / Best Answer
Answered by: John
- Mar 27th, 2005
Cubes in a data warehouse are stored in three different modes. A relational storage model is called Relational Online Analytical Processing mode or ROLAP, while a Multidimensional Online Analytical processing mode is called MOLAP. When dimensions are stored in a combination of the two modes then it is known as Hybrid Online Analytical Processing mode or HOLAP.
MOLAP
This is the traditional mode in OLAP analysis. In MOLAP data is stored in form of multidimensional cubes and not in relational databases. The advantages of this mode is that it provides excellent query performance and the cubes are built for fast data retrieval. All calculations are pre-generated when the cube is created and can be easily applied while querying data. The disadvantages of this model are that it can handle only a limited amount of data. Since all calculations have been pre-built when the cube was created, the cube cannot be derived from a large volume of data. This deficiency can be bypassed by including only summary level calculations while constructing the cube. This model also requires huge additional investment as cube technology is proprietary and the knowledge base may not exist in the organization.
ROLAP
The underlying data in this model is stored in relational databases. Since the data is stored in relational databases this model gives the appearance of traditional OLAP?s slicing and dicing functionality. The advantages of this model is it can handle a large amount of data and can leverage all the functionalities of the relational database. The disadvantages are that the performance is slow and each ROLAP report is an SQL query with all the limitations of the genre. It is also limited by SQL functionalities. ROLAP vendors have tried to mitigate this problem by building into the tool out-of-the-box complex functions as well as providing the users with an ability to define their own functions.
HOLAP
HOLAP technology tries to combine the strengths of the above two models. For summary type information HOLAP leverages cube technology and for drilling down into details it uses the ROLAP model.
Comparing the use of MOLAP, HOLAP and ROLAP
The type of storage medium impacts on cube processing time, cube storage and cube browsing speed. Some of the factors that affect MOLAP storage are:
Cube browsing is the fastest when using MOLAP. This is so even in cases where no aggregations have been done. The data is stored in a compressed multidimensional format and can be accessed quickly than in the relational database. Browsing is very slow in ROLAP about the same in HOLAP. Processing time is slower in ROLAP, especially at higher levels of aggregation.
MOLAP storage takes up more space than HOLAP as data is copied and at very low levels of aggregation it takes up more room than ROLAP. ROLAP takes almost no storage space as data is not duplicated. However ROALP aggregations take up more space than MOLAP or HOLAP aggregations.
All data is stored in the cube in MOLAP and data can be viewed even when the original data source is not available. In ROLAP data cannot be viewed unless connected to the data source.
MOLAP can handle very limited data only as all data is stored in the cube.Stephen
- Mar 11th, 2015
What type is MS SSAS cubes? ROLAP, MOLAP or HOLAP?
SWARNA
- Nov 23rd, 2006
OLAP(ONLINE ANALYTICAL PROCESSING):It is a set of specifications which allows the client applications in retriving the data from the DataWareHouse for analytical process.There r 4 types of OLAPS...
-
What are the various modules in Business Objects product Suite?
giri
- Apr 6th, 2012
2 Types
Web Based: CMC,Infoview,Polestar,CCM
Window Based:UNIV,Webrich,BVM,Zcelsiusanasat
- Dec 22nd, 2008
The various modules in BO are .,Desktop Intelligence, Designer module, Import wizard which are in client side. Web Intelligence(Infoview), Central Management Console (CMC), Central Management Server (CMS), Perfomance Management (PM) are in server side.
-
How to Import universes and user from business object 6.5 to XI R2, it is showing as some ODBC error is there any setting to change?
anasat
- Dec 22nd, 2008
If we import universes and users from BO 6.5 to XI R2, the universes and the connections are also imported. If it is showing error in ODBC, It seems to be a connection error. try to create a new conncetion for the importing universe.
sithu
- Jan 10th, 2008
We can import the universe, users and reports by using a import wizard available in BO XI R2 the other way you can restore using BIAR file, just take a back of your BO 6.5 Security, universe and document domain and extract those in BOXI R2
Cheers,
Sithu,
Business Intelligence Interview Questions
Ans