My SQL Server Reporting Services database and server are secure and only used internally; do I really need to backup the SSRS keys? Also, is there a command line tool to handle this process? In this tip we look at how to use the rskeymgmt command line to
In this video tip we cover using the tool to deploy a report from your local directory to a report server. The utility has two required arguments:
Often, as a SSRS developer, you will find that you have to be creative in order to get a report to display your data in just the exact way the report consumers want. Unfortunately, getting the data in the format needed is never easy and often times, getti
The SQL Server Reporting Services RS.EXE utility is a command line utility that can perform many scripted operation related to SQL Server Reporting Services (SSRS). In this video tip we cover using the tool to export a report from the ReportServer to loca
What is the difference between the KeyColumn, the NameColumn, and the ValueColumn for a dimension attribute in SQL Server Analysis Services? How do they affect the data presented to the end user? When should you use the KeyColumn, the NameColumn, and th
What is the SQL Server Reporting Services RS.EXE utility? How can we use it with SSRS? Check out this tip to learn more.
The source table or view for my cube requires some structural changes including data type and data lengths. How does this affect my SSAS Data Source View (DSV) and ultimately my cube?
How can report group variables be referenced in SQL Server Reporting Services (SSRS) and in what way are they used? Are there any limitations with Report and Group variables in SSRS? Can you show me an example of using these SSRS variables? When would
What are SQL Server Reporting Services Custom Code Assemblies? Why would I want to use them? Check out this tip to learn more.
What are SQL Server Analysis Services Perspectives? What do they do and how can they be used? Check out this tip to learn more.
I want to embed code into my SQL Server Reporting Servers (SSRS) to allow special formatting for report output. How do I implement and deploy this code and what functionality can use this embedded code?
I recently used the SSAS TopCount feature to get the top 10 list of products within my products cube. How can I create a dynamic single rollup for the rest of the values, i.e. an All Other values, so that my total sales number is the true total and not j
I am using Excel to access my SQL Server Analysis Services cubes and I want to give end users additional drill down functionality. In this tip we cover some of the different Excel drill down actions that are available for SQL Server Analysis Services (SS
The WITH keyword in SQL Server relational engine creates a Common Table Expression (or CTE); what does it do in SQL Server Analysis Services (SSAS)? Check out this tip to learn more.
The Case statement exists in many programming languages and it is also available when writing MDX for SQL Server Analysis Services cubes. There are two types of Case statements that can be used in MDX; the simple case and the search case. In this tip we
What is discretization and how is it used in SQL Server Analysis Services? What are its advantage and disadvantages? In this tip we cover this topic and show the various options.
Is it possible to use XML data and files as a source for SQL Server Reporting Services (SSRS) reports? Are there any limitations to using an XML source? Read this tip to learn how this can be done.
In this tip we look at how to import XML documents into SQL Server using SSIS. We will walk through an example and also show some of the potential issues and how to resolve them.
Sometimes when working with SQL Server Analysis Services (SSAS) and MDX queries, the ordering does not seem to work. Is this situation a bug or do I need to adjust my MDX queries? In this tip, we look at different ways you can sort your output.
As you work with large scale SQL Server Integration Services ETL processes and sequences, you are bound to have to work with UTF-8 encoded text files. Without proper handling, UTF-8 / Unicode characters can cause havoc with your SSIS load tasks. What are
In this tip we cover some of the best practices and methods for documentation within an SSIS package.
What configuration files are included with SSRS and how should I modify them? In this tip we go over some possible changes for these configuration files: RSReportServer.config, ReportingServicesService.exe.config, and RSReportDesigner.config.
There are new date related functions available in DAX for the Tabular Model version of SQL Server Analysis Service (SSAS) and in this tip we cover how they can be used.
The security needed to install and run SQL Server Reporting Services Report Builder seems to have a hodgepodge of different permissions and rules. What are the different security permissions needed to install and run SQL Server Reporting Services Report B