Window: Report Cube
[Created: 14/05/2009 - Updated: 14/05/2009 ]
Description: 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
[Created: 14/05/2009 - Updated: 14/05/2009 ]
Description:
Help:
Tab Level: 0
Table 10: Report Cube - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | pa_reportcube.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | pa_reportcube.AD_Org_ID numeric(10) Table Direct |
| 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. | pa_reportcube.Name character varying(60) String |
| Description | Optional short description of the record | A description is limited to 255 characters. | pa_reportcube.Description character varying(255) Text |
| Calendar | 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. | pa_reportcube.C_Calendar_ID numeric(10) Table Direct |
| Active | 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. | pa_reportcube.IsActive character(1) Yes-No |
| Product Dimension | Include Product as a cube dimension | pa_reportcube.IsProductDim character(1) Yes-No | |
| Business Partner Dimension | Include Business Partner as a cube dimension | pa_reportcube.IsBPartnerDim character(1) Yes-No | |
| Sales Region Dimension | Include Sales Region as a cube dimension | pa_reportcube.IsSalesRegionDim character(1) Yes-No | |
| OrgTrx Dimension | Include OrgTrx as a cube dimension | pa_reportcube.IsOrgTrxDim character(1) Yes-No | |
| Activity Dimension | Include Activity as a cube dimension | pa_reportcube.IsActivityDim character(1) Yes-No | |
| Campaign Dimension | Include Campaign as a cube dimension | pa_reportcube.IsCampaignDim character(1) Yes-No | |
| Project Dimension | Include Project as a cube dimension | pa_reportcube.IsProjectDim character(1) Yes-No | |
| Project Phase Dimension | Include Project Phase as a cube dimension | pa_reportcube.IsProjectPhaseDim character(1) Yes-No | |
| Project Task Dimension | Include Project Task as a cube dimension | pa_reportcube.IsProjectTaskDim character(1) Yes-No | |
| GL Budget Dimension | Include GL Budget as a cube dimension | pa_reportcube.IsGLBudgetDim character(1) Yes-No | |
| Location From Dimension | Include Location From as a cube dimension | pa_reportcube.IsLocFromDim character(1) Yes-No | |
| Location To Dimension | Include Location To as a cube dimension | pa_reportcube.IsLocToDim character(1) Yes-No | |
| Sub Acct Dimension | Include Sub Acct as a cube dimension | pa_reportcube.IsSubAcctDim character(1) Yes-No | |
| User Element List 1 Dimension | Include User Element List 1 as a cube dimension | pa_reportcube.IsUser1Dim character(1) Yes-No | |
| User Element List 2 Dimension | Include User Element List 2 as a cube dimension | pa_reportcube.IsUser2Dim character(1) Yes-No | |
| User Column 1 Dimension | Include User Element 1 as a cube dimension | pa_reportcube.IsUserElement1Dim character(1) Yes-No | |
| User Column 2 Dimension | Include User Element 2 as a cube dimension | pa_reportcube.IsUserElement2Dim character(1) Yes-No | |
| Last Recalculated | The time last recalculated. | pa_reportcube.LastRecalculated timestamp without time zone Date+Time |