Showing posts with label built. Show all posts
Showing posts with label built. Show all posts

Wednesday, March 21, 2012

No built in reports on Object Explorer Details tab

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
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.