Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Criteria for defining OLAP cubes

Go down

Criteria for defining OLAP cubes Empty Criteria for defining OLAP cubes

Post  juanvg1972 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

Back to top Go down

Back to top

- Similar topics

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