Top Posts & Pages
- MAT (Moving Annual Total), YTD (Year to date) calculation using BottomCount, Tail, Properties function in MDX
- Dynamic Column Mapping in SSIS : Part 1
- Load Excel File Dynamically Into Database Using SQLBulkCopy and GetOleDbSchemaTable in C#
- Slowly Changing Dimension in SSAS Cube
- Restore SQL Server database using SAS from Azure Blob Storage
-
Recent Posts
Categories
Tag Archives: leaf member aggregation
Leaf members do not sum up to parent – Part 2 (parent child hierarchy)
In part 1, we saw user defined hierarchies. For parent child hierarchy, we can use Unary Operator Column. Let’s take the same example from Part1. We have a simple cube with two dimensions called DimCompany and DimCategory, and only one … Continue reading
