PDA

View Full Version : Problems with aggregation hints



kalleheu
12-02-2009, 10:06 AM
Hi !

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
Kalle

INSERT INTO
...
COUNT(*) AS "fact_count"
FROM
"ARETF_ACCT_SV" "ARETF_ACCT_SV",
"ARETD_TIME_H1_SV" AS "ARETD_TIME_H1_SV",
"ARETD_AP_H1_SV" AS "ARETD_AP_H1_SV"