Cubes
The cubes of the OLAP model contain financial and consolidated data, which is translated there, for example, for a currency translation. Imported or specified financial data is saved in the financial cube TFINANC. If accounts have a schedule, it is saved in the detail cube TDETAIC. Segment data is saved in the segment cube TSEGNC. You can specify or import data in these three cubes. You can also perform company journals for correction, revaluation and reclassification, or you can perform these journals on specifically defined consolidation stages.
Select the commandFinancial Consolidation to transfer data into the consolidation cubes TFINANG, TDETAIG, and TSEGMG, where the data is consolidated. Manual or automatic group journals are saved here.
inFurthermore, there are parameter cubes. These cubes contain information on companies, groups, ownership, methods of consolidation, and exchange rates. You administer these cubes in the work spaces Designer.
. You must specify the parameters for each year, period, and scenario. Specify the remaining parameters inCube | Category | Content |
---|---|---|
TFINANC | Data | Financial data |
TDETAIC | Data | Financial data for accounts with schedules |
TSEGMC | Data | Financial data from segmentation |
TFINANG | Data | Consolidated financial data |
TDETAIG | Data | Consolidated financial data from accounts with schedules |
TSEGMG | Data | Consolidated financial data from segmentation |
TNOTES | Data | Notes for external group reports |
TSTAFF | Data | Information about staff |
TFLAGS | Data | Information about consolidation methods and segmentation |
TCOMPPA | Configuration | Company parameters |
TCONSPA | Configuration | Group parameters |
TCONSRL | Configuration | Parameters of the consolidation rules |
TDETPA | Configuration | Parameters of the schedule configuration |
TDETRL | Configuration | Schedule details and settings of consolidation rules |
TRATES | Configuration | Currency rates |
TCHECKS | Configuration | Results of data validation |
TTOPACC | Configuration | Parameters of the chart of accounts |
TSTATUSC | Configuration | Status information of the company data entry |
TSTATUSG | Configuration | Status information of the group data entry |