This problem can occur if the new module created does not contain any KPIs. Please create at least one KPI for the newly created module. Additionally, there is no need to assign this to Super users. By default, security does not apply to Super users. ...
If there is no KPI in the newly created module, the module doesn't reflect in the Analyst. Therefore, add at least one KPI (assigned to a KPI Group) for the module to appear in Analyst.
For the Measure C170 the DB_COLUMN_NAME (date_key) was mentioned in lower case. whereas in DB the column name (DATE_KEY) is upper case. Change the Measure "C170" DB_COLUMN_NAME to upper case, the KPI should work fine.