It’s time to congratulate another June TechNet Guru winner!
Here is Yogish’s winning article:
Here are all the June SSAS winners:
|SQL Server Analysis Services Technical Guru – June 2013|
|Yogish Bhat||Aggregations in SSAS||
Peter Laker: “Excellent subject. Excellent detail. Nice formatting.”
|Yogish Bhat||MOD Function in MDX||Peter Laker: “Useful tip. Thanks!”
Ed Price: “Great solution!”
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:
Also, for the July Guru competition, see
Are you a Wiki Ninja? http://technet.com/wiki
– Ninja Ed