Create a Decision Tree

Tabular or MultiDimensional

19

0

Last updated 8 years ago

First published 11 October, 2016

How to choose for Tabular or Multi Dimensional Analysis Services model

ssas,tabular,multidimensional,multi

English Rating: ALL ages Shortest path: 3 nodes Longest path: 19 nodes Possible solutions: 10

Freek Heuff

1

0

Follow

More than 100.000.000.000 rows or more than 5 Terrabytes of data ? Yes. No.
MultiDimensional.
Do you have a lot of memory or a lot of diskspace ? Lots of diskspace. Enough memory available.
Multi Dimensional.
Do you need role playing dimensions ? Yes. I dont mind building multiple date dimensions.
Multi Dimensional.
Do you need Writeback support? Yes. No.
Multi Dimensional.
Do you need native Parent-Child support ? No, I don't need it or I'll build complex calculations myself. Yes.
Multi Dimensional.
Actions are a must have ? Yes. No.
Multi Dimensional.
Do you need Custom Assemblies in your model ? No. Yes.
Multi Dimensional.
Are you in a financial business with a lot of static reports following multiple Chart of accounts with unary operators ? No. Yes.
Multi Dimensional.
SELF SERVICE BI ? No. Yes.
Multi Dimensional.
Tabular.