|

SQL Server Performance Baselining Reports Unleashed for Enterprise Monitoring !!!

In my previous blog post, I had shared how you can leverage SQL Server Performance Dashboard SSRS Reports for monitoring and point in time troubleshooting for large deployments of SQL Server. In this post, we will talk about why dbas should establish SQL Server Performance baselines for their environment and how you can leverage the…

SSRS Report in Sharepoint Integrated Mode times out execution after 110 sec with unexpected error

Recently we faced a weird error while deploying an SSRS Report in a document library in SharePoint. The SSRS Report was  meant to be a Drill Through Report which was to be used as Detailed Report in PPS Dashboard exposed via SSAS Reporting Action. Being a Detailed Report it was expected to fetch a lot…

Improving the Performance of the reports by simplifying Drilldown Report to Drill through Report

Recently one of my customers in IT industry, had a P&L drilldown report aggregating the P&L metrics from the company level->client level ->account level -> project level -> employees at the row level while aggregating the data across date hierarchy Calendar Year->Calendar Semester ->Calendar Quarter -> Month at the Column Group Level with Adjacent Column…

Placing a Drillthrough Report in a different folder in SQL Server Reporting Services

When you design a drillthrough report in your reporting server project using BIDS, while adding the drillthrough actions for the report, in the dropdown you only get option to select the reports (rdl files ) designed in the same project. Hence when the entire project is uploaded, all the drillthrough reports can deployed in the…

| |

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

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 post for the benefit of the community. We have a following MDX query with Calculated…