Hi, I'm working on my thesis and I'm trying to implement this escenario on Pentaho Schema Workbench 22.214.171.124.
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.