svn commit: r677299 - in /ofbiz/trunk/specialpurpose/bi: ./ data/ entitydef/ servicedef/

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

svn commit: r677299 - in /ofbiz/trunk/specialpurpose/bi: ./ data/ entitydef/ servicedef/

jacopoc
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