SQL 2005 SP3, AS 2000
I have a cube that is processing but is not showing any data when I browse
the data. The fact and dimension tables have data and there are no null meas
ures
or fields in any of the tables involved. It will process without any problem
s.
Has anyone come across this before?
Thanks!
BrianI have! and I hope the solution is the same
Can you confirm that you have installed the ASSP3? (may i suggest SP4 now?).
A lot of people install the SQLSP and assume that it will automatically
upgrade all other products SQL related, i.e. MSDE and AS, but this isn't the
case. There are seperate SP's available for each that can be found on the
same download page from Microsoft as the SQL SP download page.
Try to install the ASSP3 or SP4 and see if that sorts you out.
If you've already done that, then I will crawl back into my hole...
Immy
"Brian Madden" <bmadden@.gmail.com> wrote in message
news:920700632723957312741258@.msnews.microsoft.com...
> Hi all,
> SQL 2005 SP3, AS 2000
> I have a cube that is processing but is not showing any data when I browse
> the data. The fact and dimension tables have data and there are no null
> measures or fields in any of the tables involved. It will process without
> any problems. Has anyone come across this before?
> Thanks!
> Brian
>
No comments:
Post a Comment