Subscribe to:
Posts (Atom)
My Articles
Design
Fact table design for “State Workflow Analysis”: Analysis Services Dimensional modeling
Aggregation design: useful tips
Trouble / Troubleshooting
Analysis Services 2005 migration tool: Custom member formula issues in migrated database
MDX
NextAnalytics and MDX : Part 1 - Swap Cells with Row Labels
Selecting dimension's default member based on a member property
Sorting members on member codes / member properties
Time Dimension: How to set Default Member to Current Month
Setting dynamic default member in dimension X based on the current member of dimensions Y
ADOMD.NET
Code : utility code for converting cellset to a data table
Others
Google specialized search for Analysis Services and MDX web resources integrated in my blog

Blogroll
-
-
Dynamically Changing A Chart Axis In Power BI Using Bookmarks And Buttons - A very common requirement when building Power BI reports is to allow the end user to change what is displayed on a chart axis dynamically. A lot of people ...2 days ago
-
-
DAX Studio 2.7.2 Released - Originally posted on: http://ferventcoder.com/darrengosbell/archive/2018/02/13/dax-studio-2.7.2-released.aspx The lastest update for DAX Studio is now li...2 months ago
-
Introduction to Apache Spark 2.0 - A Primer on Spark 2.0 Fundamentals and Architecture I’m proud to post that my O’Reilly video series Introduction to Apache Spark 2.0: A Primer on Spark 2.0...8 months ago
-
Automating Partition Creation - By Bryan C. Smith The use of multiple partitions per measure group is promoted to improve both query and processing performance as well as the overal...10 years ago
-
-
DAX Optimization Examples – SQLBits 2018 - How do you optimize a DAX expression? In this session, Alberto Ferrari analyzes some DAX expressions and Tabular models and, through the usage of DAX Studi...6 days ago
-
Good Bye BI - "Every new beginning comes from some other beginning's end" ( Seneca ) I spent big chunk of my professional career working on what we call today BI. From P...8 years ago
-
SQL Server VLDB in Azure: DBA Tasks Made Simple - Reviewed by: Rajesh Setlem, Mike Weiner, Xiaochen Wu With thanks to Joey D’Antoni (blog) for asking a great question that prompted this article. As any exp...2 months ago
-
-
DAX Code Snippet: Year To Date in Charts - This short blog post tries to show the different ways to solve the same problem in DAX and in MDX. If you look at the picture you can see two ways of prese...2 years ago
-
