Business Intelligence Interview Questions
What is your opinions on the hyperion tool as a industry best-in-class bi tool?
Business performance management
Explain the advantages of business performance management.
BPM is very useful in analyzing the current performance of your business.After analyzing the performance of different operations in your organization you can easily identify the various areas where yo...
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.
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,
Is proclarity is the tool most widely used ...Or if whats the most popular tool for business intelligence......How much we can rate for pro clarity out of 10....Any ideas share it mates.Thanks & regards
BI tools is very much used in data warehouse because with the help of BI tools we can analyse the performance of industries or we can make the history of records within few minutes.
If there is a problem with time series wizard, how will you do it manually?
By using SQL UPDATE Statement
UPDATE columnname SET date=()getdate
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.
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.
Hyperion essbase internally act as a ETL tool. Hyperion tool is used for OLTP, since it can analyse the history of the bussiness data.
It is an OLAP tool, which gives lot more options in fine tuning your reports,
Cheers,
Sithu, sithusithu@hotmail.com
What is the current best business intelligence tool in the market and for next few years?I want to learn hyperion tell me about that?
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...
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 ...
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...
Why we can't create an aggregate on an ods object?
ODS Data will be keep on changing...that only we are unable to do
Cheers, Sithu
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 is meant by ipedo in business intelligence?
What is hierarchy relationship in a dimension.Whether it is:1. 1:12. 1:m3. M:m
1:1 statrschema relatioship
1:m Parent-child relatioship
n:m sanwflakes relatioship
thanks,
sami
hierarchy relation ship shows the relation between the desired attributes in the table
Explain the role of degenerated dimension in data warehouse?
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.
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...
Hyperion has different modules such as essbase, interactive reporting, financial reporting and production reporting. Each tool has its own functionality. Hyprion interactive reporting and essbase are OLAP tools.
Hyperion ia a Business Intelligence (BI) and Business Performanc Management (BPM ) Tool. Its a market leader in Financial, Operational and Strategic Planning. It is having applications for Plann...
How do you improve performance in siebel analytics(standalone).
I worked with MNC where i was having standalone, see in Standalone while working on the side of admin you needed to pay attention on data modelling.If you are starting from scrach then give more look ...
What is olAP, molAP, rolAP, dolAP, holap? Examples?
Read Best Answer
Editorial / Best Answer
Answered by: John
Answered On : Mar 27th, 2005Cubes 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.
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...
OLAP – Online analytical Processes MOLAP – Multidimensional Online analytical Processes (Cubes) ROLAP – Relational Online analytical Processes (RDBMS) HOLAP – Combination of MOLAP...
Rs. 31.63.
31.63
Why an infocube has maximum of 16 dimensions?
As the total charecterstics are 255, out of which 16 charecters are being allowed for foreign keys and 6 charecters are for sap default, for this sake we have only 16 dimention tables, of which 3 are again sap default (unit, time. Datapacket): so finally we have only 13 user dimentions.
Because any Database will supports only 16 foreign keys in a database table.
Can anyone explain about auditing in bo xi r2?? What is the use of it??
auditor is used by the business objects administrators to know the complete information of the business intelligence system.
1.it monitors entire BIsystem at a glance.
2.Analyzes usage and change impact
3.optimises the BI deployment
User Panel
Categories
Interview Coaching
Ads
Connect
Ads
Interview Question
Latest Questions
Ads
Interview & Career Tips
Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.
NH
Hyperion has a very wide product range which it offers.The widely accepted and most popular tools which distinguishes it from others like BO and COGNOS are Hyperion Essbase(MDDB),Hyperion Financial Ma...