Problems with aggregation hints
I started a query in jpivot connected to my own schema file relying on Oracle. Mondrian (3.1.2) recognizes, that there is no aggregation available and proposes a new aggregation table (code snippet see below). These statements contain two mistakes:
- CREATE: One of the created fields is too small to hold the aggregated data.
- INSERT: This statement joins the fact- with two dimension-tables using aliasses. The alias for the fact is correct, but the two dims are connected by " AS <TABLE_NAME>". The " AS " doesn't work for the Oracle-dialect.
Is it a bug or did I do something wrong ?
Thank You in advance
COUNT(*) AS "fact_count"
"ARETD_TIME_H1_SV" AS "ARETD_TIME_H1_SV",
"ARETD_AP_H1_SV" AS "ARETD_AP_H1_SV"
Tags for this Thread