Hi,

This is Srinivasa Rao,Pls help me I am having 3.5 years of experience as SAP BI/BO consultant ,I completed my BSc in 2009

How to tell about my self
pls help me

Thanks in advance

veda

• May 17th, 2017

Sure. Myself , I have 3.5 years of experience working on Business Intelligence,ETL ,and Visualization Tools. I started my career as a BO developer and after couple of projects I started working on B...

Answer Question  Select Best Answer

Abhilash

• May 5th, 2017

Spotfire is one of best BI tool I have worked on.

Deep

• Sep 10th, 2015

There are many available in market
For ETL : Informatica
For Reporting : Qlikview, Tablaeu,BO,Xcelsius etc.

Answer Question  Select Best Answer

How can i use the hierarchy object as a prompt to filter the data in webi report

Riya Shan

• Jun 7th, 2016

We cannot use hierarchy at the query filter(Prompt ) level. Hierarchy can be used to drill down or drill up the values in the report.

Answer Question  Select Best Answer

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

yunis

• May 29th, 2016

It is nothing but fact data reporting.

Answer Question  Select Best Answer

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...

Improve Answer

Veerendra Dhaigude

• Nov 24th, 2014

Business Intelligence uses computing technologies to get insight of business data that identifies,discovers and analyzes data. Such as sales revenue, products, costs etc. It Provides current, histori...

Poonam Makhija

• Sep 26th, 2014

Taking raw data and convert into information in readable format which helps to take tactical decision

Answer Question  Select Best Answer

What is the max possible number of aggregations for a system with 2 dimensional and 3 levels? ( In Business Objects & data Warehousing)

Rebecca

• Jan 20th, 2014

An answer to explain to end users: What is a universe?? A universe is a business-oriented mapping of a set of Epic Clarity or other data that is focused on a specific content area or user need. A u...

maheswarrlasekharr

• Apr 10th, 2013

Middle layer of the data base table to Reporting tool

Answer Question  Select Best Answer

kishore

• Nov 26th, 2013

If we create an aggregate on a dimension which has less than or equal to 16 characteristics, then it is act as a line item dimension, This type of aggregates are called flat aggregates. my personal re...

JAGADISH RAJU

• Sep 14th, 2011

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.

Answer Question  Select Best Answer

Answer posted by Vikas R on 2005-05-22 02:57:09: OLAP stands for Online Analytical Processing. It is used for Anaytical reporting

maheswarrlasekharr

• Apr 10th, 2013

Olap stands for Online Analytical Processing.
Every day we load OLTP to OLAP for Data analysis.
Then generate reports base this reports end-user take decisions.

ramandeep singh

 Profile Answers by ramandeep singh Questions by ramandeep singh

• Dec 1st, 2008

OLAP is used to extract data from multiple sources. All extraction is done online by making use of ETL

Answer Question  Select Best Answer

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

 Profile Answers by Sleekpage Questions by 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...

Answer Question  Select Best Answer

can you explain the real time scenario in which we use generic extraction in SAP ECC for SD,FI etc

maheswarrlasekharr

• Apr 10th, 2013

first we install the bi content data source. if any customization fields, add fields extract structure, Replicate the data source into bw it reads complete metadata of the data source and maintain tim...

Answer Question  Select Best Answer

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

 Profile Answers by BIchick Questions by 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...

Answer Question  Select Best Answer

Why and how do you use complex join in alias table?

pnagarjuna.technical

 Profile Answers by pnagarjuna.technical Questions by pnagarjuna.technical

• Oct 3rd, 2012

1) When ever the join between the tables is other than equal operator the join is complex join.
2) If we use AND operator in physical join it refers to complex join.
3) In BMM layer we can change the type of join like inner OR outer, this is also refers to Complex join.

Answer Question  Select Best Answer

What is Catalog Manager? How to move reports and dashboards using Catalog Manager?

pnagarjuna.technical

 Profile Answers by pnagarjuna.technical Questions by pnagarjuna.technical

• Oct 3rd, 2012

Leodin is correct and the catalog manager is that which stores the objects like reports, dashboards, pages, filters.

leodingzy

 Profile Answers by leodingzy Questions by 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 ...

Answer Question  Select Best Answer

Shirley Reagor

• Jun 17th, 2012

The use of Data Cubes will help performance on queries to an OLAP database. Keeping in mind this will take up additional memory to do.

Answer Question  Select Best Answer

giri

• Apr 6th, 2012

2 Types
Web Based: CMC,Infoview,Polestar,CCM
Window Based:UNIV,Webrich,BVM,Zcelsius

anasat

 Profile Answers by anasat Questions by anasat

• 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. 

Answer Question  Select Best Answer

Shankar

• Oct 22nd, 2011

The table,column, and key objects provide the metadata necessary for Oracle BI Server to access the actual physical sources with SQL requests.

The actual SQL Query which is passing to DB(Data Warehouse).

Thanks,
Shankar

Answer Question  Select Best Answer

what is the difference between functions and stored procedures in sql server?

what tool we are using in project management tool for developing packages in ssis?

how to rectify the errors in stored procedure in sql server how many ways are there?

Bapineedu Bollempalli

 Profile Answers by Bapineedu Bollempalli Questions by Bapineedu Bollempalli

• Sep 21st, 2011

Functions can be used with Select statement Not returning output parameter but returns Table variables You can join UDF Can not be used to change server configuration Can not be u...

Answer Question  Select Best Answer

kiran

• Sep 17th, 2011

Column selector permits users to dynamically change which columns to appear in results.
Try it in the 'views' in presentation services.

kiran

Answer Question  Select Best Answer