Business concept AR_INVOICE_PERIODIC_SUMMfor Baan IVc (202293)
INTRODUCTION:
Business Concept solutions can comprehend the following components:
Example:
– Decision Stream component AR_MTHLY_ACCNT_PERIODIC_SUMM_2_0_10.pkg
– SQL Script AR_MTHLY_ACCNT_PERIODIC_SUMM_2_0_10.sql
Considerations with respect to business concept solutions:
– A business concept is infrastructure independent:
It is compatible with the infrastructure version in which it has been developed.
However, when fixes have been applied to the Infrastructure BaanComponents for generic use it is important that these solutions are being applied too, to prevent problems.
– A business concept might be dependent of another business concept.
Therefore, check the compatibility matrix of the Enterprise Analytic the business concept is used in.
– A business concept has a relation with the Business Intelligence Layer.
When fixes have been applied to the Business Intelligence Layer it is important that these solutions are being applied too, to prevent problems.
– The components of a business concept (Extraction dll Baan, extraction model, Decision Stream component, SQL script) should always be compatible with each other, else severe problems might occur.
– A business concept should be upgraded to the latest released solution for the business concept, whenever possible. This means for instance for getting from version 2.0.4 to version 2.0.7, the installation of the solutions for version 2.0.5 and version 2.0.6 in logical order (the solutions are incremental).
However there are situations in which this is not possible (yet):
re-exporting and re-loading the data warehouse are often mandatory actions to perform, when the model has been changed; these actions can require a lot of time, during which the data warehouse data cannot be accessed.
This ‘One Solution per Business Concept’ document has been developed:
– To organize all the individual Scopus solutions that have been released since the GA and/or maintenance release of the Business Concept.
– To find and retrieve solutions for a Business Concept, for any situation that is applicable.
It provides:
– An overview of the Enterprise Analytics the Business Concept is used in.
– An overview of Scopus solutions that have been released so far for the Business Concept, including a reference to the fixed component(s) of the Business Concept.
– An overview with the compatibility of the released solutions and their components.
– General installation procedures for the different components of the template.
– Solution specific installation procedures, in case the general installation procedures do not match.
BUSINESS CONCEPT:
AR_INVOICE_PERIODIC_SUMM for Baan IVc
COMPATIBILITY:
CPM Infrastructure 3.0
Business Intelligence Layer 2.0
Business Intelligence Layer 2.1
ENTERPRISEANALYTICS:
SSA EA Accounts Receivable V2.5 for Baan IVc
SSA EA Accounts Receivable V2.5.1 for Baan IVc
Overview of the Scopus solutions that have been released.
Business Concept version |
Solution number |
Solution summary |
Decision Stream comp. |
SQL Script |
2.0.29 GA |
|
|
|
|
2.0.31 |
203906 |
Bundle of problems in AR Analytic |
|
AR_MTHLY_ACCNT_SUM_UPD_P.SQL |
2.0.34 |
203981 |
Wrong dates used for summary calculation. |
AR_MTHLY_ACCNT_PERIODIC_SUMM_J |
|
2.0.35 GA |
204117 |
Indexes set for AR to improve performance. |
|
AR_MTHLY_ACCNT_PERIODIC_SUMM.SQL |
2.0.37 |
207509 |
Invoice and payment in different currency cause errors in AR Invoice Summary |
|
AR_MTHLY_ACCNT_SUM_UPD_P.SQL |
Overview of the compatibility of this business concept in relation to other available components.
Business Concept version |
Solution number |
Infrastructure 3.0 |
Business Intelligence 2.0/2.1 |
Business Concepts/ Enterprise Analytics |
2.0.29 GA |
|
|
2.0 |
|
2.0.35 GA |
|
|
2.1 |
SSA EA Accounts Receivable V2.5.1 for Baan IVc GA |
INSTALLATION INSTRUCTIONS GENERAL:
Decision Stream component *)
In SQL Server back up the data warehouse and the catalog database.
In Decision Stream back up the catalog.
Put the downloaded and unzipped package in a temporary folder.
Update the catalog with the new package:
– Open the Decision Stream catalog
– Select File Menu
– Select Import package
– Select and open AR_INVOICE_PERIODIC_SUMM_<version>.pkg from the temporary folder
– On the Import Package wizard screen, highlight in ‘Components in package’ window the components as indicated in the solution
– Click Add button
– De-select all the dependent components – they already exist in the catalog
– Click OK
– ‘Components to import’ panel will contain the highlighted components
– Click next
– Click Finish
SQL Script
Put thedownloaded and unzipped SQL scripts in a temporary directory.
This directory will have two folders: one for the SQL Server scripts and one for the Oracle scripts. Dependent of the kind of data warehouse database only one sets of scripts has to be executed.
On SQL Server:
– Execute SQL Query Analyzer (tool of Microsoft SQL Server)
– Connect to the data warehouse server
– Select the data warehouse database
– Select File / Open and browse to the Mssql subfolder in the temporary folder
– Select the SQL script to be executed AR_INVOICE_PERIODIC_SUMM_<version>.sql
– Select Query / Execute
On Oracle:
– Execute SQLPlus Worksheet (tool of Oracle)
– Connect to the data warehouse database
– Select File / Open and browse to the Oracle subfolder in the temporary folder
– Select the SQL script to be executed AR_INVOICE_PERIODIC_SUMM_<version>.sql
– Select Worksheet / Execute
*) Each solution contains an additional SQL script to update the table c_exejobs. This table contains the version number of the Business Concept. The name of the script is UPDATE_VERSION_FOR_AR_INVOICE_PERIODIC_SUMM.sql. Dependent of the kind of data warehouse database the script has to be executed on SQL Server or Oracle.
On SQL Server:
– Execute SQL Query Analyzer (tool of Microsoft SQL Server)
– Connect to the data warehouse server
– Select the data warehouse database
– Select File / Open and browse to the Mssql subfolder in the temporary folder
– Select the SQL script UPDATE_VERSION_FOR_AR_INVOICE_PERIODIC_SUMM.sql
– Select Query / Execute
On Oracle:
– Execute SQLPlus Worksheet (tool of Oracle)
– Connect to the data warehouse database
– Select File / Open and browse to the Oracle subfolder in the temporary folder
– Select the SQL script UPDATE_VERSION_FOR_AR_INVOICE_PERIODIC_SUMM.sql
– Select Worksheet / Execute