|
Home > Archive > MS SQL Data Warehousing > January 2006 > Cube processing but not showing data
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Cube processing but not showing data
|
|
| Brian Madden 2006-01-09, 9:23 am |
| 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
| |
|
| I 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:920700632723957
312741258@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
>
>
|
|
|
|
|