card2brain.ch

AMI: Where do you specify the creation process of the message handler?

MSG IN Source defenition

AMI: Welche Avaloq script Methoden gibt es zum auslösen einer Message?

settle_now , send_message (--> WF Commands)

gen_ msg

AMI: Write a possible tag

n="4"
a="D"
d="e"
s="N"
t="8"

444d88:

oder 444d8:

Wird aufgerufen mit gen_msg

AMI: Which statement is correct. The message creation process is triggered by

Compilation of new sources

Avaloq script method

compilation of new msg structures

workflow command (book)

Compilation of new sources

Avaloq script method

compilation of new msg structures

workflow command (book)

Werden DDIC ausschliesslich von Avaloq angepasst?

Nein! Aber die meisten schon!

Folgende können angepasst werden:

Structured Extensions
Classes
extn
mem_msg

RW: What are the necessary elemts to create a report

Rep DTM (Hirachical)
Report

--> 2 Sourcen

RW: Is it possible to fill a flat datamart with more then one task in a specific report?

no!!

RW: Identify the correct sequence

Create an Avaloq Tast, create report DTM, create a layout

Create a flat datamart, create a layout, start avaloq task

Create a hirachical datamar, create layout, start task

create a layout, create a flat datamart, start task

Create an Avaloq Tast, create report DTM, create a layout

Create a flat datamart, create a layout, start avaloq task

Create a hirachical datamar, create layout, start task

create a layout, create a flat datamart, start task

RW: What is defined in a hirachical Datamart?

Connect (zu einem DDIC)

Group

Consolidate

RW: How many flat datamarts can be accessed by one report?

1

RW: Which Statement structures the report?

group

statement in Rep DTM source type

RW: Which statement are used to define the variables following the keyword "Consolidate"

Assign (Zweisung DDIC --> DTM)

Inherit (Einlesen eines ganzen Objektes)

RW: Can you use screen reports in other applications then ABS?

No

RW: Why should a historical datamart and report be in seperate sources?

Der DTM kann beispielsweise für andere Report Typen verwendet werden (zB Print Report)

RW: Which ist the aggregation function used to implement a counter ?

sum [1]

RW: Give the variable that is always available at the top level

top

RW: Which statement is correct about CTX

column myCol ctx 'bp' bp.id bp.name

column myCol ctx bp bp.id bp.name

column myCol ctx bp bp-id bp.name

column myCol ctx 'bp' bp-id bp.name

column myCol ctx 'bp' bp.id bp.name

column myCol ctx bp bp.id bp.name

column myCol ctx bp bp-id bp.name

column myCol ctx 'bp' bp-id bp.name

RW: Wie ist das Verhältnis in einem spezifischen Report von Task, DDIC, DTM

1:1:1 !!!

Wie könen Pflichtfelder in den Keys definiert werden

Als Contraint mandarory = true oder in der order validation

Wie kann eine Structured Extension die Felder validiert werden

field_notify

oder

form_notify

What ist the prefered language to write an API?

Commandes clavier:

= tourner,

= avant/arrière,

= faire défiler

PL/SQL

Who can write an API

Commandes clavier:

= tourner,

= avant/arrière,

= faire défiler

Avaloq, Customer

Who can write an API

Commandes clavier:

= tourner,

= avant/arrière,

= faire défiler

Avaloq, Customer

Basyc syntax of an API

Commandes clavier:

= tourner,

= avant/arrière,

= faire défiler

pakage[#].procedure ({Param})

What does API Stand for?

Commandes clavier:

= tourner,

= avant/arrière,

= faire défiler

Applicaton Programming Interface

Source Syntax

Commandes clavier:

= tourner,

= avant/arrière,

= faire défiler

[ ] Optional

{ } Itaration --> Kann n mal vorkommen (beliebig oft)

( ) Grouping

¦ xor Entweder oder

, Addition

x¦...¦y range a¦b¦c

"text" fixed text

Source Status

Commandes clavier:

= tourner,

= avant/arrière,

= faire défiler

- valid (Kompiliert)

- Invalid

-> Error (Fehler beim kompilieren)

--> Corrupt (Kompiliert aber Fehler in de DB)

How do you modify source tables

Commandes clavier:

= tourner,

= avant/arrière,

= faire défiler

in sources

How do you modify code tables?

With sources

with sql developer

with API's

with avaloq script

Commandes clavier:

= tourner,

= avant/arrière,

= faire défiler

With sources

with sql developer

with API's

with avaloq script

Customization is done by:

using scripting and uploading

using scripting and reporting

using parameterisation and scripting

using parameterisation and reporting

Commandes clavier:

= tourner,

= avant/arrière,

= faire défiler

using scripting and uploading

using scripting and reporting

using parameterisation and scripting

using parameterisation and reporting

Any changes or transactions you can perform on objects are

Orders

How do you define the currency of a money account?

Contract

The object model is split into ..... and .... view

internal external

Abbreviation dor

OBJ

DOC

Object

Order

Can OMD sheets be compiled and installed

NO

OMD sheets werden verwendet um ein script zu generieren das entweder per Package insalliert wird, oder direkt auf der DB laufen gelassen wird.

OMD kann nicht kompiliert werden weil es ein PL/SQL Script (BTC) Busines Type Config generiert

What is shown in the orderbook view

Zugewiesene Tasks, Changes Sourcen

ICE: Which information is shown in the information view

Avaloq Invalids

Background Processes

ICE: TASK

Beinhaltet einen Workflow

Enthält immer genau 1 change

ICE: Change

kleinste Liefereinheit von Sourcen

Kann mehrere Sourcen enthalten

ICE: Was ist auf dem ICE Server gespeichert DEV1

Was ist in der Avaloq instance gespeichert?

Custumization Sources

Stream Details

User (Parameterer)

Other Sources (Nicht in der Avaloq instance ersichtlich

Avaloq Instance:

Business Data

User (Banker)

Kernel Sourcfes

Customization Sources

Core Data

AVQ Kurs Zusammenfassung

Cartes-fiches

AVQ Kurs Zusammenfassung

Créer ou copier des fichiers d'apprentissage

Cartes-fiches

Veuillez vous connecter

Google

Apple ID

Microsoft

Switch edu-ID

Edulog

Google

Apple ID

Microsoft

Switch edu-ID

Edulog