[Mondrian] Some SQL points

[Sherman Wood]

That store is the head office. It does not have sales directly.

The same query against the MySQL Foodmart returns 0 rows.

Sherman 

-----Original Message-----
From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org]
On Behalf Of Stefan de Konink
Sent: Monday, March 16, 2009 6:11 PM
To: jhyde at pentaho.com
Cc: 'Mondrian developer mailing list'
Subject: Re: [Mondrian] Some SQL points

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

_______________________________________________
Mondrian mailing list
Mondrian at pentaho.org
http://lists.pentaho.org/mailman/listinfo/mondrian