Premium Partner

Avaloq ACP (DL)

Self-made preparation questions for the "Avaloq Certified Professional" exam

Self-made preparation questions for the "Avaloq Certified Professional" exam

Nicht sichtbar

Nicht sichtbar

Kartei Details

Karten 267
Lernende 148
Sprache English
Kategorie Informatik
Stufe Andere
Erstellt / Aktualisiert 29.01.2013 / 30.11.2023
Lizenzierung Kein Urheberrechtsschutz (CC0)
<iframe src="" width="780" height="150" scrolling="no" frameborder="0"></iframe>

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.

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)

Naming of flat datamarts?

  • dtm_obj_<obj_type>
  • dtm_doc_<transaction type>

How can a flat datamart be found?

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

Naming of hierarchical datamart (report datamart)?

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


Another name for report datamart?

Hierarchical datamart

Purpose of report datamart?

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

Source type of hierarchical datamart?