[Mondrian] xml cube error in where topic

J.Alejandro Martinez Linares islanis at infomed.sld.cu
Fri Mar 21 06:36:57 EDT 2014


El 20/03/14 14:49, Luc Boudreau escribió:
> 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.
so, where can i get 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 need it in that way, need columns per 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/ <http://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
>
> Luc
>
>
>
> On Thu, Apr 10, 2014 at 8:50 AM, J.Alejandro Martinez Linares 
> <islanis at infomed.sld.cu <mailto: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 <mailto:Mondrian at pentaho.org>
>     http://lists.pentaho.org/mailman/listinfo/mondrian
>
>
>
>
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian



--

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 --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20140321/930d0821/attachment.html 


More information about the Mondrian mailing list