AnsweredAssumed Answered

How to implement this escenario on Pentaho Schema Workbench?

Question asked by Marcela Yanza on Feb 26, 2018
Latest reply on Mar 21, 2018 by Bill Moore

Hi, I'm working on my thesis and I'm trying to implement this escenario on Pentaho Schema Workbench 8.0.0.0.

As you can see MATERIA_DOCENTE is a bridge table that is linked to the fact table FACT_EVALUACION_ANUAL but dimensions DOCENTE and MATERIA aren't linked to fact table. Also, I've created a primary key on the fact table called FACT_PK (PK=primary key and FK=foreign key). "Nota_Final" and "Promedio_Notas" are measures. Any ideas? Thank you so much for your help.

modelo.JPG

Outcomes