Count dimension members using SSAS Dynamic Management Views (DMV)

יום שני, אפריל 2, 2012

As you know, while running a query which counts dimension members the Management Studio do not return how many rows were returned.  (for ex. select * from AW.. where Color = ‘Red’ ) To solve this problem you can write a query like this: WIth MEMBER aas (..members).count SELECT a on 0 from =========================================== WITH MEMBER aas (..members).count SELECT a on 0 from
אין תגובות

Some useful DMV Queries

יום שני, יולי 28, 2008

in the attached file you can find queries about Blocking, DiskIO, Memory, Running Queries, Indexes etc ...Itay Braun                        Premier Field Engineer - SQL Server and BI                        Microsoft Services - UKE-Mail: itayb@microsoft.com       Mobile: +44-796-928-9996         Blog: http://sqlblogcasts.com/blogs/thepremiers/ Veni              Vidi              Fixit
אין תגובות