SQL Server Analysis Services
E277012
SQL Server Analysis Services is a Microsoft server-based data analysis and business intelligence platform used to create and manage OLAP cubes and data mining models for advanced analytics and reporting.
All labels observed (6)
| Label | Occurrences |
|---|---|
| SQL Server Analysis Services canonical | 9 |
| Analysis Services | 2 |
| MDX | 1 |
| Microsoft SQL Server Analysis Services | 1 |
| SQL Server Analysis Services (limited or basic, depending on version) | 1 |
| SSAS | 1 |
Statements (55)
| Predicate | Object |
|---|---|
| instanceOf |
Microsoft server product
ⓘ
business intelligence platform ⓘ online analytical processing server ⓘ |
| abbreviation |
SQL Server Analysis Services
self-linksurface differs
ⓘ
surface form:
SSAS
|
| developer | Microsoft ⓘ |
| featureOf |
SQL Server
ⓘ
surface form:
SQL Server Enterprise Edition
Standard Edition ⓘ
surface form:
SQL Server Standard Edition
|
| hasComponent |
Power Pivot
ⓘ
surface form:
PowerPivot for SharePoint (historical)
multidimensional mode ⓘ tabular mode ⓘ |
| integratesWith |
Azure Analysis Services
ⓘ
Excel ⓘ
surface form:
Microsoft Excel
Power BI ⓘ SQL Server Integration Services ⓘ SQL Server Reporting Services ⓘ |
| introducedIn |
SQL Server
ⓘ
surface form:
SQL Server 2000
|
| partOf |
SQL Server
ⓘ
surface form:
Microsoft SQL Server
|
| predecessor |
Analysis Services Multidimensional
ⓘ
surface form:
OLAP Services
|
| provides |
advanced analytics
ⓘ
business intelligence ⓘ calculated measures ⓘ data aggregation ⓘ data modeling ⓘ key performance indicators ⓘ partitions ⓘ perspectives ⓘ row-level security ⓘ security roles ⓘ |
| runsOn | Windows Server ⓘ |
| supports |
DAX
ⓘ
DMX ⓘ MDX ⓘ XMLA ⓘ data mining ⓘ multidimensional modeling ⓘ online analytical processing ⓘ tabular modeling ⓘ |
| supportsFeature |
aggregations
ⓘ
drillthrough ⓘ hierarchies ⓘ partitioning ⓘ proactive caching ⓘ role-based security ⓘ time intelligence ⓘ translations ⓘ |
| supportsStorageMode |
HOLAP
ⓘ
MOLAP ⓘ ROLAP ⓘ |
| usedFor |
data warehousing analytics
ⓘ
enterprise reporting ⓘ multidimensional analysis ⓘ self-service BI ⓘ |
| uses |
OLAP cubes
ⓘ
data mining models ⓘ tabular models ⓘ |
Referenced by (15)
Full triples — surface form annotated when it differs from this entity's canonical label.
subject surface form:
Microsoft SQL Server Standard Edition
this entity surface form:
SQL Server Analysis Services (limited or basic, depending on version)
this entity surface form:
Analysis Services
this entity surface form:
Analysis Services
this entity surface form:
Microsoft SQL Server Analysis Services
this entity surface form:
MDX
SQL Server Analysis Services
→
abbreviation
→
SQL Server Analysis Services
self-linksurface differs
ⓘ
this entity surface form:
SSAS