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
-
-
Finding The Size Of All Of The Columns Touched By A DAX Query - I had meant to follow up my recent post on how to find the columns touched by a DAX query by writing one on how to use this technique to find the size of t...3 days ago
-
-
Power BI – creating dynamic per recipient subscriptions for paginated reports with multi-value parameters - At the time of writing this post there is no built-in support for creating dynamic per recipient subscriptions for paginated reports if your report has any...3 weeks ago
-
How Apache Spark™ performs a fast count using the parquet metadata - A common question I run into is how does Apache Spark™ perform fast counts against Parquet files. TL;DR: Spark is able to read the parquet metadata witho...9 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...17 years ago
-
-
New composite models in Power BI: A milestone in Business Intelligence - Power BI sets a new milestone in Business Intelligence: Marco describes the importance of new composite models in an article, and Alberto shows them in act...3 years 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...14 years ago
-
SQLCAT at PASS Summit 2018 - This week in Seattle, PASS Summit 2018 will be happening for the twentieth time. As for many years...6 years 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...9 years ago
-