I have added an extra month's data into our data warehouse and then
fully processed the my cube in order to bring in the new data. However,
when browsing the cube's data, it hasn't loaded the new month's data.

By way of a test, I created a new cube with just one (time) dimension
and the new month's is correctly loading in.

Does anyone have any ideas ?

have you updated your Time dimension?
does the number of rows read from the source = the number of rows including
this new month?
have you any partition?

<jerstep (AT) yahoo (DOT) com> wrote

Yes, yes and yes. Time dimension already contains all dates upto 2050
so refresh/reprocess of the dimension is not necessary but has been
done anyway.

Rows in cube and in data source do correctly match.

I have partitioned by financial year. I have reprocessed partitions
individually although they are reprocess when fully reprocessing the
cube.

when I mean "rows in cube" I mean "rows really read from the database by AS"
But I presume you allready have checked this.

if you add a dummy row for the next month, did you see it?


<jerstep (AT) yahoo (DOT) com> wrote