SSRS – Matrix that adds a new column each time 5 rows are filled with data
What if you want a dynamic list of values in a matrix but with a maximum of 5 rows. How
Author: Jorg Klein
Jorg Klein specializes in the Microsoft Azure cloud technologies, Big Data & Analytics, Business Intelligence, Data Warehousing and Data Visualization (Power BI). He delivers technical guidance to organizations in their journey to the cloud.
Jorg has always been active in the communities and has been blogging for more than 10 years on his website jorgklein.com. He likes working with the Microsoft product teams and regularly provides them with feedback as Azure advisor. In 2017 and 2018 Jorg received a Microsoft Most Valuable Professional (MVP) award in the Data Platform area. This award is given to exceptional technical community leaders who share their remarkable passion, real-world knowledge, and technical expertise with others through demonstration of exemplary commitment.
SSRS – Static column headers in a Matrix
How do you create a static column header centered above your dynamic columns? One way to try achieving this is
SSIS – Convert various String date formats to DateTime with the Script Task
The script below is really nice if you need to convert String dates that come in different (unexpected) formats. Just
MCITP – I passed the 70-446 “PRO: Designing a Business Intelligence Infrastructure by Using Microsoft SQL Server 2005” exam!
Today I passed the Microsoft IT Professional(MCITP) 70-446 “PRO: Designing a Business Intelligence Infrastructure by Using Microsoft SQL Server 2005”
SSAS – MOLAP, ROLAP and HOLAP storage types
A big advantage of a BI solution is the existence of a cube. Data and aggregations are stored in a
SSIS – Non-blocking, Semi-blocking and Fully-blocking components
How can you recognize these three component types, what is their inner working and do they acquire new buffers and/or
SSAS – Visualize Attribute Relationships
Complicated attribute relationships are difficult to oversee in SSAS 2005. Microsoft solved this problem in SQL Server 2008 with a
SSRS – Custom expressions for subtotals in a matrix
If you want custom expressions for your subtotals in a matrix, for example to calculate an average instead of the
MCTS – I passed the 70-445 exam!
Last month I passed the MCTS 70-445 BI exam. This makes me one of the 338(October, 2007) Microsoft Certified Technology
SSRS – Invalid row heights, BUG?
Because I got a few reactions regarding the screenshots below (people thought something was wrong with the screenshots) please note
Jorg Klein's Blog 