-
dimensions and measures
- dimension/measure group relationship
-
configure dimensions
- attribute
- hierarchies
- Attribute Relationships
- new custom attributes
-
schema
- star schema
-
measures
- appropriate aggregation functions
- format measures
- Logically group measures
-
cube
- non-additive
- semi-additive
- perspectives
-
Linked
Measure
Group
- read-only.
- delete and recreate all
linked measure groups
- inability to customize
a linked measure directly
- cannot create a linked
measure group from
another linked measure
group
- cannot add or remove measures
- Writeback is not supported
- multiple many-to-many
relationship not supported
-
Roles
-
Permissions
- None
- Read
- Read and Process
- Process
- Administrator
-
Overview
-
Remote SSAS
Process
- A secondary DB store remote partitions for only one master DB
- master database can use multiple secondary databases