Hi all,

I have a dimension table to record datetime and I would like to create
a ROLAP dimension that will show the new entries added to the dimension
table.

I've created a ROLAP cube and I believe I have created a ROLAP
dimension (When I create the dimension, I specified it as a changing
dimension and I made sure the leaf member key is unique). I ran my
test and I can see my aggregation value changes, but I cannot see any
changes to the dimension. For example, before I ran the test, I have
Jan, Feb, Mar showing up in the dimension table. After the test, I
have Jan, Feb, Mar, Apr, May. I checked the dimension table using
Query Analyzer, and I can see the new entries, but when I go Browse
Dimension Data in Analysis Service manager, I cannot see the new
entries until I process the dimension again. Is what I wanted to do
possible? If yes, can someone point me in the right direction as to
what I might have done wrong?

Thanks,
Harold