A few weeks ago, I wrote a blog post that discusses implementing KPIs in SQL Server Analysis Services Multidimensional. For those of you who are unfamiliar with the KPI functionality in the Multidimensional model, the blog post can be found here. I’m now going to discuss the KPI functionality… Read more
Roughly a year ago, I implemented currency conversion logic in multidimensional cubes using measure expressions (as well as using the Leaves function in MDX). I documented the implementation in a few blog posts:
I have now also implemented currency… Read more
I have been working on re-creating some logic in a tabular cube that was originally implemented in multidimensional. This involved creating some DAX measures that return the same results as the MDX calculated member counterparts in the multidimensional cube. I thought that some individuals who are familiar with MDX in… Read more
Key Performance Indicators (KPIs) are measurements used to gauge business performance against quantifiable goals. SQL Server Analysis Services provides functionality to define KPI calculations and associate KPIs to measure groups in a multidimensional cube.
SQL Server Analysis Services KPIs consist of the following properties:
- Value Expression: An MDX expression that…
Over the past few weeks, I’ve been watching some videos from this year’s PASS Summit. One of the presentations I watched is ‘Querying and Optimizing DAX’ (BIA-321-S) by Alberto Ferrari. I took some notes during this presentation and am sharing them here.
DAX as a Query Language
- DAX queries can…
Here’s my notes from the ‘Optimizing Your BI Semantic Model for Performance and Scale (BIA-402-M)’ session at PASS Summit, presented by Akshai Mirchandani and Allan Folting of Microsoft.
Tabular Design Principles
- Speed and performance
- Optimize query performance over processing performance, focus on end-user experience.
- Accommodate changes without forcing reload, if…
When cleansing data from source systems to store in a data mart or warehouse, we often need to remove or replace characters. I recently used the Script Component in SSIS to cleanse some ticket tracking data and thought I’d write a blog post that outlines the implementation.
The data from… Read more
Today is T-SQL Tuesday #36, hosted by Chris Yates (B | T). The topic this month is ‘What Does the SQL Community Mean to You?’ I’m fortunate to live in an area with a SQL PASS chapter (MadPASS) and have attended many chapter meetings as… Read more
I will start off by saying, whenever I see the names Marco Russo, Alberto Ferrari and Chris Webb on a SQL Server Analysis Services book….I know it will good. This book is no exception! I can say with 100% honesty that this is one of the best technical books I’ve… Read more
The DAX IsFiltered function returns True when <columnName> is filtered directly and false if there is no direct filter on the column. The syntax is IsFiltered(<columnName>). More details regarding this function can be found on MSDN.
I recently used the IsFiltered function to create a measure that is only… Read more
- Introducing Microsoft SQL Server 2012
- 31 Days of SSIS with SQL Server 2008 R2
- SQL Server Interview Questions and Answers
- Performance Tuning with SQL Server Dynamic Management Views
- SQL Queries Joes to Pros: SQL Query Techniques For Microsoft SQL Server 2008, Volume 2
- SQL Architecture Basics Joes 2 Pros: Core…
An error message for one of our many SQL Azure databases was brought to my attention today.
Msg 40628, Level 16, State 1, Line 1
Failed to update database ‘UAT_US_SS02′ because the database is read-only. Please contact your Azure service owner. There may be billing related issues with your Azure…
This past weekend I attended SQL Saturday #149 in Minneapolis with my husband Adam, my brother Chris and another member of our local PASS chapter. Adam has his pilot’s license so we flew to Minneapolis the morning of the event. It was a beautiful and warm fall day – perfect… Read more
By Jennifer Salvo
Today is T-SQL Tuesday #34 hosted by Rob Volk (B, T). This month’s topic is ‘Help! I Need Somebody’ inspired by The Beatles. The challenge is to write about a person, community or resource that helped you when you were stuck on a SQL… Read more
The recommended location for the tempDb on an Azure virtual machine, is the non-persisted D: drive. This drive is actually a hard drive connected to the underlying physical hardware, so it should offer better performance then the persisted data and OS disks. The persisted disks are located on Azure Blob… Read more
With fall quickly approaching, I thought this would be an ideal time to set some personal goals for the upcoming year. I hope to generate momentum in fall and winter and get a good start on this list:
- Write three blog posts per month
- Participate in TSQLTuesday and Meme15…
Over the past few years, Adam and I have won several books at the local MadPASS chapter meetings. I’ve intended to write a book review for quite awhile and thought I’d start off with this book for several reasons:
It can easily be read from cover-to-cover. This book is organized…
This month’s Meme15 topic is ‘Top 5 Reasons I Like My Job’. A little over a year ago, I started working as a Business Intelligence developer at Trek Bikes. Working at Trek has been a great experience and I feel very fortunate to have the opportunity, so I thought I’d… Read more
Today is T-SQL Tuesday #33 hosted by Mike Fal. The topic is SQL Server – Trick Shots. This assignment involves blogging about a cool process or trick you implemented that is related to SQL Server and the lessons or insight gained from the experience. As a BI developer, I… Read more
My name is Jennifer and I am a Business Intelligence developer at Trek Bicycles. I’ve been a BI developer for a little over a year and work with the Microsoft BI tools: SSIS, SSAS and SSRS. The BI team at Trek consists of 4 analysts (2 in US, 1… Read more