svn commit: r618296 - in /ofbiz/trunk/specialpurpose/bi
Locked
 
|
Author: mrisaliti
Date: Mon Feb 4 06:33:42 2008 New Revision: 618296 URL: http://svn.apache.org/viewvc?rev=618296&view=rev Log: All the Business Intelligence forms (ftl/widgets screen) has now the same look and feel (Part of issue OFBIZ-1610) Added: ofbiz/trunk/specialpurpose/bi/config/BiUiLabels.properties (with props) ofbiz/trunk/specialpurpose/bi/config/BiUiLabels_it.properties (with props) Modified: ofbiz/trunk/specialpurpose/bi/webapp/bi/reportbuilder/RenderStarSchemaReport.ftl ofbiz/trunk/specialpurpose/bi/webapp/bi/reportbuilder/SelectStarSchemaFields.ftl ofbiz/trunk/specialpurpose/bi/widget/BiForms.xml ofbiz/trunk/specialpurpose/bi/widget/BiMenus.xml ofbiz/trunk/specialpurpose/bi/widget/BiScreens.xml Added: ofbiz/trunk/specialpurpose/bi/config/BiUiLabels.properties URL: http://svn.apache.org/viewvc/ofbiz/trunk/specialpurpose/bi/config/BiUiLabels.properties?rev=618296&view=auto ============================================================================== --- ofbiz/trunk/specialpurpose/bi/config/BiUiLabels.properties (added) +++ ofbiz/trunk/specialpurpose/bi/config/BiUiLabels.properties Mon Feb 4 06:33:42 2008 @@ -0,0 +1,65 @@ +############################################################################### +# 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. +############################################################################### +BusinessIntelligenceApplication=Business Intelligence Application +BusinessIntelligenceCompanyName=OFBiz: Business Intelligence +BusinessIntelligenceCompanySubtitle=Part of the Open For Business Family of Open Source Software +BusinessIntelligenceCurrentStatus=Current Status +BusinessIntelligenceFieldName=Field Name +BusinessIntelligenceFieldDescription=Field Description +BusinessIntelligenceIntegratedFramework=Business Intelligence Integrated Framework +BusinessIntelligenceMainPage=Main Page +BusinessIntelligenceNote1=This is a proof of concept for an OFBiz integrated framework for business intelligence analysis. +BusinessIntelligenceNote2=The idea is to define a set entities for business intelligence analysis in a separate (olap) database, +BusinessIntelligenceNote3=accessible, in the same way as the main one (oltp), via the delegator. +BusinessIntelligenceNote4=The new olap database, will contain all the entities necessary to datawarehouse analysis: +BusinessIntelligenceNote5=dimensions, facts and star schemas (that are view-entities). +BusinessIntelligenceNote6=The dimensions, facts and star schemas are defined according to best practices for datawarehouses +BusinessIntelligenceNote7=and best practices for OFBiz: they are defined as standard entities using the xml entity defs; +BusinessIntelligenceNote8=clear and consistent naming conventions are used and they are documented +BusinessIntelligenceNote9=by meta data descriptions (in the entity def). +BusinessIntelligenceNote10=The best practices for datawarehouses are mainly taken from the great book "The Data Warehouse Toolkit - Second Edition" by Ralph Kimball. +BusinessIntelligenceNote11=The data for dimensions and facts are maintained and kept up to date using standard OFBiz services +BusinessIntelligenceNote12=(most of them written in minilang to facilitate customizations) and eca rules (easily customizable). +BusinessIntelligenceNote13=The main low level services to post data to the datawarehouse, +BusinessIntelligenceNote14=to map the operational keys with the datawarehouse ones, and to manage +BusinessIntelligenceNote15=history of data changes are already implemented; they will be improved as the datawarehouse will grow (e.g. performance enhancements). +BusinessIntelligenceNote16=The following dimensions (and data services) are defined: CurrencyDimension, DateDimension, ProductDimension; +BusinessIntelligenceNote17=we will have to complete them and design the other ones (the total number of dimension will be probably around 20). +BusinessIntelligenceNote18=Just one fact and one star schema are defined: SalesInvoiceItemFact and SalesInvoiceItemStarSchema. +BusinessIntelligenceNote19=You can quickly initialize the datawarehouse by clicking on the link below: +BusinessIntelligenceNote20=The CurrencyDimension, DateDimension, ProductDimension and the SalesInvoiceItemFact entities will be automatically populated. +BusinessIntelligenceNote21=Then you can run the analysis using the report builder menu. +BusinessIntelligenceNote22=The report builder is a very simple tool that allows you to run +BusinessIntelligenceNote23=the analysis on all the star schemas defined in the system. +BusinessIntelligenceNote24=However, right now there is just one star schema defined: +BusinessIntelligenceNote25=SalesInvoiceItemStarSchema that is a simple "profit and loss" (P&L) analysis. +BusinessIntelligenceNote26=Just select using the checkboxes the fields (columns) you want to see in the report +BusinessIntelligenceNote27=and a simple report will be shown: according to the columns selected the data will be aggregated (drill up/down); +BusinessIntelligenceNote28=all the descriptions you see in the report screens are pulled from the entity definitions. +BusinessIntelligenceNote29=The initialization is needed only once, because the product data and sales invoice data +BusinessIntelligenceNote30=are kept updated by ecas: if you create/update a product or create a new invoice, +BusinessIntelligenceNote31=the new information will be immediately included in the datawarehouse analysis. +BusinessIntelligenceQuickInitDataWarehouse=Quick Init DataWarehouse +BusinessIntelligenceQuickStartGuide=Quick Start Guide +BusinessIntelligenceRenderTheReport=Render the Report +BusinessIntelligenceReportBuilder=Report Builder +BusinessIntelligenceReportBuilderRenderStarSchemaReport=Render Star Schema Report +BusinessIntelligenceReportBuilderSelectStarSchema=Select Star Schema +BusinessIntelligenceReportBuilderSelectStarSchemaFields=Select Star Schema Fields +BusinessIntelligenceReportBuilderSelectTheStarSchemaReport=Select the start schema (report) \ No newline at end of file Propchange: ofbiz/trunk/specialpurpose/bi/config/BiUiLabels.properties ------------------------------------------------------------------------------ svn:eol-style = native Propchange: ofbiz/trunk/specialpurpose/bi/config/BiUiLabels.properties ------------------------------------------------------------------------------ svn:keywords = "Date Rev Author URL Id" Propchange: ofbiz/trunk/specialpurpose/bi/config/BiUiLabels.properties ------------------------------------------------------------------------------ svn:mime-type = text/plain Added: ofbiz/trunk/specialpurpose/bi/config/BiUiLabels_it.properties URL: http://svn.apache.org/viewvc/ofbiz/trunk/specialpurpose/bi/config/BiUiLabels_it.properties?rev=618296&view=auto ============================================================================== --- ofbiz/trunk/specialpurpose/bi/config/BiUiLabels_it.properties (added) +++ ofbiz/trunk/specialpurpose/bi/config/BiUiLabels_it.properties Mon Feb 4 06:33:42 2008 @@ -0,0 +1,65 @@ +############################################################################### +# 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. +############################################################################### +BusinessIntelligenceApplication=Applicazione Business Intelligence +BusinessIntelligenceCompanyName=OFBiz: Business Intelligence +BusinessIntelligenceCompanySubtitle=Part of the Open For Business Family of Open Source Software +BusinessIntelligenceCurrentStatus=Stato Attuale +BusinessIntelligenceFieldName=Nome Campo +BusinessIntelligenceFieldDescription=Descrizione Campo +BusinessIntelligenceIntegratedFramework=Business Intelligence Framework Integrato +BusinessIntelligenceMainPage=Pagina Principale +BusinessIntelligenceNote1=Questo รจ un prototipo per un OFBiz framework integrato per analisi di business intelligence. +BusinessIntelligenceNote2=L\'idea \u00e8 di definire un\'insieme di entit\u00e0 per le analisi di business intelligence in un database (olap) separato, +BusinessIntelligenceNote3=accessibile, nello stesso modo di quello principale (oltp), attraverso un delegator. +BusinessIntelligenceNote4=Il nuovo database olap, conterr\u00e0 tutte le entit\u00e0 necessarie alle analisi di datawarehouse: +BusinessIntelligenceNote5=dimensioni, fatti e star schemas (queste sono view-entities). +BusinessIntelligenceNote6=Le dimensioni, fatti e star schemas sono definiti in accordo alle migliori pratiche per i datawarehouses +BusinessIntelligenceNote7=e le migliori pratiche per OFBiz: queste sono definite come entit\u00e0 standard usando le definizioni xml entity; +BusinessIntelligenceNote8=corretti e consistenti convenzione nei nomi sono usati and sono documentati +BusinessIntelligenceNote9=dalle descrizione dei meta dati (nella definizione entit\u00e0). +BusinessIntelligenceNote10=Le migliori pratiche per i datawarehouses sono stati ricavati dal grande libro "The Data Warehouse Toolkit - Second Edition" di Ralph Kimball. +BusinessIntelligenceNote11=I dati per dimensioni e fatti sono manutenibili e mantenuti aggiornati usando gli standard dei servizi OFBiz +BusinessIntelligenceNote12=(molti dei quali sono scritti utizzando minilang per facilitare le personalizzazioni) e le regole eca (facilmente personalizzabili). +BusinessIntelligenceNote13=I servizi principali a basso livello per ricavare i dati del datawarehouse, +BusinessIntelligenceNote14=la mappa di chiavi operazionali con il datawarehouse, e la gestione +BusinessIntelligenceNote15=storia di cambio di dati che sono gi\u00e0 implementati; sar\u00e0 aumentato di caratteristiche non appena crescer\u00e0 il datawarehouse (e.g. aumento prestazioni). +BusinessIntelligenceNote16=Le seguenti dimensioni (e servizi dei dati) sono definiti: CurrencyDimension, DateDimension, ProductDimension; +BusinessIntelligenceNote17=verranno usati per completare questi e disegnare gli altri (il numero totale di dimensioni saranno probabilmente circa 20). +BusinessIntelligenceNote18=Solo un fatto e uno star schema sono definiti: SalesInvoiceItemFact e SalesInvoiceItemStarSchema. +BusinessIntelligenceNote19=Tu puoi velocemente inizializzare il datawarehouse facendo click sul link qui sotto: +BusinessIntelligenceNote20=Le entit\u00e0 CurrencyDimension, DateDimension, ProductDimension e SalesInvoiceItemFact saranno caricate automaticamente. +BusinessIntelligenceNote21=Dopo tu puoi eseguire analisi usando il menu costruzione report. +BusinessIntelligenceNote22=La costruzione report \u00e8 un vero strumento semplice che ti permette di eseguire +BusinessIntelligenceNote23=le analisi su tutti i star schemas definiti nel sistema. +BusinessIntelligenceNote24=Comunque, fino adesso c\'\u00e8 solo un star schema definito: +BusinessIntelligenceNote25=SalesInvoiceItemStarSchema che \u00e8 una semplice analisi di "profit and loss" (P&L). +BusinessIntelligenceNote26=Appena selezionato i campi dei checkboxes (colonne) tu vorrai vedere +BusinessIntelligenceNote27=e un semplice report verr\u00e0 mostrato: in accordo alle colonne selezionate i dati verranno aggregati (drill up/down); +BusinessIntelligenceNote28=tutte le descrizioni che tu vedrai nelle scrermate del report sono prelevare dalla definizioni delle entit\u00e0. +BusinessIntelligenceNote29=L\'inizializzazione \u00e8 necessaria solo una volta, perch\u00e8 i dati del prodotti e i dati delle fatture di vendita +BusinessIntelligenceNote30=sono mantenute aggiornate dagli ecas: se tu crei/aggiorni un prodotto o creare una nuova fattura, +BusinessIntelligenceNote31=la nuova informazione sar\u00e0 immediatamente inclusa nelle analisi del datawarehouse. +BusinessIntelligenceQuickInitDataWarehouse=Inizializzazione Veloce DataWarehouse +BusinessIntelligenceQuickStartGuide=Guida Rapida +BusinessIntelligenceRenderTheReport=Visualizza il Report +BusinessIntelligenceReportBuilder=Costruzione Report +BusinessIntelligenceReportBuilderRenderStarSchemaReport=Visualizza Report Star Schema +BusinessIntelligenceReportBuilderSelectStarSchema=Seleziona Star Schema +BusinessIntelligenceReportBuilderSelectStarSchemaFields=Seleziona Campi Star Schema +BusinessIntelligenceReportBuilderSelectTheStarSchemaReport=Seleziona lo start schema (report) \ No newline at end of file Propchange: ofbiz/trunk/specialpurpose/bi/config/BiUiLabels_it.properties ------------------------------------------------------------------------------ svn:eol-style = native Propchange: ofbiz/trunk/specialpurpose/bi/config/BiUiLabels_it.properties ------------------------------------------------------------------------------ svn:keywords = "Date Rev Author URL Id" Propchange: ofbiz/trunk/specialpurpose/bi/config/BiUiLabels_it.properties ------------------------------------------------------------------------------ svn:mime-type = text/plain Modified: ofbiz/trunk/specialpurpose/bi/webapp/bi/reportbuilder/RenderStarSchemaReport.ftl URL: http://svn.apache.org/viewvc/ofbiz/trunk/specialpurpose/bi/webapp/bi/reportbuilder/RenderStarSchemaReport.ftl?rev=618296&r1=618295&r2=618296&view=diff ============================================================================== --- ofbiz/trunk/specialpurpose/bi/webapp/bi/reportbuilder/RenderStarSchemaReport.ftl (original) +++ ofbiz/trunk/specialpurpose/bi/webapp/bi/reportbuilder/RenderStarSchemaReport.ftl Mon Feb 4 06:33:42 2008 @@ -17,7 +17,7 @@ under the License. --> -<table cellspacing="0" class="basic-table form-widget-table dark-grid"> +<table cellspacing="0" class="basic-table hover-bar"> <tr class="header-row"> <#list columnNames as columnName> <td> @@ -25,8 +25,9 @@ </td> </#list> </tr> + <#assign alt_row = false> <#list records as record> - <tr> + <tr valign="middle"<#if alt_row> class="alternate-row"</#if>> <#list columnNames as columnName> <#assign columnValue = record[columnName]?default("")> <td<#if columnValue?is_number> class="align-text"</#if>> @@ -34,6 +35,7 @@ </td> </#list> </tr> + <#-- toggle the row color --> + <#assign alt_row = !alt_row> </#list> - -</table> +</table> \ No newline at end of file Modified: ofbiz/trunk/specialpurpose/bi/webapp/bi/reportbuilder/SelectStarSchemaFields.ftl URL: http://svn.apache.org/viewvc/ofbiz/trunk/specialpurpose/bi/webapp/bi/reportbuilder/SelectStarSchemaFields.ftl?rev=618296&r1=618295&r2=618296&view=diff ============================================================================== --- ofbiz/trunk/specialpurpose/bi/webapp/bi/reportbuilder/SelectStarSchemaFields.ftl (original) +++ ofbiz/trunk/specialpurpose/bi/webapp/bi/reportbuilder/SelectStarSchemaFields.ftl Mon Feb 4 06:33:42 2008 @@ -19,20 +19,21 @@ <form action="<@ofbizUrl>ReportBuilderRenderStarSchemaReport</@ofbizUrl>"> <input type="hidden" name="starSchemaName" value="${starSchemaName}"/> - <table cellspacing="0" class="basic-table form-widget-table dark-grid"> + <table cellspacing="0" class="basic-table hover-bar"> <tr class="header-row"> <td> - Select + ${uiLabelMap.CommonSelect} </td> <td> - Field Name + ${uiLabelMap.BusinessIntelligenceFieldName} </td> <td> - Field Description + ${uiLabelMap.BusinessIntelligenceFieldDescription} </td> </tr> + <#assign alt_row = false> <#list starSchemaFields as starSchemaField> - <tr> + <tr valign="middle"<#if alt_row> class="alternate-row"</#if>> <td> <input name="selectedField" value="${starSchemaField.name}" type="checkbox"/> </td> @@ -43,11 +44,13 @@ ${starSchemaField.description?default("")} </td> </tr> + <#-- toggle the row color --> + <#assign alt_row = !alt_row> </#list> <tr> <td colspan="3"> - <input name="submitButton" type="submit" value="Render the Report"/> + <input name="submitButton" type="submit" value="${uiLabelMap.BusinessIntelligenceRenderTheReport}"/> </td> </tr> </table> -</form> +</form> \ No newline at end of file Modified: ofbiz/trunk/specialpurpose/bi/widget/BiForms.xml URL: http://svn.apache.org/viewvc/ofbiz/trunk/specialpurpose/bi/widget/BiForms.xml?rev=618296&r1=618295&r2=618296&view=diff ============================================================================== --- ofbiz/trunk/specialpurpose/bi/widget/BiForms.xml (original) +++ ofbiz/trunk/specialpurpose/bi/widget/BiForms.xml Mon Feb 4 06:33:42 2008 @@ -3,11 +3,12 @@ <forms xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="http://ofbiz.apache.org/dtds/widget-form.xsd"> - <form name="selectStarSchema" title="" type="single" target="ReportBuilderSelectStarSchemaFields"> + <form name="selectStarSchema" title="" type="single" target="ReportBuilderSelectStarSchemaFields" + header-row-style="header-row" default-table-style="basic-table"> <actions> <script location="component://bi/webapp/bi/WEB-INF/actions/reportbuilder/getStarSchemas.bsh"/> </actions> - <field name="starSchemaName" title="Select the star schema (report)"> + <field name="starSchemaName" title="${uiLabelMap.BusinessIntelligenceReportBuilderSelectTheStarSchemaReport}"> <drop-down allow-empty="false"> <list-options list-name="starSchemas" key-name="name" description="${title}"/> </drop-down> @@ -17,7 +18,8 @@ </field> </form> - <form name="SalesInvoiceItemStarSchema" list-name="invoiceItemFacts" title="" type="list"> + <form name="SalesInvoiceItemStarSchema" list-name="invoiceItemFacts" title="" type="list" + odd-row-style="alternate-row" default-table-style="basic-table hover-bar"> <actions> <entity-condition entity-name="SalesInvoiceItemStarSchema" list-name="invoiceItemFacts"> <select-field field-name="invoiceDateDayName"/> @@ -31,4 +33,4 @@ <field name="extGrossAmount"><display/></field> <field name="quantity"><display/></field> </form> -</forms> +</forms> \ No newline at end of file Modified: ofbiz/trunk/specialpurpose/bi/widget/BiMenus.xml URL: http://svn.apache.org/viewvc/ofbiz/trunk/specialpurpose/bi/widget/BiMenus.xml?rev=618296&r1=618295&r2=618296&view=diff ============================================================================== --- ofbiz/trunk/specialpurpose/bi/widget/BiMenus.xml (original) +++ ofbiz/trunk/specialpurpose/bi/widget/BiMenus.xml Mon Feb 4 06:33:42 2008 @@ -21,7 +21,7 @@ <menu name="BiAppBar" default-menu-item-name="main" id="app-navigation" type="simple" title="${uiLabelMap.BusinessIntelligenceApplication}" default-selected-style="selected" selected-menuitem-context-field-name="headerItem"> <menu-item name="main" title="${uiLabelMap.CommonMain}"><link target="main"/></menu-item> - <menu-item name="reportbuilder" title="${uiLabelMap.ReportBuilder}"><link target="ReportBuilderSelectStarSchema"/></menu-item> + <menu-item name="reportbuilder" title="${uiLabelMap.BusinessIntelligenceReportBuilder}"><link target="ReportBuilderSelectStarSchema"/></menu-item> <menu-item name="Logout" title="Logout" align-style="col-right" selected-style="selected"> <condition><not><if-empty field-name="userLogin"/></not></condition> @@ -32,4 +32,4 @@ <link target="${checkLoginUrl}"/> </menu-item> </menu> -</menus> +</menus> \ No newline at end of file Modified: ofbiz/trunk/specialpurpose/bi/widget/BiScreens.xml URL: http://svn.apache.org/viewvc/ofbiz/trunk/specialpurpose/bi/widget/BiScreens.xml?rev=618296&r1=618295&r2=618296&view=diff ============================================================================== --- ofbiz/trunk/specialpurpose/bi/widget/BiScreens.xml (original) +++ ofbiz/trunk/specialpurpose/bi/widget/BiScreens.xml Mon Feb 4 06:33:42 2008 @@ -24,10 +24,11 @@ <section> <actions> <!-- base/top/specific map first, then more common map added for shared labels --> + <property-map resource="BiUiLabels" map-name="uiLabelMap" global="true"/> <property-map resource="CommonUiLabels" map-name="uiLabelMap" global="true"/> - <set field="layoutSettings.companyName" value="OFBiz : Business Intelligence" global="true"/> - <set field="layoutSettings.companySubtitle" from-field="uiLabelMap.ManufacturingCompanySubtitle" global="true"/> + <set field="layoutSettings.companyName" from-field="uiLabelMap.BusinessIntelligenceCompanyName" global="true"/> + <set field="layoutSettings.companySubtitle" from-field="uiLabelMap.BusinessIntelligenceCompanySubtitle" global="true"/> <set field="activeApp" value="bi" global="true"/> <set field="applicationMenuName" value="BiAppBar" global="true"/> <set field="applicationMenuLocation" value="component://bi/widget/BiMenus.xml" global="true"/> @@ -40,12 +41,26 @@ <screen name="ReportBuilderSelectStarSchema"> <section> <actions> + <set field="titleProperty" value="BusinessIntelligenceReportBuilderSelectStarSchema"/> <set field="headerItem" value="reportbuilder"/> </actions> <widgets> <decorator-screen name="main-decorator" location="${parameters.mainDecoratorLocation}"> <decorator-section name="body"> - <include-form name="selectStarSchema" location="component://bi/widget/BiForms.xml"/> + <container style="screenlet"> + <container style="screenlet-title-bar"> + <container style="head3"> + <label text="${uiLabelMap.BusinessIntelligenceReportBuilderSelectStarSchema}"/> + </container> + </container> + <container style="screenlet-body"> + <section> + <widgets> + <include-form name="selectStarSchema" location="component://bi/widget/BiForms.xml"/> + </widgets> + </section> + </container> + </container> </decorator-section> </decorator-screen> </widgets> @@ -54,15 +69,29 @@ <screen name="ReportBuilderSelectStarSchemaFields"> <section> <actions> + <set field="titleProperty" value="BusinessIntelligenceReportBuilderSelectStarSchemaFields"/> <set field="headerItem" value="reportbuilder"/> <script location="component://bi/webapp/bi/WEB-INF/actions/reportbuilder/getStarSchemaFields.bsh"/> </actions> <widgets> <decorator-screen name="main-decorator" location="${parameters.mainDecoratorLocation}"> <decorator-section name="body"> - <platform-specific> - <html><html-template location="component://bi/webapp/bi/reportbuilder/SelectStarSchemaFields.ftl"/></html> - </platform-specific> + <container style="screenlet"> + <container style="screenlet-title-bar"> + <container style="head3"> + <label text="${uiLabelMap.BusinessIntelligenceReportBuilderSelectStarSchemaFields}"/> + </container> + </container> + <container style="screenlet-body"> + <section> + <widgets> + <platform-specific> + <html><html-template location="component://bi/webapp/bi/reportbuilder/SelectStarSchemaFields.ftl"/></html> + </platform-specific> + </widgets> + </section> + </container> + </container> </decorator-section> </decorator-screen> </widgets> @@ -71,15 +100,29 @@ <screen name="ReportBuilderRenderStarSchemaReport"> <section> <actions> + <set field="titleProperty" value="BusinessIntelligenceReportBuilderRenderStarSchemaReport"/> <set field="headerItem" value="reportbuilder"/> <script location="component://bi/webapp/bi/WEB-INF/actions/reportbuilder/runStarSchemaQuery.bsh"/> </actions> <widgets> <decorator-screen name="main-decorator" location="${parameters.mainDecoratorLocation}"> <decorator-section name="body"> - <platform-specific> - <html><html-template location="component://bi/webapp/bi/reportbuilder/RenderStarSchemaReport.ftl"/></html> - </platform-specific> + <container style="screenlet"> + <container style="screenlet-title-bar"> + <container style="head3"> + <label text="${uiLabelMap.BusinessIntelligenceReportBuilderRenderStarSchemaReport}"/> + </container> + </container> + <container style="screenlet-body"> + <section> + <widgets> + <platform-specific> + <html><html-template location="component://bi/webapp/bi/reportbuilder/RenderStarSchemaReport.ftl"/></html> + </platform-specific> + </widgets> + </section> + </container> + </container> </decorator-section> </decorator-screen> </widgets> @@ -89,6 +132,7 @@ <screen name="main"> <section> <actions> + <set field="titleProperty" value="BusinessIntelligenceMainPage"/> <set field="headerItem" value="main"/> <set field="fromDate" value="2007-01-01 00:00:00.0" type="Timestamp"/> <set field="thruDate" value="2008-01-01 00:00:00.0" type="Timestamp"/> @@ -97,103 +141,103 @@ <decorator-screen name="main-decorator" location="${parameters.mainDecoratorLocation}"> <decorator-section name="body"> <container> - <label style="head1">Business Intelligence integrated framework</label> + <label style="head1">${uiLabelMap.BusinessIntelligenceIntegratedFramework}</label> </container> <container> <label> - This is a proof of concept for an OFBiz integrated framework for business intelligence analysis. + ${uiLabelMap.BusinessIntelligenceNote1} </label> </container> <container> <label> - The idea is to define a set entities for business intelligence analysis in a separate (olap) database, - accessible, in the same way as the main one (oltp), via the delegator. + ${uiLabelMap.BusinessIntelligenceNote2} + ${uiLabelMap.BusinessIntelligenceNote3} </label> </container> <container> <label> - The new olap database, will contain all the entities necessary to datawarehouse analysis: - dimensions, facts and star schemas (that are view-entities). + ${uiLabelMap.BusinessIntelligenceNote4} + ${uiLabelMap.BusinessIntelligenceNote5} </label> </container> <container> <label> - The dimensions, facts and star schemas are defined according to best practices for datawarehouses - and best practices for OFBiz: they are defined as standard entities using the xml entity defs; - clear and consistent naming conventions are used and they are documented - by meta data descriptions (in the entity def). + ${uiLabelMap.BusinessIntelligenceNote6} + ${uiLabelMap.BusinessIntelligenceNote7} + ${uiLabelMap.BusinessIntelligenceNote8} + ${uiLabelMap.BusinessIntelligenceNote9} </label> </container> <container> <label> - The best practices for datawarehouses are mainly taken from the great book "The Data Warehouse Toolkit - Second Edition" by Ralph Kimball. + ${uiLabelMap.BusinessIntelligenceNote10} </label> </container> <container> <label> - The data for dimensions and facts are maintained and kept up to date using standard OFBiz services - (most of them written in minilang to facilitate customizations) and eca rules (easily customizable). + ${uiLabelMap.BusinessIntelligenceNote11} + ${uiLabelMap.BusinessIntelligenceNote12} </label> </container> <container> <label style="head3"> - Current Status + ${uiLabelMap.BusinessIntelligenceCurrentStatus} </label> </container> <container> <label> - The main low level services to post data to the datawarehouse, - to map the operational keys with the datawarehouse ones, and to manage - history of data changes are already implemented; they will be improved as the datawarehouse will grow (e.g. performance enhancements). + ${uiLabelMap.BusinessIntelligenceNote13} + ${uiLabelMap.BusinessIntelligenceNote14} + ${uiLabelMap.BusinessIntelligenceNote15} </label> </container> <container> <label> - The following dimensions (and data services) are defined: CurrencyDimension, DateDimension, ProductDimension; - we will have to complete them and design the other ones (the total number of dimension will be probably around 20). + ${uiLabelMap.BusinessIntelligenceNote16} + ${uiLabelMap.BusinessIntelligenceNote17} </label> </container> <container> <label> - Just one fact and one star schema are defined: SalesInvoiceItemFact and SalesInvoiceItemStarSchema. + ${uiLabelMap.BusinessIntelligenceNote18} </label> </container> <container> <label style="head3"> - Quick Start Guide + ${uiLabelMap.BusinessIntelligenceQuickStartGuide} </label> </container> <container> <label> - You can quickly initialize the datawarehouse by clicking on the link below: - The CurrencyDimension, DateDimension, ProductDimension and the SalesInvoiceItemFact entities will be automatically populated. + ${uiLabelMap.BusinessIntelligenceNote19} + ${uiLabelMap.BusinessIntelligenceNote20} </label> </container> <container> <label> - Then you can run the analysis using the report builder menu. - The report builder is a very simple tool that allows you to run - the analysis on all the star schemas defined in the system. - However, right now there is just one star schema defined: - SalesInvoiceItemStarSchema that is a simple "profit and loss" (P&L) analysis. + ${uiLabelMap.BusinessIntelligenceNote21} + ${uiLabelMap.BusinessIntelligenceNote22} + ${uiLabelMap.BusinessIntelligenceNote23} + ${uiLabelMap.BusinessIntelligenceNote24} + ${uiLabelMap.BusinessIntelligenceNote25} </label> </container> <container> <label> - Just select using the checkboxes the fields (columns) you want to see in the report - and a simple report will be shown: according to the columns selected the data will be aggregated (drill up/down); - all the descriptions you see in the report screens are pulled from the entity definitions. + ${uiLabelMap.BusinessIntelligenceNote26} + ${uiLabelMap.BusinessIntelligenceNote27} + ${uiLabelMap.BusinessIntelligenceNote28} </label> </container> <container> - <link target="quickInitDataWarehouse?fromDate=${fromDate}&thruDate=${thruDate}" text="Quick Init DataWarehouse" style="buttontext"/> - <label> (from date ${fromDate} thru date ${thruDate})</label> + <link target="quickInitDataWarehouse?fromDate=${fromDate}&thruDate=${thruDate}" text="${uiLabelMap.BusinessIntelligenceQuickInitDataWarehouse}" style="buttontext"/> + <label> (${uiLabelMap.CommonFromDate} ${fromDate} ${uiLabelMap.CommonThruDate} ${thruDate})</label> </container> <container> <label> - The initialization is needed only once, because the product data and sales invoice data - are kept updated by ecas: if you create/update a product or create a new invoice, - the new information will be immediately included in the datawarehouse analysis. + ${uiLabelMap.BusinessIntelligenceNote29} + ${uiLabelMap.BusinessIntelligenceNote30} + ${uiLabelMap.BusinessIntelligenceNote31} </label> </container> </decorator-section> @@ -201,5 +245,4 @@ </widgets> </section> </screen> -</screens> - +</screens> \ No newline at end of file |
«
Return to OFBiz - Commits
|
1 view|%1 views
| Free forum by Nabble | Edit this page |