Wednesday, March 21, 2012
No built in reports on Object Explorer Details tab
Details instead of Summary tab. Object Explorer Details looks in most ways
very similar to the Summary tab, however, I do not see the Reports button.
Anyone know where it went?
Thanks a lot!
Susan Goldberg
SQL Server DBA
Hi Susan,
Right click on the objects in the object explorer and select Reports >
Standard Reports > <whatever you're looking for>. i.e. Goto a database and
right click on it, or go to a server and right-click on it, etc. HTH
-- Don
"Susang" <Susang@.discussions.microsoft.com> wrote in message
news:A33D81E5-AC10-419C-9D5E-6905BED60CB9@.microsoft.com...
>I upgraded to sql server 2005 (developer) sp2. I now have Object Explorer
> Details instead of Summary tab. Object Explorer Details looks in most ways
> very similar to the Summary tab, however, I do not see the Reports button.
> Anyone know where it went?
> Thanks a lot!
> --
> Susan Goldberg
> SQL Server DBA
No aggregations for Measure Group possible in Analysis Server 2005
I have a cube with about 20 Measure Groups and 30 dimensions. I built some dimensions using BI Development Studio a few weeks ago. The aggregations were build for any measure group without problems.
Now I changed some attributes and want to run the aggregation wizard on my test plattform to design new aggregations. But there were no aggregations build. It shows 0 aggregations.
I read that sometimes this happens when the cube is too complex. But the complexity did not grow very much.
What should I do to be able to design aggregations again?
Best regards,
Stefoon
There is an exellent writeup about aggregations in performance guide.
Chirs's blog is good source for information http://cwebbbi.spaces.live.com/blog/cns!7B84B0F2C239489A!907.entry
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.