[Mondrian] xml cube error in where topic

Luc Boudreau lucboudreau at gmail.com
Thu Mar 20 09:49:56 EDT 2014

Hello Alejandro,

I don't think this list is the right place for you to get help. We deal
with development-related questions here, not user support.

If I may make a few suggestions, your schema's structure clearly tells us
that you should take a step back and review your schema and the
documentation. Actually, if I might also suggest, you should take even more
steps back and read a couple articles and books on OLAP before attempting
to design these schemas. Your dimensions are not designed properly and you
have confused the levels with the members. (You can't create one column per
month. You need a column which contains the key of the month).

I suggest reading the Mondrian book. It's a good introduction to OLAP
modeling and will teach you the right approach to OLAP. ( manning.com/back/

I realize that you have a close dead line to meet, but trust me, you're
more than 3 days off from calling this finished. You'll be very happy you
took the time to understand first.

Best of luck


On Thu, Apr 10, 2014 at 8:50 AM, J.Alejandro Martinez Linares <
islanis at infomed.sld.cu> wrote:

> I get an error executing this in my mondrian, please somebody that can
> assist me, i have 3 days in this problem and i am new using mondrian
> please, i leave the xml cube too please.
> Mondrian Error:Internal error: Error while executing query [select
> Hierarchize(Union({[municipio].[todos_municipios].[Boyeros],
> [municipio].[todos_municipios].[Arroyo Naranjo]},
> [municipio].[todos_municipios].[Arroyo Naranjo].Children)) ON COLUMNS,
> {([Rad_solar_directa.todos_rad_sol_directa].[todos_rad_sol_directa],
> [Rad_solar_global.todos_rad_sol_global].[todos_rad_sol_global])} ON ROWS
> from [Solar]
> ]
> Mondrian Error:Internal error: Error while loading segment; sql=[select
> "sigfre_cub_adm_prov"."nombre" as "c0", count("ft_cubo"."gid") as "m0" from
> "public"."sigfre_cub_adm_prov" as "sigfre_cub_adm_prov", "public"."ft_cubo"
> as "ft_cubo" where "ft_cubo"."gidmunic" = "sigfre_cub_adm_munic"."gid" and
> "sigfre_cub_adm_prov"."nombre" = 'La  Habana' group by
> "sigfre_cub_adm_prov"."nombre"]
> ERROR: falta una entrada para la tabla «sigfre_cub_adm_munic» en la
> cláusula FROM
> thanks
> --
> Este mensaje le ha llegado mediante el servicio de correo electronico que
> ofrece Infomed para respaldar el cumplimiento de las misiones del Sistema
> Nacional de Salud. La persona que envia este correo asume el compromiso de
> usar el servicio a tales fines y cumplir con las regulaciones establecidas
> Infomed: http://www.sld.cu/
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20140320/9917932a/attachment.html 

More information about the Mondrian mailing list