Skip to content
Chris Koester

Data Analytics Consultant in Indianapolis, Indiana

Primary Navigation Menu
Menu
  • Home
  • About
  • Contact
  • Privacy Policy

Reporting Services

Ludicrous Speed

Optimized Multi-value DAX Parameters in SSRS

2017-10-18
By: Chris Koester
On: 2017-10-18
In: Reporting Services, SSAS Tabular
With: 0 Comments

This post shows how you can generate optimized multi-value DAX parameters in SSRS and achieve greater performance compared to the DAX PathContains function. This will be a short post that provides the SSRS expression to convert multiple SSRS parameters into a double-pipe delimited string for use in a DAX query. In other words, the goal is to use the DAX OR operator (||) instead of the PathContains function. I’m assuming the reader has experience with SSRS, so not all steps will be shown. Imagine that you have multi-value parameter that allows users to select multiple month – year values such as Sep 2017, Oct 2017, etc. TheRead More →

Extracting Friendly Labels from MDX in Reporting Services

2014-08-13
By: Chris Koester
On: 2014-08-13
In: Reporting Services
With: 1 Comment

In Reporting Services (SSRS), I found myself in a situation where I needed to extract friendly labels from MDX member keys. I had a fiscal year parameter being passed to another report via a drill through action, and I needed to display the selected fiscal years on the drill through report. So I had to convert something like [Fiscal Period].[Fiscal Year].&[2014], [Fiscal Period].[Fiscal Year].&[2013] to “Fiscal Year: 2014, 2013”. There are a couple of ways of doing this. If your labels always contain the same number of characters, you can use the MID function as shown later. I have multiple multi-value parameters being passed, however, so I wanted to be able toRead More →

Follow Me

  • Twitter

Topics

Analysis Services API Azure Azure Blob Storage Azure Functions big data C# code CSV Data integration DAX duplicates Excel HDInsight Hive JSON M MDX OAuth OPENJSON Parameters Power BI Power Map Power Pivot Power Query PowerShell REGEX Reporting Services REST SQL Server SSAS SSAS Tabular SSIS SSRS Stored Procedure Streaming Temboo text TMSL TOM TPC Twitter usgs VB xml

Certifications

MCSA: SQL 2016 Business Intelligence Development

Recent Posts

  • Generate Big Datasets with Hive in HDInsight
  • Delete SSAS Tabular Partitions with C#
  • Retrieve JSON Data from SQL Server using a Stored Procedure and C#
  • Load JSON into SQL Server Using a Stored Procedure and C#
  • Push Performance Counter Data into a Power BI Streaming Dataset

Categories

  • Big Data
  • Data Integration
  • Power BI
  • Power Query
  • PowerShell
  • Reporting Services
  • SSAS Tabular

Archives

  • March 2019
  • May 2018
  • March 2018
  • December 2017
  • November 2017
  • October 2017
  • August 2017
  • June 2017
  • March 2017
  • January 2017
  • December 2016
  • July 2016
  • May 2016
  • April 2016
  • December 2015
  • July 2015
  • February 2015
  • August 2014

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Privacy Policy Designed using Responsive Brix WordPress Theme. Powered by WordPress.