It's time to congratulate another June TechNet Guru winner!
Yogish Bhat is our SSAS TechNet Guru for June! See the TechNet Guru Contributions for June 2013.
Here is Yogish's winning article:
Aggregations in SSAS
Here are all the June SSAS winners:
Peter Laker: "Excellent subject. Excellent detail. Nice formatting."Ed Price: "Great explanations, clearly written, and good job breaking up the sections so that it's easy to read and to use the TOC."
Thanks Yogish for jumping in there and representing Analysis Services!
Here's an excerpt from the article:
Clear the SSAS database cache since the data requests can also be satisfied by the cache, to clear cache use the below code:
<ClearCache xmlns="http://schemas.microsoft.com/analysisservices/2003/engine"> <Object> <DatabaseID> Adventure Works</DatabaseID> </Object> </ClearCache>
Connect to the SQL Server Management Studio (SSMS) ->Tools -> SQL Server Profiler. Select the default trace option and click on Run. Fire the MDX by opening the new query window so that aggregation can be hit by the query, Observe query processing and query events in the SQL Server Profiler, this would show data being extracted from the aggregation and the data request is satisfied within no time, in some cases aggregations may take some time where in designer might have created more aggregations. Before building the aggregations, using the SQL Server Profiler capture the statistics so that is can be compared later against the aggregations statistics.
Read the rest here:
Thanks to Yogish Bhat for your great contribution to the TechNet Guru contest! You can read about all the June winners here: TechNet Guru Award Winners - June 2013
Also, for the July Guru competition, see TechNet Guru Contributions for July 2013.
Are you a Wiki Ninja? http://technet.com/wiki
- User Ed