but how do you define the partition to be "current month"? I thought about it, but my partitions are per table. how do I create 2 partitions based on the same table, one being "last X time" and the other being "the rest" ?
and how do I do it so it is automatic? so that I don't need to change the...
thanks.
I understand the differences, that is why I thought I should have a system set up as ROLAP at first, when the database starts fresh, and then transform it into MOLAP as the database gets bigger... but I thought there will be an easy way of doing so, without manually going partition by...
I have a cube, with few partitions (the ones that are created automatically,
nothing I made), and few dimensions.
I want to change it to ROLAP (currently MOLAP). I notice I can go in the
management studio and change each partition individually, and the cube, and
the dimensions... but that...
Hi. I am a analysis services/cubes newbie, but on the track to getting what I need to know (-:
I wanted to get some best practices for the following issues (maybe I will start with one and then add as I go...)
My system records data, the classical thing a transactional DB is doing. the fact...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.