I#%92m a BI developer and have a hardware question. We have recently specked up some new servers for our datawarehouse and OLAP solution, we have...
There are many reasons for slow processing, but there are usually two main causes, volume of data and number of aggregations. One way to check if it...
Post your SQL Statement and txt file (if not to big) and we'll see if there's anything rather obvious. Other question - does this query ever work?...
Joozh, As you know, in general building dimensions from fact data is a bad approach, but yes in this case seen as there are only 2 members it is...
Are the dimensions built from the fact table? What I'm trying to get at is probably the same thing as Raulie. More often than not these types of...
Joozh, How are you updating the cube, incramental/ refresh or full? does this problem happen on successive full or refresh cubde reprocesses?...
Joozh, You not doing anything wrong, multiple partitions are there for performance reasons. Yes you can partition any cube but that also means more...
Joozh, Lets look at this from a slightly wider angle, more to do with company information rather than just Microsoft / Oracle etc DBA#%92s and...
Separate names with a comma.
