Skip to content

Extended Property#

Bases: SsasRenameRecord

TBD.

SSAS spec: Microsoft

Source code in pbi_core/ssas/model_tables/extended_property/extended_property.py 
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
class ExtendedProperty(SsasRenameRecord):
    """TBD.

    SSAS spec: [Microsoft](https://learn.microsoft.com/en-us/openspecs/sql_server_protocols/ms-ssas-t/5c1521e5-defe-4ba2-9558-b67457e94569)
    """

    object_id: int
    object_type: ObjectType
    name: str
    type: ObjectType
    value: Json[ExtendedPropertyValue]

    modified_time: datetime.datetime

    _commands: RenameCommands = PrivateAttr(default_factory=lambda: SsasCommands.extended_property)

    def object(self) -> "SsasTable":
        """Returns the object the property is describing."""
        mapper: dict[ObjectType, Callable[[int], SsasTable]] = {
            ObjectType.MODEL: lambda _x: self.tabular_model.model,
            ObjectType.DATASOURCE: self.tabular_model.data_sources.find,
            ObjectType.TABLE: self.tabular_model.tables.find,
            ObjectType.COLUMN: self.tabular_model.columns.find,
            ObjectType.ATTRIBUTE_HIERARCHY: self.tabular_model.attribute_hierarchies.find,
            ObjectType.PARTITION: self.tabular_model.partitions.find,
            ObjectType.RELATIONSHIP: self.tabular_model.relationships.find,
            ObjectType.MEASURE: self.tabular_model.measures.find,
            ObjectType.HIERARCHY: self.tabular_model.hierarchies.find,
            ObjectType.LEVEL: self.tabular_model.levels.find,
            ObjectType.KPI: self.tabular_model.kpis.find,
            ObjectType.CULTURE: self.tabular_model.cultures.find,
            ObjectType.LINGUISTIC_METADATA: self.tabular_model.linguistic_metadata.find,
            ObjectType.PERSPECTIVE: self.tabular_model.perspectives.find,
            ObjectType.PERSPECTIVE_TABLE: self.tabular_model.perspective_tables.find,
            ObjectType.PERSPECTIVE_HIERARCHY: self.tabular_model.perspective_hierarchies.find,
            ObjectType.PERSPECTIVE_MEASURE: self.tabular_model.perspective_measures.find,
            ObjectType.ROLE: self.tabular_model.roles.find,
            ObjectType.ROLE_MEMBERSHIP: self.tabular_model.role_memberships.find,
            ObjectType.TABLE_PERMISSION: self.tabular_model.table_permissions.find,
            ObjectType.VARIATION: self.tabular_model.variations.find,
            ObjectType.EXPRESSION: self.tabular_model.expressions.find,
            ObjectType.COLUMN_PERMISSION: self.tabular_model.column_permissions.find,
            ObjectType.CALCULATION_GROUP: self.tabular_model.calculation_groups.find,
            ObjectType.QUERY_GROUP: self.tabular_model.query_groups.find,
        }
        return mapper[self.object_type](self.object_id)

    @classmethod
    def _db_command_obj_name(cls) -> str:
        return "ExtendedProperties"

object #

object() -> SsasTable

Returns the object the property is describing.

Source code in pbi_core/ssas/model_tables/extended_property/extended_property.py 
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
def object(self) -> "SsasTable":
    """Returns the object the property is describing."""
    mapper: dict[ObjectType, Callable[[int], SsasTable]] = {
        ObjectType.MODEL: lambda _x: self.tabular_model.model,
        ObjectType.DATASOURCE: self.tabular_model.data_sources.find,
        ObjectType.TABLE: self.tabular_model.tables.find,
        ObjectType.COLUMN: self.tabular_model.columns.find,
        ObjectType.ATTRIBUTE_HIERARCHY: self.tabular_model.attribute_hierarchies.find,
        ObjectType.PARTITION: self.tabular_model.partitions.find,
        ObjectType.RELATIONSHIP: self.tabular_model.relationships.find,
        ObjectType.MEASURE: self.tabular_model.measures.find,
        ObjectType.HIERARCHY: self.tabular_model.hierarchies.find,
        ObjectType.LEVEL: self.tabular_model.levels.find,
        ObjectType.KPI: self.tabular_model.kpis.find,
        ObjectType.CULTURE: self.tabular_model.cultures.find,
        ObjectType.LINGUISTIC_METADATA: self.tabular_model.linguistic_metadata.find,
        ObjectType.PERSPECTIVE: self.tabular_model.perspectives.find,
        ObjectType.PERSPECTIVE_TABLE: self.tabular_model.perspective_tables.find,
        ObjectType.PERSPECTIVE_HIERARCHY: self.tabular_model.perspective_hierarchies.find,
        ObjectType.PERSPECTIVE_MEASURE: self.tabular_model.perspective_measures.find,
        ObjectType.ROLE: self.tabular_model.roles.find,
        ObjectType.ROLE_MEMBERSHIP: self.tabular_model.role_memberships.find,
        ObjectType.TABLE_PERMISSION: self.tabular_model.table_permissions.find,
        ObjectType.VARIATION: self.tabular_model.variations.find,
        ObjectType.EXPRESSION: self.tabular_model.expressions.find,
        ObjectType.COLUMN_PERMISSION: self.tabular_model.column_permissions.find,
        ObjectType.CALCULATION_GROUP: self.tabular_model.calculation_groups.find,
        ObjectType.QUERY_GROUP: self.tabular_model.query_groups.find,
    }
    return mapper[self.object_type](self.object_id)