Force Aggregate table selection is only available from the Administrator module and not in the Analyst module. So, users with administrative privileges can login to Administrator module and make the intended changes to the KPI.
Aggregate sequence is the sequence in which aggregate tables are stored in data model, with unique numbers. For every filter chosen by the user in the front end, there is an equivalent aggregate table mapped in the data model. When user choose ...
This problem can occur if the month_in_year column in DIM_DATE is not unique for a given month. Please check and provide a unique name to solve the issue.