What are the primary ways to store data in OLAP?
- 3 Answers
- 6441 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
To design any OLAP model, first we need to understand what
OLAP system we are designing.
We have 2 models for Understanding and implementing project.
E-R Model - which is logical helps us understand components.
Dimension Model - which is practical helps us design OLAP
system.
E-R Model helps us to analyse various Entities related to
the project we are about to design and relation between
them. Its more of a rough sketch using pen and paper or
mind map.
Let me give you an example by taking a College system for
an instance
Entities to be considered for designing college may be -
Administration (Principals, HODS)
Transportation (of course College provides Transportation)
Teaching faculty
Non-Teaching (workers, peons)
Canteen and Stationary
Hostels ( in case of Residential Colleges)
Accounts
.... goes on..
We just understand various components related to the
college database construction and identify the relation
between college and them.
Once E-R model is done and we are clear with the components
involving in database design, we go with Dimensional model.
Analytic Workspace Manager is the primary tool for
creating, developing, and managing dimensional objects in
Oracle Database. Using this tool, we actually design the
data for the
This deals with creating Database with Facts and
Dimensions, Tables for each component.
- Design Dimensions for each component.
- Analyse what type of schema would suit your purpose
whether star/snowflake model.
- Analyse primary key/ foreign key relationships in these
dimensions.
- Creation of Dimensions, Cubes to load data into them.
- Once Cubes are Created , we go for multi dimensional
analysis on them to detail levels and hierarchies.
and save changes in the AWM.
There are various additional components to be designed.
Please find it in the below link
http://docs.oracle.com/cd/B28359_01/olap.111/b28124/cubes.ht
m
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / guest
To design any OLAP model, first we need to understand what
OLAP system we are designing.
We have 2 models for Understanding and implementing project.
E-R Model - which is logical helps us understand components.
Dimension Model - which is practical helps us design OLAP
system.
E-R Model helps us to analyse various Entities related to
the project we are about to design and relation between
them. Its more of a rough sketch using pen and paper or
mind map.
Let me give you an example by taking a College system for
an instance
Entities to be considered for designing college may be -
Administration (Principals, HODS)
Transportation (of course College provides Transportation)
Teaching faculty
Non-Teaching (workers, peons)
Canteen and Stationary
Hostels ( in case of Residential Colleges)
Accounts
.... goes on..
We just understand various components related to the
college database construction and identify the relation
between college and them.
Once E-R model is done and we are clear with the components
involving in database design, we go with Dimensional model.
Analytic Workspace Manager is the primary tool for
creating, developing, and managing dimensional objects in
Oracle Database. Using this tool, we actually design the
data for the
This deals with creating Database with Facts and
Dimensions, Tables for each component.
- Design Dimensions for each component.
- Analyse what type of schema would suit your purpose
whether star/snowflake model.
- Analyse primary key/ foreign key relationships in these
dimensions.
- Creation of Dimensions, Cubes to load data into them.
- Once Cubes are Created , we go for multi dimensional
analysis on them to detail levels and hierarchies.
and save changes in the AWM.
There are various additional components to be designed.
Please find it in the below link
http://docs.oracle.com/cd/B28359_01/olap.111/b28124/cubes.ht
m
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / guest
To design any OLAP model, first we need to understand what
OLAP system we are designing.
We have 2 models for Understanding and implementing project.
E-R Model - which is logical helps us understand components.
Dimension Model - which is practical helps us design OLAP
system.
E-R Model helps us to analyse various Entities related to
the project we are about to design and relation between
them. Its more of a rough sketch using pen and paper or
mind map.
Let me give you an example by taking a College system for
an instance
Entities to be considered for designing college may be -
Administration (Principals, HODS)
Transportation (of course College provides Transportation)
Teaching faculty
Non-Teaching (workers, peons)
Canteen and Stationary
Hostels ( in case of Residential Colleges)
Accounts
.... goes on..
We just understand various components related to the
college database construction and identify the relation
between college and them.
Once E-R model is done and we are clear with the components
involving in database design, we go with Dimensional model.
Analytic Workspace Manager is the primary tool for
creating, developing, and managing dimensional objects in
Oracle Database. Using this tool, we actually design the
data for the
This deals with creating Database with Facts and
Dimensions, Tables for each component.
- Design Dimensions for each component.
- Analyse what type of schema would suit your purpose
whether star/snowflake model.
- Analyse primary key/ foreign key relationships in these
dimensions.
- Creation of Dimensions, Cubes to load data into them.
- Once Cubes are Created , we go for multi dimensional
analysis on them to detail levels and hierarchies.
and save changes in the AWM.
There are various additional components to be designed.
Please find it in the below link
http://docs.oracle.com/cd/B28359_01/olap.111/b28124/cubes.ht
m
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the difference between datawarehouse and bi?
Explain the difference between view and materialized view?
How can you import tables from a database?
What is dimension modeling?
Explain what is the difference between a primary and secondary actor in use case modeling?
Select * from emp,dept,loc where emp.deptno left outer join dept.deptno and dept.locno=loc.locno. No need to consider the syntax but is it possible to have left outer join and equi join in the same SQL like this ? can we have right outer join and left outer join in the same SQL ---
1 Answers Principal Finance, PT Metalogix Infolink Persada,
What is drill-through?
What is factless fact tables?
in siebel analytics by using dashboard prompts in a page have 2 reports so i have to give dashboard prompt to applied on first report only that will not applied to 2 report how it will do
wht is degenerated dimension ?it's uses?
How to create diff. Types of templates?
explain the ROLLUP, CUBE, RANK AND DENSE_RANK FUNCTIONS OF ORACLE 8I
3 Answers IBM, Ness Technologies,
Teradata 
