Criteria for defining OLAP cubes
Page 1 of 1
Criteria for defining OLAP cubes
Hi,
I am considering create a physical OLA cube in my DW.
I hace OLAP analysis that need preagregate data to work faster.
I have read and heard that there are some question to take in account before to create a cibe.
1) Space and processing time. As a criteria if you have more than 10 dimensions, the cube can grow a lot and it takes long to update, is it true??
2) You can have a lot of values in some cells of the cube where the join of dimensions don't have data
3) It makes a longer ETL or actualizacion process: source files -> ETL -> relational DB of DW -> agreggate -> physical cube
More things to take in account?
Is there any alternative to cubes?
Thanks in advance
I am considering create a physical OLA cube in my DW.
I hace OLAP analysis that need preagregate data to work faster.
I have read and heard that there are some question to take in account before to create a cibe.
1) Space and processing time. As a criteria if you have more than 10 dimensions, the cube can grow a lot and it takes long to update, is it true??
2) You can have a lot of values in some cells of the cube where the join of dimensions don't have data
3) It makes a longer ETL or actualizacion process: source files -> ETL -> relational DB of DW -> agreggate -> physical cube
More things to take in account?
Is there any alternative to cubes?
Thanks in advance
juanvg1972- Posts : 25
Join date : 2015-05-05
Similar topics
» Difference between Aggregate Fact Tables, Rollup Tables and OLAP Cubes ?
» Excel as an OLAP viewer - How to view OLAP details (the grain) in excel
» What is the criteria to decide on Extraction vs Report (ing)
» Criteria for splitting fact tables
» Healthcare data and criteria for case finding
» Excel as an OLAP viewer - How to view OLAP details (the grain) in excel
» What is the criteria to decide on Extraction vs Report (ing)
» Criteria for splitting fact tables
» Healthcare data and criteria for case finding
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum