Forum Discussion
Helper IIPower BI fact/dimension table
Hi, dear all,
have question regarding Power BI fact/dimension table.
Slightly confused about the answer of the below question.
Our answer is:
Teacher First Name: Class Dimension
Period Number: Class Dimension
if disagree, please let us konw why?
Thank you for your help.
Hi! I think this is not the correct blog for these questions...anyway the solution is:
Teacher First Name belongs in the Teacher dimension because it is a descriptive attribute of the teacher, not a measurable fact...and period Number belongs in the Class dimension because in a star schema, the Period Number is a characteristic of the class rather than a metric.
Regards,
1 Reply
RicardoTraNaResponsive Resident
Hi! I think this is not the correct blog for these questions...anyway the solution is:
Teacher First Name belongs in the Teacher dimension because it is a descriptive attribute of the teacher, not a measurable fact...and period Number belongs in the Class dimension because in a star schema, the Period Number is a characteristic of the class rather than a metric.
Regards,