Manage SSRS in Management Studio
I hear I can manage SQL Server Reporting Services in Management Studio? Is that true? In this tip we look at what options you have to manage SSRS from within SQL Server Management Studio.
I have a passion for crafting Business Intelligence Solutions for my user groups. My experience includes almost 15 years of SQL Server involvement with the last 12 years focused specifically on Business Intelligence, SharePoint, OLAP, SSRS, and Decision Support solutions. Currently, I am a Business Intelligence Architect in the healthcare industry, and I also teach database and analytics classes for Kennesaw State University, Southern New Hampshire University, and Reinhardt University. My education includes an MBA and an undergraduate in Accounting (yes I am a reformed accountant!), both from Kennesaw State University. I enjoy every day by trying to grow my faith and spend precious time with my family. I have been happily married to my wife of over 20 years, and we have two teenagers one who we home school with the help of a University Model School, Cornerstone Prep in Acworth, GA (cornerstoneprep.org). Our other child is a Construction Management major at KSU's Southern Poly / Marietta campus. We are a soccer and Cross Country (XC) family who play, coach, and referee soccer or run for fun most every day. For several years, our family has volunteered (and played with the dogs and cats) at Etowah Valley Humane Society in Cartersville, GA.
- MSSQLTips Awards: Champion (100+tips) - 2016 | Author of the Year - 2015 | Author Contender - 2014, 2016-2021
SSAS 2012 Top and Bottom Functions
I have used the Top and Bottom T-SQL functions in SQL Server; do the same functions exist in the SQL Server Analysis Services (SSAS) or MDX? If so, how do they work? Can you provide some examples? Check out this tip to learn more.
SSAS Time Account Dimension Intelligence
SSAS includes Time, Account, and Dimension Business Intelligence Wizards. In this tip we cover what these functions do and how they could be used.
SSAS 2012 Standard Deviation Functions
Learn about Standard Deviation Functions that can be used with SQL Server Analysis Services.
SQL Server 2012 Analysis Services (SSAS) DMVs
What are the SQL Server Analysis Services (SSAS) 2012 DMV's and how can they be used?
SQL Server 2012 Analysis Services XMLA
Cube developer often flippantly use the term XMLA in there discussion of maintaining, scripting, backing up, and restoring cubes and other SSAS objects; what exactly is XMLA and how can it be used? Check out this tip to learn more.
SSRS ReportItems Collection
What is SQL Server Reporting Services 2012 (SSRS) ReportItems collection and how do I use it? Are there any restrictions on its use? Check out this tip to learn more.
SSAS Partition Maintenance and Processing
Now that I created several SSAS partitions, what do I need to do to process and maintain them? What options are available to improve my processing time? In this tip we look at different tips and techniques that can be used.
SSRS data specific report drill through to Bing Maps
In a previous post on SQL Server Reporting Services (SSRS), internal drill own and drill through actions were discussed. What options are available to drill through to external sites such as Bing or Google Maps or a Currency Rate lookup. In this tip we l
SSAS Period over Period Variance Analysis
Often when working with OLAP cubes, the main access point will be an Excel pivot table. While utilizing OLAP cubes, end users will frequently want to compare two values from different periods in order to quantify some variance analysis processes; howeve
SSAS-Lead, Lag, OpeningPeriod, ClosingPeriod Time Related Functions
Working with SSAS time related accounting functions can be tricky. SQL Server 2012 now offers Lag and Lead Windows functions which are available in SSAS. In this tip we take a look at some examples of how to use these functions.
SSRS Using Multi-value Parameters
After working with SQL Server Reporting Services ( SSRS ) for a time, eventually a report user will want to select more than one value for a parameter. In this tip we show how this can be done.
Graphing the Sine Function in SSRS
Can a function, such as the sine or cosine trigonometry functions, be graphed in SQL Server Reporting Services (SSRS). This particular question was recently asked in the Question and Answer section of MSSQLTips.com. So can it? If so, how do we graph it
SSRS 2012 Drilldown Features
SQL Server Reporting Services (SSRS) 2012 includes many drilldown / drillthrough features. What options are available for creating reports with these features? In this tip we will look at the different options and how they can be used.
What’s New in SQL Server 2012 Reporting Services
SQL Server Reporting Service 2012 (SSRS) is now available. In this tip we look at some enhancements and new features in SQL Server Reporting Services.
SSRS 2012 Permissions
As you begin developing reports for deployment to a Report Server, what security considerations need to be taken into account in order to grant users access to run a report. In this tip we look at both SSRS and SQL Server permissions.
Configuring permissions for SSAS
You have created your first SSAS database and cube. Now you want to secure the cube and related dimensions. In this tip we look at different options for setting security permissions.
SSRS Textbox Tips and Tricks
As you begin to work with SQL Server Reporting Services, you find may the need to utilize some more advanced options for cells and textboxes that get dropped onto Tablixes. What options are available? Check out this tip to learn more.
SSRS 2008 R2 Report Server Database Helpful Queries
The ReportServer database stores all the details concerning the SSRS datasources, datasets, and reports and includes details about their parameters, location, run statistics, subscriptions, and queries. Much of the information needed to maintain SSRS can
SQL Server Report Server 2008 R2 Execution Log Reports
As you design and deploy more and more reports to your Report Server, how do you review which reports are being run, how often, and how long the reports take to render? In this tip we look at how to create a report to get this information.
Developing a SSRS report using a SSAS Data Source
Learn how to create SSRS reports with SSAS data effectively, starting from data sources to the report layout process.
SSRS Report with Teradata Data Sources
Although you would prefer to use SQL Server only, your organization has data in a large list of different databases including TeraData. In this tip we cover how to use SQL Server Reporting Services with a Teradata data source.
Creating a Reporting Service Report Template
You have several report developers working on a large scale SSRS 2008R2 project and they are generating report after report. You would like all the reports to have the same look and feel, at least on the header and footer sections, and even include som
Build a SSAS Data Dictionary
Your SQL Server Analysis Services cube (All tips | tutorial) has a large number of dimensions, attributes, hierarchies, and measures, but the end users are not sure of the meaning of some of the items. How can you generate a data dictionary with a SQL Se