<div dir="ltr">Hello Alejandro,<div><br></div><div>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. </div><div><br></div><div>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).</div>
<div><br></div><div>I suggest reading the Mondrian book. It's a good introduction to OLAP modeling and will teach you the right approach to OLAP. ( <a href="http://manning.com/back/">manning.com/back/</a> ) </div><div>
<br></div><div>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.</div><div><br></div>
<div>Best of luck</div><div><br></div><div>Luc</div><div><br></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Thu, Apr 10, 2014 at 8:50 AM, J.Alejandro Martinez Linares <span dir="ltr"><<a href="mailto:islanis@infomed.sld.cu" target="_blank">islanis@infomed.sld.cu</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">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.<br>
<br>
Mondrian Error:Internal error: Error while executing query [select Hierarchize(Union({[municipio]<u></u>.[todos_municipios].[Boyeros], [municipio].[todos_municipios]<u></u>.[Arroyo Naranjo]}, [municipio].[todos_municipios]<u></u>.[Arroyo Naranjo].Children)) ON COLUMNS,<br>
{([Rad_solar_directa.todos_<u></u>rad_sol_directa].[todos_rad_<u></u>sol_directa], [Rad_solar_global.todos_rad_<u></u>sol_global].[todos_rad_sol_<u></u>global])} ON ROWS<br>
from [Solar]<br>
]<br>
<br>
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"<u></u>]<br>
<br>
ERROR: falta una entrada para la tabla «sigfre_cub_adm_munic» en la cláusula FROM<br>
<br>
<br>
thanks<br>
<br>
<br>
<br>
--<br>
<br>
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<br>
<br>
Infomed: <a href="http://www.sld.cu/" target="_blank">http://www.sld.cu/</a><br>
<br>_______________________________________________<br>
Mondrian mailing list<br>
<a href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a><br>
<a href="http://lists.pentaho.org/mailman/listinfo/mondrian" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
<br></blockquote></div><br></div>