Hey, y'all. New to SSAS, but not new to MOLAP. Here's my dilemma:

I've built a simple cube with sales/cost measures and two dimensional hierarchies, one for customer and one for time. In doing some basic checking of the cube, I find that my dimensional hierarchies aren't working. Here's an example:

Date Month
                     10 11
10/2/06 $177
10/15/06 $153
11/5/06 $100
Grand Total $430 $430

Could y'all steer me in the right direction? Thanks.

My karma ran over my dogma

your time dimension has me confused. You have dates then you say months. If your time dimention is by month you should not have individual dates. Here is the basics of how a MOLAP structure works. (I am not sure what your doing).

Source data

Date Sales
------- ----------
2006/01/05 100
2006/01/10 200
2006/02/03 10
2006/02/15 25

Then your fact table would look like this. Assuming your time dimention was monthly.

Time Sales
------- -----------
2006/01 300
2006/02 35

When you use OLAP/MOLAP/ROLAP/HOLAP/ etc. you should have less rows in your fact table than your source table, the data is rolled up thus smaller thus faster to access and interact with.

Now that being said what are you trying to do?