Modelling Functions

Question 1

Restricted Col can be created in

Answer 1

Star Join Node or Aggregation Node.

Question 2

Restricted Col( Multiple restriction)

Answer 2

1. Multiple Restriction on Same Col are added as OR
2. Different col are added as AND.
3. Order does not matter.

Question 3

Restricted Columns can include SQL Expressions

Answer 3

1. Yes, and can also include String or Date function.
2. Calculated Columns,
3. Default value for variables and input parameter.
4. Filters.

Question 4

Calculated Column.

1) Try to do the calculation before aggregation , specially if it is Multiplacation or Division.
2) If calculations are just additions or substractions it is not required.

Answer 4

True.

Question 5

Persistence of the Calculated columns

Answer 5

1. Materilazed Table using Write optimized Procedure.

2. SLT or DS to load it.

Question 6

Expression in the calculated Column

Answer 6

1. SQL.

2. Column Engine.

Question 7

Filters can be applied to following

Answer 7

1. Projection
2. Union
3. Join
4. Rank
5. Aggregation( New capability 2.0 SPS03)
6. Star Join.( New capability 2.0 SPS03)

Question 8

Recommendation in Filer Node

1) SQL Engine
2) Col Engine expression

Answer 8

SQL Engine.

Question 9

Filter Applied on Top Node

Answer 9

E.g Star Node or Aggregation Node , filter is applied before the data processing of that node.

Question 10

Filter on Non Top Nodes

Answer 10

Filter is applied after the Aggregation of the node.

Question 11

Ignore Multiple Output for filters Property

Answer 11

Nodes Consumed by multiple Nodes , prevent Filter Pushdown.

Property “Ignore Multiple Outputs for Filters” can be set.

Question 12

“Ignore Multiple Output Property” at View level on Semantics

Answer 12

Scenarios where view is consumed multiple times by others.

Question 13

Variables allow filtering Measures.

Answer 13

False only allow attribute.

Question 14

Client Information in XSA

Answer 14

1. we need to define which col is the Client in the table.

2. Need to set the client information in the Semantics.

Question 15

Variables can be

Answer 15

1. Single value
2. Range
3. Interval

Question 16

One variable can be assigned to multiple columbs

Answer 16

True.

Question 17

Variables Value help using Hierarchy

Answer 17

1. If Parent Child hierarchy is used, Variable attribute col must be defined as Parent Attribute.
2. If Level hierarchy is reffered , the variable attribuet must be defined as Leaf Level.

Question 18

Input parameter

Answer 18

1. Calculated Columns.
2. Restricted Measures.
3. Filter Expression.
4. Scalar/ Table function.

Question 19

Without mapping of the Input parameter and variables are ignored .

Answer 19

True.

Question 20

Level Hierarchy Options

Answer 20

1. Root Nodes.
2. Error- Throw error.
3. Ignore- Will be ignored.
4. Step Parent.

Question 21

Time dependeny Hierarchy

Answer 21

Only possible in Cal View for Parent Child Hierarchy.

Question 22

Currency Conversion

Answer 22

Reuse-

1. reference
2. Copy

Question 23

Currency Conversion

Answer 23

Decimal Shift using TCURX