-
Small cell value suppression in SSAS cube output
I am currently working on project building information system for one of the provincial health registries. Patient data protection and privacy is one of the main requirements that touched all parts of the information system including standard reports and SSAS cubes. One of the requirements I’ve encountered while working with SSAS cubes was that measure…
-
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: ssas
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
