General Flashcards
Does the staging database have security?
No
What is the language the cube is stored in?
XMLA
How do you strip security out of the cube?
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
WIP
Work in Process
Current Assets
Total Cash (and Equivalents) Securities, Other Current Assets, Production inventory including WIP, and Intangible Assets
Current Assets Accounting Definition
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.
Total Assets (formula)
Current Assets + Non Current Assets
When is Lite Mode automatically selected?
The dimension has more than 1 million rowsOnly the corresponding measure group has relations to the dimension. (only one measure group relates)
When Lite Mode is enabled
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
ApplyUserCustomizationsBeforeTableStructureChanges SP
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.
ApplyUserCustomizationsAfterMainDataMigration
Runs 2nd, most of the time not used
ApplyUserCustomizationsAfterMigrationComplete
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
Include in data only update caveat
data only update won’t make sense to apply to a dimension table, because this would trigger a full structure update.
Benefits of breaking records into batches during load
Avoiding latency due to network instability, or because of memory limitations
Caveat about hierarchies
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
what color are member properties in cube config?
gray
Parent child hierarchy
there are two columns, one with a parent and one with a child, can represent multiple layers of a hierarchy
process cube offline does what?
Takes the cube offline and processes. This frees up memory, typical of a full load.
Why do you run a full load once a week
Incremental handles changes, not deletes. The record is gone from the source, but staging hasn’t been updated with this change.
two important things for a Zap Consultant
Functions and Dates
Contains Member Function
Under logical. If contains member (laptop in product)
Single dot in dimension tree
level
ways to hide custom formula
on filter, or rename to space
How to problem solve
Define the problem, examine and remove unnecessary constraints
Asset codes begin with
1
Liabilities begin with
2
How do you compare the current month to the same month last year in a KPI?
Be sure to check show previous on the current needle, then Use the Parallel Member Icon
How do you create a 3 month period on a KPI?
Use periods between. To member is context period (not from functions) and from member is prior period of prior period, wrapped.
what are the two ways to add a target?
drag on a measure, or let zap calculate it for you. You would use the “percent of previous” option or create a calculation.
Do Kpis have slicers?
Only when they are placed on a dashboard do they inherit slicers
Can you slice a KPI by a date range?
No, they are limited to one month
How do you edit a KPI in a dashboard?
Paper clip icon in the top right of the frame
What are the 4 types of alerts in ZapBi?
Scheduled Alerts, Conditional Alerts, Resource Changed Alerts, Cube Changed Alerts
Polling Job
Checks for changes in values
What is it called when ZapBi checks for changes in underlying conditions?
Polling Job
How do you create drillthrough on a scorecard
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
When adding tables, which tables should you be sure to let profile?
Dimensions. This is because the relationships are detected during this profiling. This step is critical.
When searching tables in staging you must use what?
wildcard characters
In what tables can we create a primary key?
Fact tables only
Compute During Migration
Populates when the cube runs (insert)
Compute in Staging
creates a new column in (only do this if the parts are already populated) (select)
