Differenze tra le versioni di "Data View"
Da itm wiki.
(→POLICY) |
(→NAMING CONVENTION) |
||
| (7 versioni intermedie di uno stesso utente non sono mostrate) | |||
| Riga 1: | Riga 1: | ||
| − | The objective of this page is to enable the | + | The objective of this page is to enable the Customer to simply access all the information about standard view and the way to customize them. |
== POLICY == | == POLICY == | ||
| + | |||
itmSUITE® enable the customer to create his own report based on standard view that are maintained up to date at each release publishing. | itmSUITE® enable the customer to create his own report based on standard view that are maintained up to date at each release publishing. | ||
| + | |||
| + | * Standard view can be recompiled at each release installation | ||
| + | * Customer can use the standard view but is not allowed to change them. | ||
| + | * Customer can create at SQL level his own views, called custom views. | ||
| + | * Custom View can call the Standard view to avoid creating duplicated objects | ||
== NAMING CONVENTION == | == NAMING CONVENTION == | ||
| − | + | {| class="wikitable" | |
| − | + | ! Prefix Code !! Prefix Name !! Description | |
| + | The table below reported the prefix used for the most common objectives: | ||
| + | |- | ||
| + | |_BWH_ || underscore BWH underscore || Usually used in the customer environment for Business Data Warehouse view | ||
| + | |- | ||
| + | |_CST_ || underscore CST underscore || Usually used in the customer environment for Custom view | ||
| + | |- | ||
| + | |_STD_ || underscore STD underscore || This is the standard view prefix | ||
| + | |} | ||
== SUBJECT TABLES == | == SUBJECT TABLES == | ||
| Riga 17: | Riga 31: | ||
|[[BIRT View|Birt View]] || Standard view released with itmSUITE® | |[[BIRT View|Birt View]] || Standard view released with itmSUITE® | ||
|- | |- | ||
| − | |Standard Function || | + | |[[Standard Function|Standard Function]] || Standard function released with itmSUITE® |
|- | |- | ||
|How to customze a SQL View || Process step to follow to customize a View | |How to customze a SQL View || Process step to follow to customize a View | ||
|} | |} | ||
Versione attuale delle 12:05, 7 mag 2018
The objective of this page is to enable the Customer to simply access all the information about standard view and the way to customize them.
POLICY
itmSUITE® enable the customer to create his own report based on standard view that are maintained up to date at each release publishing.
- Standard view can be recompiled at each release installation
- Customer can use the standard view but is not allowed to change them.
- Customer can create at SQL level his own views, called custom views.
- Custom View can call the Standard view to avoid creating duplicated objects
NAMING CONVENTION
| Prefix Code | Prefix Name | Description
The table below reported the prefix used for the most common objectives: |
|---|---|---|
| _BWH_ | underscore BWH underscore | Usually used in the customer environment for Business Data Warehouse view |
| _CST_ | underscore CST underscore | Usually used in the customer environment for Custom view |
| _STD_ | underscore STD underscore | This is the standard view prefix |
SUBJECT TABLES
This view report some company information. The View's name is: _STD_COMPANY_VIEW
| Entity | Description |
|---|---|
| Birt View | Standard view released with itmSUITE® |
| Standard Function | Standard function released with itmSUITE® |
| How to customze a SQL View | Process step to follow to customize a View |