General

Question 1

Does the staging database have security?

Answer 1

No

Question 2

What is the language the cube is stored in?

Answer 2

XMLA

Question 3

How do you strip security out of the cube?

Answer 3

When you run the cube, set load security to false on the cube settings screen. Alternatively you can have it run as custom user in ZapBi

Question 4

WIP

Answer 4

Work in Process

Question 5

Current Assets

Answer 5

Total Cash (and Equivalents) Securities, Other Current Assets, Production inventory including WIP, and Intangible Assets

Question 6

Current Assets Accounting Definition

Answer 6

A current asset is cash and any other company asset that will be turning to cash within one year from the date shown in the heading of the company’s balance sheet.

Question 7

Total Assets (formula)

Answer 7

Current Assets + Non Current Assets

Question 8

When is Lite Mode automatically selected?

Answer 8

The dimension has more than 1 million rowsOnly the corresponding measure group has relations to the dimension. (only one measure group relates)

Question 9

When Lite Mode is enabled

Answer 9

All row-level detail is removed. Only attribute, level, and hierarchy attribute types will be available.Non-fact relationships are removedAll attributes are removed that have more than 200 distinct values, or if the values are more than 20% distinct.No drill through to the dimension’s granular transactions

Question 10

ApplyUserCustomizationsBeforeTableStructureChanges SP

Answer 10

This SP runs first, before anything moves. here you would load in excels, other loads kevin has a script to load excel, backs up He loads any data that didn’t originate within DAX goes to a separate databasekick off jobs created in SSIS these databases will be merged in staging any predataloading transformations.

Question 11

ApplyUserCustomizationsAfterMainDataMigration

Answer 11

Runs 2nd, most of the time not used

Question 12

ApplyUserCustomizationsAfterMigrationComplete

Answer 12

any fields you told it to build would have already been builtthis is where you always do your transformationif you use subselects in staging configuration, it will be a bitch to document, better to use this sp but you need to create the fields in CX

Question 13

Include in data only update caveat

Answer 13

data only update won’t make sense to apply to a dimension table, because this would trigger a full structure update.

Question 14

Benefits of breaking records into batches during load

Answer 14

Avoiding latency due to network instability, or because of memory limitations

Question 15

Caveat about hierarchies

Answer 15

Don’t allow attributes to be defaulted to hierarchies. if you want hierarchies, you build themif you add a field in staging, double check it in cube configuration

Question 16

what color are member properties in cube config?

Answer 16

gray

Question 17

Parent child hierarchy

Answer 17

there are two columns, one with a parent and one with a child, can represent multiple layers of a hierarchy

Question 18

process cube offline does what?

Answer 18

Takes the cube offline and processes. This frees up memory, typical of a full load.

Question 19

Why do you run a full load once a week

Answer 19

Incremental handles changes, not deletes. The record is gone from the source, but staging hasn’t been updated with this change.

Question 20

two important things for a Zap Consultant

Answer 20

Functions and Dates

Question 21

Contains Member Function

Answer 21

Under logical. If contains member (laptop in product)

Question 22

Single dot in dimension tree

Answer 22

level

Question 23

ways to hide custom formula

Answer 23

on filter, or rename to space

Question 24

How to problem solve

Answer 24

Define the problem, examine and remove unnecessary constraints

Question 25

Asset codes begin with

Answer 25

1

Question 26

Liabilities begin with

Answer 26

2

Question 27

How do you compare the current month to the same month last year in a KPI?

Answer 27

Be sure to check show previous on the current needle, then Use the Parallel Member Icon

Question 28

How do you create a 3 month period on a KPI?

Answer 28

Use periods between. To member is context period (not from functions) and from member is prior period of prior period, wrapped.

Question 29

what are the two ways to add a target?

Answer 29

drag on a measure, or let zap calculate it for you. You would use the “percent of previous” option or create a calculation.

Question 30

Do Kpis have slicers?

Answer 30

Only when they are placed on a dashboard do they inherit slicers

Question 31

Can you slice a KPI by a date range?

Answer 31

No, they are limited to one month

Question 32

How do you edit a KPI in a dashboard?

Answer 32

Paper clip icon in the top right of the frame

Question 33

What are the 4 types of alerts in ZapBi?

Answer 33

Scheduled Alerts, Conditional Alerts, Resource Changed Alerts, Cube Changed Alerts

Question 34

Polling Job

Answer 34

Checks for changes in values

Question 35

What is it called when ZapBi checks for changes in underlying conditions?

Answer 35

Polling Job

Question 36

How do you create drillthrough on a scorecard

Answer 36

drag the kpi to the chain icon. You may drop it on the “master” if you have a slicer added, and it will automatically pass the slice information into the KPI on drill through

Question 37

When adding tables, which tables should you be sure to let profile?

Answer 37

Dimensions. This is because the relationships are detected during this profiling. This step is critical.

Question 38

When searching tables in staging you must use what?

Answer 38

wildcard characters

Question 39

In what tables can we create a primary key?

Answer 39

Fact tables only

Question 40

Compute During Migration

Answer 40

Populates when the cube runs (insert)

Question 41

Compute in Staging

Answer 41

creates a new column in (only do this if the parts are already populated) (select)