Tabular or MultiDimensional

Last updated 3 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
Transcription
  • More than 100.000.000.000 rows or more than 5 Terrabytes of data ? No. Yes.
  • 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 ? I dont mind building multiple date dimensions. Yes.
  • 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 ? No. Yes.
  • Multi Dimensional.
  • Do you need Custom Assemblies in your model ? Yes. No.
  • Multi Dimensional.
  • Are you in a financial business with a lot of static reports following multiple Chart of accounts with unary operators ? Yes. No.
  • Multi Dimensional.
  • SELF SERVICE BI ? Yes. No.
  • Multi Dimensional.
  • Tabular.

Related Topics