Lernkarten

Dominik Langer
Karten 267 Karten
Lernende 147 Lernende
Sprache English
Stufe Andere
Erstellt / Aktualisiert 29.01.2013 / 01.12.2022
Lizenzierung Kein Urheberrechtsschutz (CC0)
Weblink
Einbinden
0 Exakte Antworten 267 Text Antworten 0 Multiple Choice Antworten
Fenster schliessen

A task consists of (source types)?

  • a task definition (TASK DEF): what the task does
  • a task template (TASK TEMPL): defines parameter list

Per task definition 1..n task templates.

Fenster schliessen

Which layers does the Report Writer have?

  • kernel layer: core programs to extract data from DB
  • task definition: interface between the other two layers; flat datamart (DDIC)
  • report definition: hierarchical datamart definition (REP DTM)
    • layout definition (5 types)
Fenster schliessen

Naming of flat datamarts?

  • dtm_obj_<obj_type>
  • dtm_doc_<transaction type>
Fenster schliessen

How can a flat datamart be found?

Like any other data dictionary: Task and Reporting Desk, keyword "data dict"

Fenster schliessen

Naming of hierarchical datamart (report datamart)?

  • Example: task_pos_list.acad$my_report
  • <task name>.<datamart name incl. NS>

 

Fenster schliessen

Another name for report datamart?

Hierarchical datamart

Fenster schliessen

Purpose of report datamart?

  • provide data for layout including consolidation (sorting and grouping) and aggregation (calculations like sum)
Fenster schliessen

Source type of hierarchical datamart?

REP DTM