[Mondrian] xml cube error in where topic

J.Alejandro Martinez Linares islanis at infomed.sld.cu
Thu Mar 20 07:09:06 EDT 2014


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/
-------------- next part --------------
A non-text attachment was scrubbed...
Name: DW_sigfre2_solar2.PNG
Type: image/png
Size: 389322 bytes
Desc: not available
Url : http://lists.pentaho.org/pipermail/mondrian/attachments/20140320/6f0c1eb7/attachment.png 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: DW_sigfre2_solar2.xml
Type: text/xml
Size: 9409 bytes
Desc: not available
Url : http://lists.pentaho.org/pipermail/mondrian/attachments/20140320/6f0c1eb7/attachment.xml 


More information about the Mondrian mailing list