Where clause generation with CubeDesigner-0.7.2.0_Win32

[fabien Zanchi]

I am using CubeDesigner-0.7.2.0_Win32 with Mysql sample data DB and when creating a cube only using orderfact and orderdetails table joining on the ordernumber and product code the WHERE clause is not generated even though graphically it shows on the application.

How can I force the where clause to be generated ? The issue is then when I publish the report it is publish blank:confused:

[clement]

Hi,


I am using CubeDesigner-0.7.2.0_Win32 with Mysql sample data DB and when creating a cube only using orderfact and orderdetails table joining on the ordernumber and product code the WHERE clause is not generated even though graphically it shows on the application.

How can I force the where clause to be generated ?(...)

I am not sure to understand what is your schema like but if it is a snowflake schema in which the more far you are from the fact table, the larger the "groups" are, like here : http://forums.pentaho.org/showthread.php?p=170451#post170451
then Cube Designer can not do it and you'll have to edit manually the yourcube.mondrian.xml file.

a+, =)
-=Clément=-

[fabien Zanchi]

Hi Clement,

I am using the default mysql DB and only orderfact table as a test with a simple aggregator. Here is the xml code


<?xml version="1.0" encoding="UTF-8"?>

<Schemaname="CubeDesigner">

<Cubename="CubeDesigner">

<Tablename="orderfact"/>

<Measurename="SUM of orderfact.TOTALPRICE"column="TOTALPRICE"aggregator="sum"datatype="Numeric"formatString="#,##0.###"/>

</Cube>
</Schema>

The report gets publish well but when I try to preview it or look at it in the web portal nothing is showig (blank report ). How come ? and how can I get data to show ?