Avaloq ACP (DL)
Self-made preparation questions for the "Avaloq Certified Professional" exam
Self-made preparation questions for the "Avaloq Certified Professional" exam
Kartei Details
| Karten | 267 |
|---|---|
| Lernende | 151 |
| Sprache | English |
| Kategorie | Informatik |
| Stufe | Andere |
| Erstellt / Aktualisiert | 29.01.2013 / 07.11.2024 |
| Weblink |
https://card2brain.ch/box/avaloq_acp_dl
|
| Einbinden |
<iframe src="https://card2brain.ch/box/avaloq_acp_dl/embed" 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?
REP DTM
Source type of flat datamart
DDIC
Report writer: which sources are maintained by Avaloq, which ones by the customer?
- Avaloq: task definition/template and flat datamart
- customer: report datamart and layout definition
Sections of a report datamart source?
- header
- datamart
- footer
How does a report datamart connect to the flat datamart?
- connect dtm_obj_bp as dm
- optionally with where [dm.bp.birthdate is not null]
How are the hierarchy levels defined in a report datamart source?
group by
g_domi [dm.domi_country_id] order by [...]
g_bp [dm.bp_id]
Report datamart: how is the data mapped?
consolidate
on g_bp inherit obj_bp -- assigns the whole object
age number assign [...] -- assigns a single field
Report datamart: how can an item count be implemented?
on all
cnt number sum [1]
How is a Report Writer layout source named?
- <task>.<layout>.<optional part>
- Example: task_bp_list.acad$user_02
Source types for Report Writer layouts?
- REP SCREEN
- REP PRINT
- REP FILE
- REP SCRIPT
- REP TABLE
Header of a report datamart source?
[Report 2.0]
report task_bp_list.acad$user_02
Header of a Report Writer layout source?
[Report 2.0]
report task_bp_list.acad$user_02
How is a Report Writer layout coupled to a hierarchical datamart?
datamart acad$user_02 -- task name not required
How is a screen report layout source structured?
screen layout
on column head
...
How is a context icon realised in a Report Writer SCREEN REP source?
column c_myCol1 ctx 'country' g_domicile.id g_domicile.name
Report Writer SCREEN REP source: how are column headers implemented?
on column head
column c_1 align left label 'Name'
column c_2 align left label 'DOB'
SCREEN REPORT source: how is a hierarchy level implemented?
on g_bp head
column c_1 g_bp.name
column c_2 g_bp.birthdate
What elements are necessary to create an Avaloq report?
- task
- flat datamart
- hierarchical datamart
- layout definition
Procedure to implement a new report?
- Select the flat datamart (required fields!)
- Select the task fitting the datamart.
- Select the layout type
- Implement hierarchical datamart
- Implement layout definition based on report datamart.
How can you find out which flat datamart and task match?
"Show" context action on flat datamart source -> "Referenced by" field.
Source types for task definitions and flat datamarts?
TASK DEF and DDIC, respectively
How many flat datamarts can be used for a single report datamart?
only one
What is defined in a hierarchical datamart? Item names?
- connection to flat datamart (connect)
- data hierarchy levels (group by)
- variables (consolidate, on, assign, inherit)
How do we display the variables consolidated in the hierarchical datamart?
We specific hierarchy level and column:
on column g_bp head
column c_1 g_bp.name
Why are hierarchical datamart and layout definition specified in different sources?
A single report datamart can be used as a data source for multiple layout definitions.
How can an error be raised in REP SCREEN when there is no data available?
on report head
if top.seq_nr is null then
session.raise_ui_err(2100);
end if;
What does "css" mean?
customer-site-specific
Where can the private part of sources be inspected?
- in ABS
- not in ice
Where can the private part of sources be inspected?
- in ABS
- not in ice
How can classes, additions and keys be accessed in the DDIC of an object?
via the obj_ext field
How can strings from out_text_norm be accessed?
session.text(<key string>)
How can the DDIC of an object/order displayed in the ABS be accessed?
context-action "Parameterisation" > "Data dictionary"
