Differenze tra le versioni di "Data View"

Da itm wiki.
(NAMING CONVENTION)
Riga 2: Riga 2:
  
 
== 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 ==
  
 
The table below reported the prefix used for the most common objectives:
 
The table below reported the prefix used for the most common objectives:
{| class="wikitable"
 
! Prefix Code !! Prefix Name !! Description
 
 
|-
 
|-
|__STD_ || double underscore STD undercore || this is the standard view prefix
+
|_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_ || double underscore STD underscore || This is the standard view prefix
 +
 
 
|}
 
|}
  
Riga 21: Riga 29:
 
|[[BIRT View|Birt View]] || Standard view released with itmSUITE®  
 
|[[BIRT View|Birt View]] || Standard view released with itmSUITE®  
 
|-
 
|-
|Standard Function || Stanard function released with itmSUITE®  
+
|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 delle 08:44, 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 customze 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

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_ || double 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