Analysis Services Multidimensional
E236856
Analysis Services Multidimensional is a Microsoft SQL Server technology for building and querying OLAP cubes that support complex analytical and business intelligence workloads.
All labels observed (3)
| Label | Occurrences |
|---|---|
| Analysis Services Multidimensional canonical | 1 |
| OLAP Services | 1 |
| SQL Server Analysis Services Multidimensional | 1 |
Statements (49)
| Predicate | Object |
|---|---|
| instanceOf |
Microsoft SQL Server component
ⓘ
OLAP server technology ⓘ business intelligence platform ⓘ |
| administrationTool | SQL Server Management Studio ⓘ |
| connectsWith |
Excel
ⓘ
surface form:
Microsoft Excel
Power BI ⓘ
surface form:
Power BI (via live connection and gateways)
SQL Server Reporting Services ⓘ
surface form:
Reporting Services
|
| contrastedWith |
SQL Server Analysis Services Tabular
ⓘ
surface form:
Analysis Services Tabular
|
| deploymentModel | on-premises ⓘ |
| designTool | SQL Server Data Tools ⓘ |
| developedBy | Microsoft ⓘ |
| introducedIn | early versions of Microsoft SQL Server Analysis Services ⓘ |
| partOf |
SQL Server
ⓘ
surface form:
Microsoft SQL Server
SQL Server Analysis Services ⓘ
surface form:
Microsoft SQL Server Analysis Services
|
| queryLanguage |
SQL Server Analysis Services
ⓘ
surface form:
MDX
|
| runsOn | Windows Server ⓘ |
| status | mature and feature-rich but not the strategic growth direction compared to tabular models ⓘ |
| supports |
HOLAP storage
ⓘ
MDX queries ⓘ MOLAP storage ⓘ OLAP cubes ⓘ ROLAP storage ⓘ XMLA protocol ⓘ aggregations ⓘ attribute hierarchies ⓘ calculated members ⓘ cell-level security ⓘ data mining models ⓘ dimension security ⓘ hierarchies ⓘ key performance indicators ⓘ linked objects ⓘ measure groups ⓘ multidimensional data models ⓘ named sets ⓘ parent-child hierarchies ⓘ partitions ⓘ perspectives ⓘ proactive caching ⓘ remote partitions ⓘ security roles ⓘ time intelligence calculations ⓘ translations ⓘ writeback ⓘ |
| usedFor |
ad hoc analysis
ⓘ
complex analytical workloads ⓘ enterprise business intelligence ⓘ financial reporting ⓘ management dashboards ⓘ |
Referenced by (3)
Full triples — surface form annotated when it differs from this entity's canonical label.
this entity surface form:
SQL Server Analysis Services Multidimensional
this entity surface form:
OLAP Services