Report Cube (Venster ID-53078)

Venster: Report Cube

Beschrijving: Define reporting cube for pre-calculation of summary accounting data.

Help: Summary data will be generated for each period of the selected calendar, grouped by the selected dimensions..

TAB: Report Cube

Beschrijving: null

Help null

Bestand:Report Cube - Report Cube - Venster (iDempiere 1.0.0).png

Naam	Naam	Beschrijving	Help	Specificaties
Client	Client	Client/Tenant for this installation.	A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client.	AD_Client_ID numeric(10) NOT NULL Table Direct
Organization	Organization	Organizational entity within client	An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations.	AD_Org_ID numeric(10) NOT NULL Table Direct
Name	Name	Alphanumeric identifier of the entity	The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length.	Name character varying(60) NOT NULL String
Description	Beschrijving	Optional short description of the record	A description is limited to 255 characters.	Description character varying(255) Text
Calendar	Agenda	Accounting Calendar Name	The Calendar uniquely identifies an accounting calendar. Multiple calendars can be used. For example you may need a standard calendar that runs from Jan 1 to Dec 31 and a fiscal calendar that runs from July 1 to June 30.	C_Calendar_ID numeric(10) NOT NULL Table Direct
Active	Actief	The record is active in the system	There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports. There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.	IsActive character(1) Yes-No
Product Dimension	Product Dimension	Include Product as a cube dimension	null	IsProductDim character(1) Yes-No
Business Partner Dimension	Business Partner Dimension	Include Business Partner as a cube dimension	null	IsBPartnerDim character(1) Yes-No
Sales Region Dimension	Sales Region Dimension	Include Sales Region as a cube dimension	null	IsSalesRegionDim character(1) Yes-No
OrgTrx Dimension	OrgTrx Dimension	Include OrgTrx as a cube dimension	null	IsOrgTrxDim character(1) Yes-No
Activity Dimension	Activity Dimension	Include Activity as a cube dimension	null	IsActivityDim character(1) Yes-No
Campaign Dimension	Campaign Dimension	Include Campaign as a cube dimension	null	IsCampaignDim character(1) Yes-No
Project Dimension	Project Dimension	Include Project as a cube dimension	null	IsProjectDim character(1) Yes-No
Project Phase Dimension	Project Phase Dimension	Include Project Phase as a cube dimension	null	IsProjectPhaseDim character(1) Yes-No
Project Task Dimension	Project Task Dimension	Include Project Task as a cube dimension	null	IsProjectTaskDim character(1) Yes-No
GL Budget Dimension	GL Budget Dimension	Include GL Budget as a cube dimension	null	IsGLBudgetDim character(1) Yes-No
Location From Dimension	Location From Dimension	Include Location From as a cube dimension	null	IsLocFromDim character(1) Yes-No
Location To Dimension	Location To Dimension	Include Location To as a cube dimension	null	IsLocToDim character(1) Yes-No
Sub Acct Dimension	Sub Acct Dimension	Include Sub Acct as a cube dimension	null	IsSubAcctDim character(1) Yes-No
User 1 Dimension	User 1 Dimension	Include User 1 as a cube dimension	null	IsUser1Dim character(1) Yes-No
User 2 Dimension	User 2 Dimension	Include User 2 as a cube dimension	null	IsUser2Dim character(1) Yes-No
User Element 1 Dimension	User Element 1 Dimension	Include User Element 1 as a cube dimension	null	IsUserElement1Dim character(1) Yes-No
User Element 2 Dimension	User Element 2 Dimension	Include User Element 2 as a cube dimension	null	IsUserElement2Dim character(1) Yes-No
Last Recalculated	Last Recalculated	The time last recalculated.	null	LastRecalculated timestamp without time zone Date+Time
Process Now	Process Now	null	null	Processing character(1) NOT NULL Yes-No