[Mondrian] Some SQL points

Stefan de Konink stefan at konink.de
Mon Mar 16 03:11:23 EDT 2009


Julian Hyde wrote:
>      [java] Caused by: mondrian.olap.MondrianException: Mondrian
> Error:Internal error: Error while loading segment; sql=[select
> "store"."store_state" as "c0", "store"."store_city" as "c1",
> "time_by_day"."the_year" as "c2", sum("sales_fact_1997"."unit_sales") as
> "m0" from "store" as "store", "sales_fact_1997" as "sales_fact_1997",
> "time_by_day" as "time_by_day" where "sales_fact_1997"."store_id" =
> "store"."store_id" and "store"."store_state" = 'CA' and "store"."store_city"
> = 'Alameda' and "sales_fact_1997"."time_id" = "time_by_day"."time_id" and
> "time_by_day"."the_year" = 1997 group by "store"."store_state",
> "store"."store_city", "time_by_day"."the_year"]



sql>select store_id from store where store_city = 'Alameda';
+----------+
| store_id |
+==========+
|        0 |
+----------+
1 tuple
sql>select * from sales_fact_1997 where store_id = 0;
0 tuples


Please advise :)


Stefan




More information about the Mondrian mailing list