Criteria for defining OLAP cubes

View previous topic View next topic Go down

Criteria for defining OLAP cubes

Post  juanvg1972 on Thu Jun 18, 2015 4:51 pm

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


juanvg1972

Posts : 25
Join date : 2015-05-05

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum