Avaloq ACP (DL)
Self-made preparation questions for the "Avaloq Certified Professional" exam
Self-made preparation questions for the "Avaloq Certified Professional" exam
Set of flashcards Details
| Flashcards | 267 |
|---|---|
| Students | 151 |
| Language | English |
| Category | Computer Science |
| Level | Other |
| Created / Updated | 29.01.2013 / 07.11.2024 |
| Weblink |
https://card2brain.ch/box/avaloq_acp_dl
|
| Embed |
<iframe src="https://card2brain.ch/box/avaloq_acp_dl/embed" width="780" height="150" scrolling="no" frameborder="0"></iframe>
|
Create or copy sets of flashcards
With an upgrade you can create or copy an unlimited number of sets and use many more additional features.
Log in to see all the cards.
Structure of an AVALOQ TYPE DEF source?
[TYPE 1.0]
type acad:favourites_02
naming
...
record
fav_colour text;
fav_dish text;
end record;
end;
Report Writer: which parts are maintained by Avaloq, which ones by the customer?
Avaloq:
- task definition
- flat datamart definition
Customer:
- report datamart definition
- layout definition
What does the generic workflow command "assign" do?
Assigns a value to a given order field.
What does the generic workflow command "assign" do?
Assigns a value to a given order field.
What does the generic workflow command "book_fast" do?
Updates the booking status of the order's event. In contrast to the (book) command, (book_fast) only
updates existing bookings whereas (book) generates all the bookings of the order.
What does the generic workflow command "clone" do?
Opens a new order of the same order type as the currently open order, and copies some of the data
of the open order into the new order.
What does the generic workflow command "commit" do?
Generates order number (doc.order_nr) for new orders, and either puts the order in a queue of
pending orders waiting to be written to the database (DB) or writes the order and all pending orders
to the DB.
What does the generic workflow command "do_wfc_action" do?
Executes a workflow action on any given order.
What does the generic workflow command "exec" do?
Executes a given sequence of Avaloq Script statements within a workflow action. The statements can
change the data of the order.
What does the generic workflow command "store" do?
Stores the order data in the order persistence layer (in the database).
What does the generic workflow command "store_obj" do?
Stores the object related to the order according to a status in the CODE_HIST_STATUS table. The
statuses used are Discarded (1), Valid (5) and Temporary (8).
What does the generic workflow command "wfc_rule" do?
Explicitly calls the check for workflow rules for the business type of the order. Optionally you can
define a string that must match with the ACTION field in the WFC_RULE_LD table.
What is an "order type"?
E.g. create, modify, etc.
Symbol that can be used to mark a technical user?
- A hash (#) at the beginning of the user name.
- not mandatory, though
Does the general access right "any" disable security for particular data/functionality?
yes
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]
-
- 1 / 267
-
