SSAS (SQL Server Analysis Services) Tabular application visualizes semantic models scanned from Power Workspace XMLA endpoint or databases scanned from local SQL Server Analysis Services running in tabular mode.
Default hierarchy
In the chart below, you will find the organizational structure of SSAS Tabular objects. Objects are represented in green and folders are in yellow.
Object types
Dawiso ingests the following objects from the semantic model or database:
Database
Maps to Database object type.
| Source Attribute | Target Attribute in Dawiso |
|---|---|
| name | Name |
| annotations | Annotations |
| id | ID |
Data Source
Maps to Data Source object type.
| Source Attribute | Target Attribute in Dawiso |
|---|---|
| name | Name |
| annotations | Annotations |
Table
Maps to Table object type.
| Source Attribute | Target Attribute in Dawiso |
|---|---|
| name | Name |
| annotations | Annotations |
| is_hidden | Is hidden |
| modified_time | Modified at |
Table Column
Maps to Table Column object type.
| Source Attribute | Target Attribute in Dawiso |
|---|---|
| name | Name |
| annotations | Annotations |
| data_type | Data Type |
| is_hidden | Is hidden |
| modified_time | Modified at |
| type | Type |
Table Measure
Maps to Table Measure object type.
| Source Attribute | Target Attribute in Dawiso |
|---|---|
| name | Name |
| annotations | Annotations |
| is_hidden | Is hidden |
Table Hierarchy
Maps to Table Hierarchy object type.
| Source Attribute | Target Attribute in Dawiso |
|---|---|
| name | Name |
| annotations | Annotations |
| is_hidden | Is hidden |
Table Partition
Maps to Table Partition object type.
| Source Attribute | Target Attribute in Dawiso |
|---|---|
| name | Name |
| annotations | Annotations |
| type | Type |
Relationship
Maps to Relationship object type.
| Source Attribute | Target Attribute in Dawiso |
|---|---|
| name | Name |
| annotations | Annotations |
| state | State |
| type | Type |
Role
Maps to Role object type.
| Source Attribute | Target Attribute in Dawiso |
|---|---|
| name | Name |
| annotations | Annotations |
Role Member
Maps to Role Member object type.
| Source Attribute | Target Attribute in Dawiso |
|---|---|
| name | Name |
| annotations | Annotations |
| id | ID |
| type | Type |
Role Table Permission
Maps to Role Table Permission object type.
| Source Attribute | Target Attribute in Dawiso |
|---|---|
| name | Name |
| annotations | Annotations |