Skip to content

Detail Row Definition#

Bases: SsasEditableRecord

TBD.

SSAS spec: Microsoft

Note

Additional details can be found here: SQLBI

Source code in pbi_core/ssas/model_tables/detail_row_definition/detail_row_definition.py 
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
@define()
class DetailRowDefinition(SsasEditableRecord):
    """TBD.

    SSAS spec: [Microsoft](https://learn.microsoft.com/en-us/openspecs/sql_server_protocols/ms-ssas-t/7eb1e044-4eed-467d-b10f-ce208798ddb0)

    Note:
        Additional details can be found here: [SQLBI](https://www.sqlbi.com/articles/controlling-drillthrough-in-excel-pivottables-connected-to-power-bi-or-analysis-services/)

    """

    error_message: Final[str | None] = field(
        eq=False,
        on_setattr=setters.frozen,
    )  # error message is read-only, so should not be edited
    expression: str = field(eq=True)
    object_id: int = field(eq=True)
    object_type: ObjectType = field(eq=True)
    state: Final[DataState] = field(eq=False, on_setattr=setters.frozen, default=DataState.READY)

    modified_time: Final[datetime.datetime] = field(eq=False, on_setattr=setters.frozen, repr=False)

    _commands: BaseCommands = field(default=SsasCommands.detail_row_definition, init=False, repr=False)

    @classmethod
    def _db_type_name(cls) -> str:
        return "DetailRowsDefinition"

    def object(self) -> "Table | Measure":
        match self.object_type:
            case ObjectType.MEASURE:
                return self._tabular_model.measures.find(self.object_id)
            case ObjectType.TABLE:
                return self._tabular_model.tables.find(self.object_id)
            case _:
                msg = f"No logic for object type: {self.object_type}"
                raise TypeError(msg)

    def parents_base(self) -> frozenset["LinkedEntity"]:
        return LinkedEntity.from_iter({self.object()}, by="object")