From: Fabien C. <gk...@ea...> - 2008-04-16 16:39:17
|
Author: gkfabs Date: 2008-04-16 09:39:23 -0700 (Wed, 16 Apr 2008) New Revision: 63 Modified: trunk/pentaho/opentaps/customer/CustomerLocationCube.mondrian.xml trunk/pentaho/opentaps/customer/CustomerLocationCube.xaction Log: It is not possible to pass a variable like organizationId to a olap cube Modified: trunk/pentaho/opentaps/customer/CustomerLocationCube.mondrian.xml =================================================================== --- trunk/pentaho/opentaps/customer/CustomerLocationCube.mondrian.xml 2008-04-16 16:16:20 UTC (rev 62) +++ trunk/pentaho/opentaps/customer/CustomerLocationCube.mondrian.xml 2008-04-16 16:39:23 UTC (rev 63) @@ -16,7 +16,13 @@ </Dimension> <Cube name="LocationCube"> - <Table name="customer_dimension"/> + <View alias="view_customer"> + <SQL dialect="generic"> +select customer_dim_key, + (coalesce(state, '')) as state +from customer_dimension + </SQL> + </View> <DimensionUsage name="Location" source="Location" foreignKey="state"/> <Measure name="Count Customer" column="customer_dim_key" aggregator="count" datatype="String" formatString="Standard"/> </Cube> Modified: trunk/pentaho/opentaps/customer/CustomerLocationCube.xaction =================================================================== --- trunk/pentaho/opentaps/customer/CustomerLocationCube.xaction 2008-04-16 16:16:20 UTC (rev 62) +++ trunk/pentaho/opentaps/customer/CustomerLocationCube.xaction 2008-04-16 16:39:23 UTC (rev 63) @@ -18,12 +18,6 @@ <request>mode</request> </sources> </mode> - <organizationId type="string"> - <sources> - <request>organizationId</request> - </sources> - <default-value><![CDATA[%]]></default-value> - </organizationId> </inputs> <outputs> @@ -44,7 +38,6 @@ <action-name>Pivot View</action-name> <action-inputs> <mode type="string"/> - <organizationId type="string"/> </action-inputs> <action-outputs> <model type="string"/> |