-
Quick and simple aggregation of Hierarchical Data in SQL Server
Sometimes data containing hierarchies have to be aggregated and total calculated on different levels. The following script will help archive fast calculation of totals on each level of hierarchy.INPUT DATA STRUCTURE AND VALUES0100***Level 1*****$210110…
-
Script to de-normalize Parent – Child Hierarchy
Parent Child data hierarchies are great for storing hierarchical data, however it becomes a major pain when you need to convert hierarchy structure into a flat view (e.g. to be used in reporting or SSAS cubes). While SSAS provide a build…
Toronto, Ontario, Canada
Eastern Time Zone
info@maximconsulting.ca
Category: hierarchy
Archive
Categorise
- aggregation
- audit
- average
- backup
- baseline
- cell value overwrite
- certification
- compliance
- cube
- data driven subscriptions
- data export
- datetime
- de-normalize
- graph
- hierarchy
- local time
- MCSE
- MDX
- Microsoft
- parent-child
- recovery
- restore
- rounding
- script table data
- Small cell value suppression
- ssas
- ssrs
- statistical functions
- stipline
- UTC
