• Home
  • About
  • Archives
  • Contact
  • Subscribe
SQL Server Faq

Category Archives: MDX

Identifying Top MDX Queries running in SSAS environment

Tweet

SQL Server has management studio reports, performance dashboard reports to identify top cpu, duration, io queries which is possible due to the DMVs viz sys.dm_exec_query_stats which is available to track the queries. However with SSAS, we do not have any … Continue reading →

Categories: MDX, SSAS | Tags: formula engine, mdx, performance tuning, profiler, storage engine, top queries | Permalink

Unable to use Calculated Measures in MDX inside Category Groups of Chart Report Item in Reporting Services

Tweet

Recently, one of our customers came across an interesting issue which many of us face while working with Reporting Services which fetches the data from Analysis Services cube using MDX. So I thought I will share this in this blog … Continue reading →

Categories: MDX, SSAS, SSRS | Tags: linked server, mdx, query builder, reporting, ssrs | Permalink

About The Author

Parikshit Savjani is a Premier Field Engineer with Microsoft with specialization on SQL Server and Business Intelligence (SSAS,SSIS and SSRS). His role involves consulting,performance tuning,delivering workshops,chalk talks to Premier Customers of Microsoft environment. He contributes to the community by Blogging his learnings on this site, MSDN Blogs and MSPFE Blogs



Subscribe via Email


 

Subscribe Via Feed

Follow me

Follow @talktosavjani

Global Footprint

My inspirations

  • Amit Banerjee's Blog
  • Microsoft CSS Blog
  • Microsoft SQLServerFaq
  • Sourabh Agrawal's Blog
  • SQLServerGeeks

Proudly powered by WordPress | Theme: Yoko by Elmastudio

Top