You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@ofbiz.apache.org by ja...@apache.org on 2008/07/16 17:14:20 UTC
svn commit: r677299 - in /ofbiz/trunk/specialpurpose/bi: ./ data/ entitydef/
servicedef/
Author: jacopoc
Date: Wed Jul 16 08:14:18 2008
New Revision: 677299
URL: http://svn.apache.org/viewvc?rev=677299&view=rev
Log:
First pass in the separation of application specific artifacts from lower level artifacts: the former should stay in the proper components, but for now are still here.
Added:
ofbiz/trunk/specialpurpose/bi/data/DimensionTypeData_common.xml (with props)
ofbiz/trunk/specialpurpose/bi/data/DimensionTypeData_product.xml (with props)
ofbiz/trunk/specialpurpose/bi/entitydef/entitygroup_accounting_olap.xml (with props)
ofbiz/trunk/specialpurpose/bi/entitydef/entitygroup_common_olap.xml (with props)
ofbiz/trunk/specialpurpose/bi/entitydef/entitygroup_product_olap.xml (with props)
ofbiz/trunk/specialpurpose/bi/entitydef/entitymodel_accounting_olap.xml (with props)
ofbiz/trunk/specialpurpose/bi/entitydef/entitymodel_common_olap.xml (with props)
ofbiz/trunk/specialpurpose/bi/entitydef/entitymodel_product_olap.xml (with props)
ofbiz/trunk/specialpurpose/bi/servicedef/secas_accounting_olap.xml (with props)
ofbiz/trunk/specialpurpose/bi/servicedef/secas_product_olap.xml (with props)
ofbiz/trunk/specialpurpose/bi/servicedef/services_accounting_olap.xml (with props)
ofbiz/trunk/specialpurpose/bi/servicedef/services_common_olap.xml (with props)
ofbiz/trunk/specialpurpose/bi/servicedef/services_product_olap.xml (with props)
Removed:
ofbiz/trunk/specialpurpose/bi/data/DimensionTypeData.xml
ofbiz/trunk/specialpurpose/bi/entitydef/entitygroup.xml
ofbiz/trunk/specialpurpose/bi/entitydef/entitymodel.xml
ofbiz/trunk/specialpurpose/bi/servicedef/secas.xml
Modified:
ofbiz/trunk/specialpurpose/bi/ofbiz-component.xml
ofbiz/trunk/specialpurpose/bi/servicedef/services.xml
Added: ofbiz/trunk/specialpurpose/bi/data/DimensionTypeData_common.xml
URL: http://svn.apache.org/viewvc/ofbiz/trunk/specialpurpose/bi/data/DimensionTypeData_common.xml?rev=677299&view=auto
==============================================================================
--- ofbiz/trunk/specialpurpose/bi/data/DimensionTypeData_common.xml (added)
+++ ofbiz/trunk/specialpurpose/bi/data/DimensionTypeData_common.xml Wed Jul 16 08:14:18 2008
@@ -0,0 +1,28 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+
+http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+<entity-engine-xml>
+
+ <CurrencyDimension dimensionId="_NF_" description="Currency Not Found."/>
+ <CurrencyDimension dimensionId="_NA_" description="Currency Not Set."/>
+
+ <DateDimension dimensionId="_NF_" description="Date Not Found."/>
+ <DateDimension dimensionId="_NA_" description="Date Not Set."/>
+
+</entity-engine-xml>
Propchange: ofbiz/trunk/specialpurpose/bi/data/DimensionTypeData_common.xml
------------------------------------------------------------------------------
svn:eol-style = native
Propchange: ofbiz/trunk/specialpurpose/bi/data/DimensionTypeData_common.xml
------------------------------------------------------------------------------
svn:keywords = Date Rev Author URL Id
Propchange: ofbiz/trunk/specialpurpose/bi/data/DimensionTypeData_common.xml
------------------------------------------------------------------------------
svn:mime-type = text/xml
Added: ofbiz/trunk/specialpurpose/bi/data/DimensionTypeData_product.xml
URL: http://svn.apache.org/viewvc/ofbiz/trunk/specialpurpose/bi/data/DimensionTypeData_product.xml?rev=677299&view=auto
==============================================================================
--- ofbiz/trunk/specialpurpose/bi/data/DimensionTypeData_product.xml (added)
+++ ofbiz/trunk/specialpurpose/bi/data/DimensionTypeData_product.xml Wed Jul 16 08:14:18 2008
@@ -0,0 +1,25 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+
+http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+<entity-engine-xml>
+
+ <ProductDimension dimensionId="_NF_"/>
+ <ProductDimension dimensionId="_NA_"/>
+
+</entity-engine-xml>
Propchange: ofbiz/trunk/specialpurpose/bi/data/DimensionTypeData_product.xml
------------------------------------------------------------------------------
svn:eol-style = native
Propchange: ofbiz/trunk/specialpurpose/bi/data/DimensionTypeData_product.xml
------------------------------------------------------------------------------
svn:keywords = Date Rev Author URL Id
Propchange: ofbiz/trunk/specialpurpose/bi/data/DimensionTypeData_product.xml
------------------------------------------------------------------------------
svn:mime-type = text/xml
Added: ofbiz/trunk/specialpurpose/bi/entitydef/entitygroup_accounting_olap.xml
URL: http://svn.apache.org/viewvc/ofbiz/trunk/specialpurpose/bi/entitydef/entitygroup_accounting_olap.xml?rev=677299&view=auto
==============================================================================
--- ofbiz/trunk/specialpurpose/bi/entitydef/entitygroup_accounting_olap.xml (added)
+++ ofbiz/trunk/specialpurpose/bi/entitydef/entitygroup_accounting_olap.xml Wed Jul 16 08:14:18 2008
@@ -0,0 +1,35 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+
+http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+<entitygroup xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+ xsi:noNamespaceSchemaLocation="http://ofbiz.apache.org/dtds/entitygroup.xsd">
+
+ <!-- ========================================================= -->
+ <!-- Facts -->
+ <!-- ========================================================= -->
+ <entity-group group="org.ofbiz.olap" entity="SalesInvoiceItemFact" />
+
+ <!-- ========================================================= -->
+ <!-- Star Schemas -->
+ <!-- ========================================================= -->
+ <entity-group group="org.ofbiz.olap" entity="SalesInvoiceItemStarSchema" />
+
+</entitygroup>
+
Propchange: ofbiz/trunk/specialpurpose/bi/entitydef/entitygroup_accounting_olap.xml
------------------------------------------------------------------------------
svn:eol-style = native
Propchange: ofbiz/trunk/specialpurpose/bi/entitydef/entitygroup_accounting_olap.xml
------------------------------------------------------------------------------
svn:keywords = Date Rev Author URL Id
Propchange: ofbiz/trunk/specialpurpose/bi/entitydef/entitygroup_accounting_olap.xml
------------------------------------------------------------------------------
svn:mime-type = text/xml
Added: ofbiz/trunk/specialpurpose/bi/entitydef/entitygroup_common_olap.xml
URL: http://svn.apache.org/viewvc/ofbiz/trunk/specialpurpose/bi/entitydef/entitygroup_common_olap.xml?rev=677299&view=auto
==============================================================================
--- ofbiz/trunk/specialpurpose/bi/entitydef/entitygroup_common_olap.xml (added)
+++ ofbiz/trunk/specialpurpose/bi/entitydef/entitygroup_common_olap.xml Wed Jul 16 08:14:18 2008
@@ -0,0 +1,29 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+
+http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+<entitygroup xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+ xsi:noNamespaceSchemaLocation="http://ofbiz.apache.org/dtds/entitygroup.xsd">
+
+ <!-- ========================================================= -->
+ <!-- Dimensions -->
+ <!-- ========================================================= -->
+ <entity-group group="org.ofbiz.olap" entity="CurrencyDimension" />
+ <entity-group group="org.ofbiz.olap" entity="DateDimension" />
+</entitygroup>
Propchange: ofbiz/trunk/specialpurpose/bi/entitydef/entitygroup_common_olap.xml
------------------------------------------------------------------------------
svn:eol-style = native
Propchange: ofbiz/trunk/specialpurpose/bi/entitydef/entitygroup_common_olap.xml
------------------------------------------------------------------------------
svn:keywords = Date Rev Author URL Id
Propchange: ofbiz/trunk/specialpurpose/bi/entitydef/entitygroup_common_olap.xml
------------------------------------------------------------------------------
svn:mime-type = text/xml
Added: ofbiz/trunk/specialpurpose/bi/entitydef/entitygroup_product_olap.xml
URL: http://svn.apache.org/viewvc/ofbiz/trunk/specialpurpose/bi/entitydef/entitygroup_product_olap.xml?rev=677299&view=auto
==============================================================================
--- ofbiz/trunk/specialpurpose/bi/entitydef/entitygroup_product_olap.xml (added)
+++ ofbiz/trunk/specialpurpose/bi/entitydef/entitygroup_product_olap.xml Wed Jul 16 08:14:18 2008
@@ -0,0 +1,28 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+
+http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+<entitygroup xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+ xsi:noNamespaceSchemaLocation="http://ofbiz.apache.org/dtds/entitygroup.xsd">
+
+ <!-- ========================================================= -->
+ <!-- Dimensions -->
+ <!-- ========================================================= -->
+ <entity-group group="org.ofbiz.olap" entity="ProductDimension" />
+</entitygroup>
Propchange: ofbiz/trunk/specialpurpose/bi/entitydef/entitygroup_product_olap.xml
------------------------------------------------------------------------------
svn:eol-style = native
Propchange: ofbiz/trunk/specialpurpose/bi/entitydef/entitygroup_product_olap.xml
------------------------------------------------------------------------------
svn:keywords = Date Rev Author URL Id
Propchange: ofbiz/trunk/specialpurpose/bi/entitydef/entitygroup_product_olap.xml
------------------------------------------------------------------------------
svn:mime-type = text/xml
Added: ofbiz/trunk/specialpurpose/bi/entitydef/entitymodel_accounting_olap.xml
URL: http://svn.apache.org/viewvc/ofbiz/trunk/specialpurpose/bi/entitydef/entitymodel_accounting_olap.xml?rev=677299&view=auto
==============================================================================
--- ofbiz/trunk/specialpurpose/bi/entitydef/entitymodel_accounting_olap.xml (added)
+++ ofbiz/trunk/specialpurpose/bi/entitydef/entitymodel_accounting_olap.xml Wed Jul 16 08:14:18 2008
@@ -0,0 +1,165 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+
+http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+<entitymodel xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+ xsi:noNamespaceSchemaLocation="http://ofbiz.apache.org/dtds/entitymodel.xsd">
+ <!-- ========================================================= -->
+ <!-- ======================== Defaults ======================= -->
+ <!-- ========================================================= -->
+ <title>OLAP entities for the Accounting component</title>
+ <description>None</description>
+ <copyright>Copyright 2001-2007 The Apache Software Foundation</copyright>
+
+ <!-- ========================================================= -->
+ <!-- Facts -->
+ <!-- ========================================================= -->
+ <entity entity-name="SalesInvoiceItemFact" package-name="org.ofbiz.bi.fact.accounting" title="Sales Invoice Item Fact">
+ <description>A transaction fact entity with invoice item grain.</description>
+ <field name="invoiceId" type="id-ne"></field> <!-- degenerate dimension -->
+ <field name="invoiceItemSeqId" type="id-ne"></field> <!-- degenerate dimension -->
+ <field name="orderId" type="id-ne"></field> <!-- degenerate dimension -->
+ <field name="invoiceDateDimId" type="id-ne"></field>
+ <field name="productDimId" type="id-ne"></field>
+ <field name="billToCustomerDimId" type="id-ne"></field> <!-- TODO: implement the dimension -->
+ <field name="origCurrencyDimId" type="id-ne"></field>
+
+ <field name="quantity" type="floating-point">
+ <description>Quantity invoiced. From InvoiceItem.quantity</description>
+ </field>
+
+ <field name="extGrossAmount" type="currency-precise">
+ <description>Extended gross amount: quantity invoiced multiplied by the list unit price.</description>
+ </field>
+ <field name="extDiscountAmount" type="currency-precise">
+ <description>Extended discount amount.</description>
+ </field>
+ <field name="extNetAmount" type="currency-precise">
+ <description>Extended net amount: gross amount less discounts.</description>
+ </field>
+ <field name="extTaxAmount" type="currency-precise">
+ <description>Extended tax amount.</description>
+ </field>
+ <field name="extManFixedCost" type="currency-precise">
+ <description>Extended manufacturing fixed cost.</description>
+ </field>
+ <field name="extManVarCost" type="currency-precise">
+ <description>Extended manufacturing variable cost.</description>
+ </field>
+ <field name="extStorageCost" type="currency-precise">
+ <description>Extended storage cost.</description>
+ </field>
+ <field name="extDistributionCost" type="currency-precise">
+ <description>Extended distribution cost.</description>
+ </field>
+ <field name="contributionAmount" type="currency-precise">
+ <description>Extended net amount less all the costs.</description>
+ </field>
+ <!--
+ TODO: implement multy currency fields
+ <field name="extGrossAmountOrig" type="currency-precise">
+ <description>Extended gross amount in the original currency: quantity invoiced multiplied by the list unit price.</description>
+ </field>
+ <field name="extDiscountAmountOrig" type="currency-precise">
+ <description>Extended discount amount in the original currency.</description>
+ </field>
+ <field name="extNetAmountOrig" type="currency-precise">
+ <description>Extended net amount in the original currency: gross amount less discounts.</description>
+ </field>
+ <field name="extManFixedCostOrig" type="currency-precise">
+ <description>Extended manufacturing fixed cost in the original currency.</description>
+ </field>
+ <field name="extManVarCostOrig" type="currency-precise">
+ <description>Extended manufacturing variable cost in the original currency.</description>
+ </field>
+ <field name="extStorageCostOrig" type="currency-precise">
+ <description>Extended storage cost in the original currency.</description>
+ </field>
+ <field name="extDistributionCostOrig" type="currency-precise">
+ <description>Extended distribution cost in the original currency.</description>
+ </field>
+ <field name="contributionAmountOrig" type="currency-precise">
+ <description>Extended net amount less all the costs in the original currency.</description>
+ </field>
+ -->
+
+ <prim-key field="invoiceId"/>
+ <prim-key field="invoiceItemSeqId"/>
+
+ <relation type="one" fk-name="SIIF_INVDATE" rel-entity-name="DateDimension">
+ <key-map field-name="invoiceDateDimId" rel-field-name="dimensionId"/>
+ </relation>
+ <relation type="one" fk-name="SIIF_CURRENCY" rel-entity-name="CurrencyDimension">
+ <key-map field-name="origCurrencyDimId" rel-field-name="dimensionId"/>
+ </relation>
+ <relation type="one" fk-name="SIIF_PRODUCT" rel-entity-name="ProductDimension">
+ <key-map field-name="productDimId" rel-field-name="dimensionId"/>
+ </relation>
+
+ </entity>
+
+ <!-- ========================================================= -->
+ <!-- Star Schemas -->
+ <!-- ========================================================= -->
+ <view-entity entity-name="SalesInvoiceItemStarSchema" package-name="org.ofbiz.bi.starschema.accounting" title="Sales Invoice Item Star Schema">
+ <description>Invoice Item star schema (Profit and Loss Statement).</description>
+
+ <member-entity entity-alias="SIIF" entity-name="SalesInvoiceItemFact"/>
+ <member-entity entity-alias="IDD" entity-name="DateDimension"/>
+ <member-entity entity-alias="PD" entity-name="ProductDimension"/>
+ <member-entity entity-alias="CD" entity-name="CurrencyDimension"/>
+
+ <alias-all entity-alias="IDD" prefix="invoiceDate" group-by="true">
+ <exclude field="dimensionId"/>
+ </alias-all>
+ <alias-all entity-alias="PD" prefix="product" group-by="true">
+ <exclude field="dimensionId"/>
+ </alias-all>
+ <alias-all entity-alias="CD" prefix="currency" group-by="true">
+ <exclude field="dimensionId"/>
+ </alias-all>
+ <alias-all entity-alias="SIIF" function="sum">
+ <exclude field="invoiceItemSeqId"/>
+ <exclude field="invoiceDateDimId"/>
+ <exclude field="productDimId"/>
+ <exclude field="billToCustomerDimId"/>
+ <exclude field="origCurrencyDimId"/>
+ <exclude field="orderId"/>
+ <exclude field="invoiceId"/>
+ <exclude field="invoiceItemSeqId"/>
+ </alias-all>
+ <alias entity-alias="SIIF" name="invoiceId" group-by="true">
+ <description>Invoice id</description>
+ </alias>
+ <alias entity-alias="SIIF" name="invoiceItemSeqId" group-by="true"/>
+ <alias entity-alias="SIIF" name="orderId" group-by="true"/>
+
+ <view-link entity-alias="SIIF" rel-entity-alias="IDD">
+ <key-map field-name="invoiceDateDimId" rel-field-name="dimensionId"/>
+ </view-link>
+ <view-link entity-alias="SIIF" rel-entity-alias="PD">
+ <key-map field-name="productDimId" rel-field-name="dimensionId"/>
+ </view-link>
+ <view-link entity-alias="SIIF" rel-entity-alias="CD">
+ <key-map field-name="origCurrencyDimId" rel-field-name="dimensionId"/>
+ </view-link>
+
+ </view-entity>
+
+</entitymodel>
Propchange: ofbiz/trunk/specialpurpose/bi/entitydef/entitymodel_accounting_olap.xml
------------------------------------------------------------------------------
svn:eol-style = native
Propchange: ofbiz/trunk/specialpurpose/bi/entitydef/entitymodel_accounting_olap.xml
------------------------------------------------------------------------------
svn:keywords = Date Rev Author URL Id
Propchange: ofbiz/trunk/specialpurpose/bi/entitydef/entitymodel_accounting_olap.xml
------------------------------------------------------------------------------
svn:mime-type = text/xml
Added: ofbiz/trunk/specialpurpose/bi/entitydef/entitymodel_common_olap.xml
URL: http://svn.apache.org/viewvc/ofbiz/trunk/specialpurpose/bi/entitydef/entitymodel_common_olap.xml?rev=677299&view=auto
==============================================================================
--- ofbiz/trunk/specialpurpose/bi/entitydef/entitymodel_common_olap.xml (added)
+++ ofbiz/trunk/specialpurpose/bi/entitydef/entitymodel_common_olap.xml Wed Jul 16 08:14:18 2008
@@ -0,0 +1,94 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+
+http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+<entitymodel xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+ xsi:noNamespaceSchemaLocation="http://ofbiz.apache.org/dtds/entitymodel.xsd">
+ <!-- ========================================================= -->
+ <!-- ======================== Defaults ======================= -->
+ <!-- ========================================================= -->
+ <title>OLAP entities for the Common component</title>
+ <description>None</description>
+ <copyright>Copyright 2001-2007 The Apache Software Foundation</copyright>
+
+ <!-- ========================================================= -->
+ <!-- Dimensions -->
+ <!-- ========================================================= -->
+
+ <entity entity-name="DateDimension" package-name="org.ofbiz.bi.dimension" title="Date Dimension">
+ <description>Date (days) dimension. The natural key is [dateValue]</description>
+ <field name="dimensionId" type="id-ne">
+ <description>Unique identifier of the Date dimension record</description>
+ </field>
+ <field name="dateValue" type="date">
+ <description>The date (day)</description>
+ </field>
+ <field name="description" type="description">
+ <description>Full date description</description>
+ </field>
+ <field name="dayName" type="short-varchar">
+ <description>The name of the day (Monday, Tuesday, etc...)</description>
+ </field>
+ <field name="dayOfMonth" type="numeric">
+ <description>The number of the day in the month</description>
+ </field>
+ <field name="dayOfYear" type="numeric">
+ <description>The number of the day in the year</description>
+ </field>
+ <field name="monthName" type="short-varchar">
+ <description>The name of the month (January, February, etc...)</description>
+ </field>
+ <field name="monthOfYear" type="numeric">
+ <description>The number of the month (1-12)</description>
+ </field>
+ <field name="yearName" type="numeric">
+ <description>The year (2008, 2009, etc...)</description>
+ </field>
+ <field name="weekOfMonth" type="numeric">
+ <description>The number of the week in the month</description>
+ </field>
+ <field name="weekOfYear" type="numeric">
+ <description>The number of the week in the year</description>
+ </field>
+ <field name="yearMonthDay" type="short-varchar">
+ <description>YYYY-MM-DD</description>
+ </field>
+ <field name="yearAndMonth" type="short-varchar">
+ <description>YYYY-MM</description>
+ </field>
+ <field name="weekdayType" type="short-varchar">
+ <description>Weekday indicator (Weekday or Weekend)</description>
+ </field>
+ <prim-key field="dimensionId"/>
+ </entity>
+
+ <entity entity-name="CurrencyDimension" package-name="org.ofbiz.bi.dimension" title="Currency Dimension">
+ <description>Currency dimension. The natural key is [currencyId]</description>
+ <field name="dimensionId" type="id-ne">
+ <description>Unique identifier of the Currency dimension record</description>
+ </field>
+ <field name="currencyId" type="id-ne">
+ <description>The currency id (natural key).</description>
+ </field>
+ <field name="description" type="description">
+ <description>Full currency description</description>
+ </field>
+ <prim-key field="dimensionId"/>
+ </entity>
+</entitymodel>
Propchange: ofbiz/trunk/specialpurpose/bi/entitydef/entitymodel_common_olap.xml
------------------------------------------------------------------------------
svn:eol-style = native
Propchange: ofbiz/trunk/specialpurpose/bi/entitydef/entitymodel_common_olap.xml
------------------------------------------------------------------------------
svn:keywords = Date Rev Author URL Id
Propchange: ofbiz/trunk/specialpurpose/bi/entitydef/entitymodel_common_olap.xml
------------------------------------------------------------------------------
svn:mime-type = text/xml
Added: ofbiz/trunk/specialpurpose/bi/entitydef/entitymodel_product_olap.xml
URL: http://svn.apache.org/viewvc/ofbiz/trunk/specialpurpose/bi/entitydef/entitymodel_product_olap.xml?rev=677299&view=auto
==============================================================================
--- ofbiz/trunk/specialpurpose/bi/entitydef/entitymodel_product_olap.xml (added)
+++ ofbiz/trunk/specialpurpose/bi/entitydef/entitymodel_product_olap.xml Wed Jul 16 08:14:18 2008
@@ -0,0 +1,49 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+
+http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+<entitymodel xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+ xsi:noNamespaceSchemaLocation="http://ofbiz.apache.org/dtds/entitymodel.xsd">
+ <!-- ========================================================= -->
+ <!-- ======================== Defaults ======================= -->
+ <!-- ========================================================= -->
+ <title>OLAP entities for the Product component</title>
+ <description>None</description>
+ <copyright>Copyright 2001-2007 The Apache Software Foundation</copyright>
+
+ <!-- ========================================================= -->
+ <!-- Dimensions -->
+ <!-- ========================================================= -->
+
+ <entity entity-name="ProductDimension" package-name="org.ofbiz.bi.dimension.product" title="Product Dimension">
+ <description>Product dimension. The natural key is [productId]</description>
+ <field name="dimensionId" type="id-ne">
+ <description>Unique identifier of the Product dimension record</description>
+ </field>
+ <field name="productId" type="id-ne">
+ <description>The natural key. From Product.productId</description>
+ </field>
+ <field name="productType" type="description">
+ <description>The product type. From ProductType.description</description>
+ </field>
+ <field name="brandName" type="name"></field>
+ <field name="internalName" type="description"></field>
+ <prim-key field="dimensionId"/>
+ </entity>
+</entitymodel>
Propchange: ofbiz/trunk/specialpurpose/bi/entitydef/entitymodel_product_olap.xml
------------------------------------------------------------------------------
svn:eol-style = native
Propchange: ofbiz/trunk/specialpurpose/bi/entitydef/entitymodel_product_olap.xml
------------------------------------------------------------------------------
svn:keywords = Date Rev Author URL Id
Propchange: ofbiz/trunk/specialpurpose/bi/entitydef/entitymodel_product_olap.xml
------------------------------------------------------------------------------
svn:mime-type = text/xml
Modified: ofbiz/trunk/specialpurpose/bi/ofbiz-component.xml
URL: http://svn.apache.org/viewvc/ofbiz/trunk/specialpurpose/bi/ofbiz-component.xml?rev=677299&r1=677298&r2=677299&view=diff
==============================================================================
--- ofbiz/trunk/specialpurpose/bi/ofbiz-component.xml (original)
+++ ofbiz/trunk/specialpurpose/bi/ofbiz-component.xml Wed Jul 16 08:14:18 2008
@@ -26,13 +26,22 @@
<classpath type="dir" location="config"/>
<classpath type="jar" location="build/lib/*"/>
- <entity-resource type="model" reader-name="main" loader="main" location="entitydef/entitymodel.xml"/>
- <entity-resource type="group" reader-name="main" loader="main" location="entitydef/entitygroup.xml"/>
+ <entity-resource type="model" reader-name="main" loader="main" location="entitydef/entitymodel_common_olap.xml"/>
+ <entity-resource type="model" reader-name="main" loader="main" location="entitydef/entitymodel_product_olap.xml"/>
+ <entity-resource type="model" reader-name="main" loader="main" location="entitydef/entitymodel_accounting_olap.xml"/>
+ <entity-resource type="group" reader-name="main" loader="main" location="entitydef/entitygroup_common_olap.xml"/>
+ <entity-resource type="group" reader-name="main" loader="main" location="entitydef/entitygroup_product_olap.xml"/>
+ <entity-resource type="group" reader-name="main" loader="main" location="entitydef/entitygroup_accounting_olap.xml"/>
- <entity-resource type="data" reader-name="seed" loader="main" location="data/DimensionTypeData.xml"/>
+ <entity-resource type="data" reader-name="seed" loader="main" location="data/DimensionTypeData_common.xml"/>
+ <entity-resource type="data" reader-name="seed" loader="main" location="data/DimensionTypeData_product.xml"/>
<service-resource type="model" loader="main" location="servicedef/services.xml"/>
- <service-resource type="eca" loader="main" location="servicedef/secas.xml"/>
+ <service-resource type="model" loader="main" location="servicedef/services_common_olap.xml"/>
+ <service-resource type="model" loader="main" location="servicedef/services_product_olap.xml"/>
+ <service-resource type="model" loader="main" location="servicedef/services_accounting_olap.xml"/>
+ <service-resource type="eca" loader="main" location="servicedef/secas_product_olap.xml"/>
+ <service-resource type="eca" loader="main" location="servicedef/secas_accounting_olap.xml"/>
<webapp name="bi"
title="Business Intelligence"
Added: ofbiz/trunk/specialpurpose/bi/servicedef/secas_accounting_olap.xml
URL: http://svn.apache.org/viewvc/ofbiz/trunk/specialpurpose/bi/servicedef/secas_accounting_olap.xml?rev=677299&view=auto
==============================================================================
--- ofbiz/trunk/specialpurpose/bi/servicedef/secas_accounting_olap.xml (added)
+++ ofbiz/trunk/specialpurpose/bi/servicedef/secas_accounting_olap.xml Wed Jul 16 08:14:18 2008
@@ -0,0 +1,32 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+
+http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+<service-eca xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+ xsi:noNamespaceSchemaLocation="http://ofbiz.apache.org/dtds/service-eca.xsd">
+
+ <!-- fact entities -->
+ <!-- Load data into the SalesInvoiceItemFact olap entity when a sales invoice is set to ready -->
+ <eca service="setInvoiceStatus" event="commit">
+ <condition field-name="statusId" operator="equals" value="INVOICE_READY"/>
+ <condition-field field-name="statusId" operator="not-equals" to-field-name="oldStatusId"/>
+ <action service="loadSalesInvoiceFact" mode="sync" run-as-user="system"/>
+ </eca>
+
+</service-eca>
Propchange: ofbiz/trunk/specialpurpose/bi/servicedef/secas_accounting_olap.xml
------------------------------------------------------------------------------
svn:eol-style = native
Propchange: ofbiz/trunk/specialpurpose/bi/servicedef/secas_accounting_olap.xml
------------------------------------------------------------------------------
svn:keywords = Date Rev Author URL Id
Propchange: ofbiz/trunk/specialpurpose/bi/servicedef/secas_accounting_olap.xml
------------------------------------------------------------------------------
svn:mime-type = text/xml
Added: ofbiz/trunk/specialpurpose/bi/servicedef/secas_product_olap.xml
URL: http://svn.apache.org/viewvc/ofbiz/trunk/specialpurpose/bi/servicedef/secas_product_olap.xml?rev=677299&view=auto
==============================================================================
--- ofbiz/trunk/specialpurpose/bi/servicedef/secas_product_olap.xml (added)
+++ ofbiz/trunk/specialpurpose/bi/servicedef/secas_product_olap.xml Wed Jul 16 08:14:18 2008
@@ -0,0 +1,31 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+
+http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+<service-eca xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+ xsi:noNamespaceSchemaLocation="http://ofbiz.apache.org/dtds/service-eca.xsd">
+
+ <!-- dimension entities -->
+ <eca service="createProduct" event="commit">
+ <action service="loadType1ProductInProductDimension" mode="sync"/>
+ </eca>
+ <eca service="updateProduct" event="commit">
+ <action service="loadType2ProductInProductDimension" mode="sync"/>
+ </eca>
+</service-eca>
Propchange: ofbiz/trunk/specialpurpose/bi/servicedef/secas_product_olap.xml
------------------------------------------------------------------------------
svn:eol-style = native
Propchange: ofbiz/trunk/specialpurpose/bi/servicedef/secas_product_olap.xml
------------------------------------------------------------------------------
svn:keywords = Date Rev Author URL Id
Propchange: ofbiz/trunk/specialpurpose/bi/servicedef/secas_product_olap.xml
------------------------------------------------------------------------------
svn:mime-type = text/xml
Modified: ofbiz/trunk/specialpurpose/bi/servicedef/services.xml
URL: http://svn.apache.org/viewvc/ofbiz/trunk/specialpurpose/bi/servicedef/services.xml?rev=677299&r1=677298&r2=677299&view=diff
==============================================================================
--- ofbiz/trunk/specialpurpose/bi/servicedef/services.xml (original)
+++ ofbiz/trunk/specialpurpose/bi/servicedef/services.xml Wed Jul 16 08:14:18 2008
@@ -37,67 +37,7 @@
<attribute name="dimensionId" type="String" mode="OUT" optional="true"/>
</service>
- <!-- Common Dimension -->
- <service name="loadDateDimension" engine="java" transaction-timeout="300"
- location="org.ofbiz.bi.util.DimensionServices" invoke="loadDateDimension" auth="true">
- <description>Loads data in the DateDimension entity (olap entity) using the update strategy of 'type 1': overwrite the values of the attributes</description>
- <attribute name="fromDate" type="Date" mode="IN" optional="false"/>
- <attribute name="thruDate" type="Date" mode="IN" optional="false"/>
- </service>
- <service name="loadCurrencyDimension" auth="true" engine="simple"
- location="org/ofbiz/bi/DimensionServices.xml" invoke="loadCurrencyDimension">
- <description>Loads data in the CurrencyDimension entity (olap entity) using the update strategy of 'type 1': overwrite the values of the attributes</description>
- </service>
-
- <!-- ProductDimension -->
- <service name="prepareProductDimensionData" auth="true" engine="simple"
- location="org/ofbiz/bi/DimensionServices.xml" invoke="prepareProductDimensionData">
- <description>Pulls information from the Product* entities (oltp entities) and prepares data for the ProductDimension entity (olap entity)</description>
- <attribute name="productId" type="String" mode="IN" optional="false"/>
- <attribute name="productDimension" type="GenericEntity" mode="OUT" optional="false"/>
- </service>
- <service name="loadProductInProductDimension" auth="true" engine="simple"
- location="org/ofbiz/bi/DimensionServices.xml" invoke="loadProductInProductDimension">
- <description>Pulls information from the Product* entities and stores them in the ProductDimension entity (olap entity)</description>
- <attribute name="productId" type="String" mode="IN" optional="false"/>
- <attribute name="updateMode" type="String" mode="IN" optional="false"/> <!-- TYPE1, TYPE2, TYPE3 -->
- </service>
- <service name="loadType1ProductInProductDimension" auth="true" engine="simple"
- location="org/ofbiz/bi/DimensionServices.xml" invoke="loadProductInProductDimension">
- <description>Same as loadProductInProductDimension; the update strategy is 'type 1': overwrite the values of the attributes</description>
- <attribute name="productId" type="String" mode="IN" optional="false"/>
- <attribute name="updateMode" type="String" mode="IN" optional="true" default-value="TYPE1"/>
- </service>
- <service name="loadType2ProductInProductDimension" auth="true" engine="simple"
- location="org/ofbiz/bi/DimensionServices.xml" invoke="loadProductInProductDimension">
- <description>Same as loadProductInProductDimension; the update strategy is 'type 2': add a dimension row</description>
- <attribute name="productId" type="String" mode="IN" optional="false"/>
- <attribute name="updateMode" type="String" mode="IN" optional="true" default-value="TYPE2"/>
- </service>
- <service name="loadAllProductsInProductDimension" auth="true" engine="simple"
- location="org/ofbiz/bi/DimensionServices.xml" invoke="loadAllProductsInProductDimension">
- <description>Calls the loadProductInProductDimension service for all the products.</description>
- <attribute name="updateMode" type="String" mode="IN" optional="true" default-value="TYPE1"/> <!-- TYPE1, TYPE2, TYPE3 -->
- </service>
-
- <!-- Accounting Facts -->
- <service name="loadSalesInvoiceItemFact" auth="true" engine="simple"
- location="org/ofbiz/bi/FactServices.xml" invoke="loadSalesInvoiceItemFact">
- <description>
- Pulls information from the Invoice* entities and stores them in the SalesInvoiceItem entity (olap entity).
- One of invoiceId/invoiceItemSeqId or invoice/invoiceItem must be passed or an error is returned.
- </description>
- <attribute name="invoiceId" type="String" mode="IN" optional="true"/>
- <attribute name="invoiceItemSeqId" type="String" mode="IN" optional="true"/>
- <attribute name="invoice" type="GenericValue" mode="IN" optional="true"/>
- <attribute name="invoiceItem" type="GenericValue" mode="IN" optional="true"/>
- </service>
- <service name="loadSalesInvoiceFact" auth="true" engine="simple"
- location="org/ofbiz/bi/FactServices.xml" invoke="loadSalesInvoiceFact">
- <description>Calls the loadSalesInvoiceItemFact service for all the invoice items.</description>
- <attribute name="invoiceId" type="String" mode="IN" optional="false"/>
- </service>
-
+ <!-- TODO: this should be moved outside of the bi component -->
<service name="quickInitDataWarehouse" auth="true" engine="simple"
location="org/ofbiz/bi/DimensionServices.xml" invoke="quickInitDataWarehouse">
<description>Quickly initialize the dimensions (Currency, Date, Product) and facts (SalesInvoiceItem): useful to quickly initialize the datawarehouse.</description>
Added: ofbiz/trunk/specialpurpose/bi/servicedef/services_accounting_olap.xml
URL: http://svn.apache.org/viewvc/ofbiz/trunk/specialpurpose/bi/servicedef/services_accounting_olap.xml?rev=677299&view=auto
==============================================================================
--- ofbiz/trunk/specialpurpose/bi/servicedef/services_accounting_olap.xml (added)
+++ ofbiz/trunk/specialpurpose/bi/servicedef/services_accounting_olap.xml Wed Jul 16 08:14:18 2008
@@ -0,0 +1,41 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+
+http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+<services xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+ xsi:noNamespaceSchemaLocation="http://ofbiz.apache.org/dtds/services.xsd">
+
+ <!-- Accounting Facts -->
+ <service name="loadSalesInvoiceItemFact" auth="true" engine="simple"
+ location="org/ofbiz/bi/FactServices.xml" invoke="loadSalesInvoiceItemFact">
+ <description>
+ Pulls information from the Invoice* entities and stores them in the SalesInvoiceItem entity (olap entity).
+ One of invoiceId/invoiceItemSeqId or invoice/invoiceItem must be passed or an error is returned.
+ </description>
+ <attribute name="invoiceId" type="String" mode="IN" optional="true"/>
+ <attribute name="invoiceItemSeqId" type="String" mode="IN" optional="true"/>
+ <attribute name="invoice" type="GenericValue" mode="IN" optional="true"/>
+ <attribute name="invoiceItem" type="GenericValue" mode="IN" optional="true"/>
+ </service>
+ <service name="loadSalesInvoiceFact" auth="true" engine="simple"
+ location="org/ofbiz/bi/FactServices.xml" invoke="loadSalesInvoiceFact">
+ <description>Calls the loadSalesInvoiceItemFact service for all the invoice items.</description>
+ <attribute name="invoiceId" type="String" mode="IN" optional="false"/>
+ </service>
+</services>
Propchange: ofbiz/trunk/specialpurpose/bi/servicedef/services_accounting_olap.xml
------------------------------------------------------------------------------
svn:eol-style = native
Propchange: ofbiz/trunk/specialpurpose/bi/servicedef/services_accounting_olap.xml
------------------------------------------------------------------------------
svn:keywords = Date Rev Author URL Id
Propchange: ofbiz/trunk/specialpurpose/bi/servicedef/services_accounting_olap.xml
------------------------------------------------------------------------------
svn:mime-type = text/xml
Added: ofbiz/trunk/specialpurpose/bi/servicedef/services_common_olap.xml
URL: http://svn.apache.org/viewvc/ofbiz/trunk/specialpurpose/bi/servicedef/services_common_olap.xml?rev=677299&view=auto
==============================================================================
--- ofbiz/trunk/specialpurpose/bi/servicedef/services_common_olap.xml (added)
+++ ofbiz/trunk/specialpurpose/bi/servicedef/services_common_olap.xml Wed Jul 16 08:14:18 2008
@@ -0,0 +1,36 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+
+http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+<services xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+ xsi:noNamespaceSchemaLocation="http://ofbiz.apache.org/dtds/services.xsd">
+
+ <!-- Common Dimension -->
+ <service name="loadDateDimension" engine="java" transaction-timeout="300"
+ location="org.ofbiz.bi.util.DimensionServices" invoke="loadDateDimension" auth="true">
+ <description>Loads data in the DateDimension entity (olap entity) using the update strategy of 'type 1': overwrite the values of the attributes</description>
+ <attribute name="fromDate" type="Date" mode="IN" optional="false"/>
+ <attribute name="thruDate" type="Date" mode="IN" optional="false"/>
+ </service>
+ <service name="loadCurrencyDimension" auth="true" engine="simple"
+ location="org/ofbiz/bi/DimensionServices.xml" invoke="loadCurrencyDimension">
+ <description>Loads data in the CurrencyDimension entity (olap entity) using the update strategy of 'type 1': overwrite the values of the attributes</description>
+ </service>
+
+</services>
Propchange: ofbiz/trunk/specialpurpose/bi/servicedef/services_common_olap.xml
------------------------------------------------------------------------------
svn:eol-style = native
Propchange: ofbiz/trunk/specialpurpose/bi/servicedef/services_common_olap.xml
------------------------------------------------------------------------------
svn:keywords = Date Rev Author URL Id
Propchange: ofbiz/trunk/specialpurpose/bi/servicedef/services_common_olap.xml
------------------------------------------------------------------------------
svn:mime-type = text/xml
Added: ofbiz/trunk/specialpurpose/bi/servicedef/services_product_olap.xml
URL: http://svn.apache.org/viewvc/ofbiz/trunk/specialpurpose/bi/servicedef/services_product_olap.xml?rev=677299&view=auto
==============================================================================
--- ofbiz/trunk/specialpurpose/bi/servicedef/services_product_olap.xml (added)
+++ ofbiz/trunk/specialpurpose/bi/servicedef/services_product_olap.xml Wed Jul 16 08:14:18 2008
@@ -0,0 +1,54 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+
+http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+<services xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+ xsi:noNamespaceSchemaLocation="http://ofbiz.apache.org/dtds/services.xsd">
+
+ <!-- ProductDimension -->
+ <service name="prepareProductDimensionData" auth="true" engine="simple"
+ location="org/ofbiz/bi/DimensionServices.xml" invoke="prepareProductDimensionData">
+ <description>Pulls information from the Product* entities (oltp entities) and prepares data for the ProductDimension entity (olap entity)</description>
+ <attribute name="productId" type="String" mode="IN" optional="false"/>
+ <attribute name="productDimension" type="GenericEntity" mode="OUT" optional="false"/>
+ </service>
+ <service name="loadProductInProductDimension" auth="true" engine="simple"
+ location="org/ofbiz/bi/DimensionServices.xml" invoke="loadProductInProductDimension">
+ <description>Pulls information from the Product* entities and stores them in the ProductDimension entity (olap entity)</description>
+ <attribute name="productId" type="String" mode="IN" optional="false"/>
+ <attribute name="updateMode" type="String" mode="IN" optional="false"/> <!-- TYPE1, TYPE2, TYPE3 -->
+ </service>
+ <service name="loadType1ProductInProductDimension" auth="true" engine="simple"
+ location="org/ofbiz/bi/DimensionServices.xml" invoke="loadProductInProductDimension">
+ <description>Same as loadProductInProductDimension; the update strategy is 'type 1': overwrite the values of the attributes</description>
+ <attribute name="productId" type="String" mode="IN" optional="false"/>
+ <attribute name="updateMode" type="String" mode="IN" optional="true" default-value="TYPE1"/>
+ </service>
+ <service name="loadType2ProductInProductDimension" auth="true" engine="simple"
+ location="org/ofbiz/bi/DimensionServices.xml" invoke="loadProductInProductDimension">
+ <description>Same as loadProductInProductDimension; the update strategy is 'type 2': add a dimension row</description>
+ <attribute name="productId" type="String" mode="IN" optional="false"/>
+ <attribute name="updateMode" type="String" mode="IN" optional="true" default-value="TYPE2"/>
+ </service>
+ <service name="loadAllProductsInProductDimension" auth="true" engine="simple"
+ location="org/ofbiz/bi/DimensionServices.xml" invoke="loadAllProductsInProductDimension">
+ <description>Calls the loadProductInProductDimension service for all the products.</description>
+ <attribute name="updateMode" type="String" mode="IN" optional="true" default-value="TYPE1"/> <!-- TYPE1, TYPE2, TYPE3 -->
+ </service>
+</services>
Propchange: ofbiz/trunk/specialpurpose/bi/servicedef/services_product_olap.xml
------------------------------------------------------------------------------
svn:eol-style = native
Propchange: ofbiz/trunk/specialpurpose/bi/servicedef/services_product_olap.xml
------------------------------------------------------------------------------
svn:keywords = Date Rev Author URL Id
Propchange: ofbiz/trunk/specialpurpose/bi/servicedef/services_product_olap.xml
------------------------------------------------------------------------------
svn:mime-type = text/xml