Dear MSAS Experts,
My name is Andre and i am writing my thesis about data quality which needs to be finished in about 3 weeks.:-( For my thesis i needed to develop a Schema which store data quality issues.
This is a part of my schema which includes a cascading M2M:
Facttabele: ErrorFact / ChecksFact / RULE ID / ...
DT_RULE: Rule_ID / .....
RULE_ATTRIBUTE_BRIDGE: RULE_ID / Attribut_ID
=> M2M beetween Rule and Attribut(Rules can belong to multiple Attributes)
DT_Attribut: Attribut_ID / ....
Attribut_KPI_Bridge: Atribute_ID / KPI_ID
=> M2M beetween Attribute and KPI (Attributes can be used for multible KPI calc)
DT_KPI: KPI_ID, KPI_Name, KPI_PARENT
=> Parent Child
Since MSAS do not provide a Agrgatefunction I have a calculated Measure (lets say its called 'EC') which calculates the average of ErrorFact/ChecksFact.
Now the problem I do have is that the 'EC' Measure should be aggregated within and only in the
DT_KPI dimension that every child which belongs to the same parent should be muliplicated ('*') with each other till we reach the all member node.
So if we have the following PC-Hierachy:
The result of A would be (C*D)*E = A.
B of course would show the result of C*D.
On the other hand all the other facts should use the normal aggregation for this dimension. Also EC should be aggregated normal in all other dimensions.
I tried usin
View Complete Post