Using the SQL backend, when cubes creates query containing a GROUP BY clause, the name of the column is not fully qualified (it lacks the name of the table. before).
This creates problem when two tables with columns of same name are joined.
e.g.
sqlalchemy.exc.ProgrammingError: (psycopg2.ProgrammingError) column reference "status" is ambiguous
LINE 3: ...RACT(year FROM activity_date.date) < '2017') GROUP BY status
^
[SQL: 'SELECT activity_subscription.status AS status \nFROM activity_subscription JOIN activity_date ON activity_subscription.activity_date_id = activity_date.id \nWHERE (EXTRACT(year FROM activity_date.date) = %(param_1)s AND EXTRACT(month FROM activity_date.date) = %(param_2)s AND EXTRACT(day FROM activity_date.date) >= %(param_3)s OR EXTRACT(year FROM activity_date.date) = %(param_4)s AND EXTRACT(month FROM activity_date.date) > %(param_5)s OR EXTRACT(year FROM activity_date.date) > %(param_6)s) AND (EXTRACT(year FROM activity_date.date) = %(param_7)s AND EXTRACT(month FROM activity_date.date) = %(param_8)s AND EXTRACT(day FROM activity_date.date) <= %(param_9)s OR EXTRACT(year FROM activity_date.date) = %(param_10)s AND EXTRACT(month FROM activity_date.date) < %(param_11)s OR EXTRACT(year FROM activity_date.date) < %(param_12)s) GROUP BY status'] [parameters: {'param_6': '2016', 'param_10': '2017', 'param_4': '2016', 'param_8': '8', 'param_3': '1', 'param_2': '9', 'param_12': '2017', 'param_5': '9', 'param_11': '8', 'param_7': '2017', 'param_1': '2016', 'param_9': '31'}]
Using the SQL backend, when cubes creates query containing a GROUP BY clause, the name of the column is not fully qualified (it lacks the name of the table. before).
This creates problem when two tables with columns of same name are joined.
e.g.
sqlalchemy.exc.ProgrammingError: (psycopg2.ProgrammingError) column reference "status" is ambiguous
This is my cube configuration