Adding PerformancePoint Dashboard Content to SharePoint
Microsoft SharePoint Server 2010 provides several options for creating Dashboards using PerformancePoint content.
The first option is to implement the...
2013-02-11
3,570 reads
Salvo(z) SQL
SQL Server Analysis Services Tabular KPIs
A few weeks ago, I wrote a blog post that discusses implementing KPIs in SQL Server Analysis Services Multidimensional. For...
2013-02-04
2,616 reads
Currency Conversion in Tabular Model Using DAX
Roughly a year ago, I implemented currency conversion logic in multidimensional cubes using measure expressions (as well as using the...
2013-01-28
3,859 reads
Re-writing MDX calculated members as DAX measures
I have been working on re-creating some logic in a tabular cube that was originally implemented in multidimensional. This involved...
2013-01-21
1,352 reads
SQL Server Analysis Services KPIs
Key Performance Indicators (KPIs) are measurements used to gauge business performance against quantifiable goals. SQL Server Analysis Services provides functionality...
2013-01-15 (first published: 2013-01-14)
6,556 reads
Querying and Optimizing DAX
Over the past few weeks, I’ve been watching some videos from this year’s PASS Summit. One of the presentations I...
2013-01-02
3,978 reads
Optimizing Your BI Semantic Model for Performance and Scale
Here’s my notes from the ‘Optimizing Your BI Semantic Model for Performance and Scale (BIA-402-M)’ session at PASS Summit, presented...
2012-12-11
3,010 reads
SSIS: Character Replacement Using the Script Component
When cleansing data from source systems to store in a data mart or warehouse, we often need to remove or...
2012-12-08
1,756 reads
T-SQL Tuesday: What Does the SQL Community Mean to You?
Today is T-SQL Tuesday #36, hosted by Chris Yates (B | T). The topic this month is ‘What Does the SQL...
2012-11-13
789 reads
Book Review: SQL Server 2012 Analysis Services The BISM Tabular Model
I will start off by saying, whenever I see the names Marco Russo, Alberto Ferrari and Chris Webb on a...
2012-11-12
1,886 reads
Blogs
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Forums
Optimism Without Illusion or Why AI Needs Blunt Technologists
Comments posted to this topic are about the item Optimism Without Illusion or Why...
SSIS with VS2022 64/32 issue with Excel files
Hi all, I'm trying to do classic scenario for loading multiple Excel files into...
Case part is sloooooow
Hi So the case statement is slowing this down - but for the life...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers