Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
45 Cards in this Set
- Front
- Back
|
What is the default relationship between all attributes and the dimenion key?
|
Many:1
|
|
|
What are the 5 Properites in Attribute Relationships?
|
Attribute (name of the related attribute)
Cardinality (one or many) Name (relationship name the ned user will see) RelationshipType(Rigid if unchanging, Flexible if it can change) Vaisible |
|
|
How does the Cube Designer determine which measure groups a dimension is realted to?
|
By using the table relationship metadata within the data source view (DSV) on which the cube is based.
|
|
|
What are the 5 types of relationships between dimensions and measure groups?
|
Regular
Fact Referenced Many-to-Many Data Mining |
|
|
What is the dimension usage relationship type Regular used for?
|
Defines the relatiohsip when a dimension is joined directly to a measure group through a specific attribute called the "granularity" attribute
|
|
|
What is the dimension usage relationship type Fact used for?
|
Used when the dimension is based on the fact table used to define the measure group (e.g. end users need to see order line items for a given sales order but you don't want to give line items designated dimensions)
|
|
|
What is the dimension usage relationship type Referenced used for?
|
Used when a given dimension is related to a measure group throuh an intermediate dimension
|
|
|
What is the dimension usage relationship type Many-to-many used for?
|
Specifies that a dimension is realted to a given measure group through and intermediate measure group
|
|
|
What is the dimension usage relationship type Data mining used for?
|
Defines the relationship betwen a dimension based on a data mining model and a given measure group
|
|
|
Why would you spend time defining appropriate attribute relationships?
|
To improve query performance and optimize storage because the server might be able to produce the totals from the related attribute totals instead of scanning the fact table.
|
|
|
What are the four main expression-based properties of KPIs?
|
Value
Goal Status Tend |
|
|
What does the Goal property in KPI refer to?
|
What the KPI value should be in the perfrect world, either a fixed number, a regular meaure, or a calculated measure
|
|
|
What does the Status property in KPI refer to?
|
How the KPI value compares to the goal. Its expression should return an integer value of -1 for underperformance, 0 for acceptable performance, or 1 for good performance
|
|
|
What are the six additional KPI properties?
|
Associate Masure Group
display folder parent KPI current time member weight status indicator and trend indicator |
|
|
What can actions do and what programs support them?
|
Actions can extend your cubes in several versatile ways, e.g. allowing a user to request an SSRS report that displays information from another system. Actions are supported by Excel 2007 but not SSRS
|
|
|
What are the three main action types?
|
Regular, Drillthrough, and Reporting
|
|
|
What is the dataset regular action type's purpose?
|
The action content is an MDX statement
|
|
|
What is the Proprietary action type's purpose?
|
The action content is client-specific. The client is responsible for interperting the semantic meaning of the action
|
|
|
What is the rowset action type's purpose?
|
The action content is a command statement to retrieve data. Unlike the dataset aciton, a rowset action targets any OLE DB-compliant data source including a relational database
|
|
|
What is the Statement action type's purpose?
|
The action content represents an OLE DB command. Ulike the dataset and rowset actions, the statement should not yield any results other than success or failure
|
|
|
What is the URL (default) action type's purpose?
|
The action content is a URL and should indicate one of the standard protocols, such as HTTP, HTTPS, FTP, FILE or Mail
|
|
|
What do drillthrough actions do?
|
Let the client request the details behind aggregated cell value in the cube. This is the only action type that the client can send to SSAS for execution
|
|
|
What do reporting actions do?
|
Can be used to request SSRS reports
|
|
|
What does the action target consist of?
|
Target type and object, e.g. Attribute members as target type and a particular attribut hierarchy as the target object
|
|
|
What is a cube perspective and why is it used?
|
A cube perspective represents a subset of the cube. Its main purpose is to reduce the percieved complexity of a large cube by exposing only a subset of cube objects
|
|
|
Do cube perspectives implement securtiy?
|
No, security settings overide cube perspective settings
|
|
|
How can you localize dimension members' cations?
|
By selecting a translation column that store the translated captions
|
|
|
What are the two main ways you can use MDX in SSAS?
|
To query and to extend multidimensional cubes
|
|
|
What is a tuple?
|
A tuple is a multidimensional coordinate that identifies a single cell in the cube space
|
|
|
What are two ways of referencing a dimensino member in a tuple?
|
A member name (default), which won't work if you have multiple products with the same name
A member key, which will always be resolved uniquely but needs to be prefixed with a & (e.g. [product].[product].&[10] |
|
|
What is an MDX set?
|
An MDX set is a colleciton of tuples with the same dimensionality, or attribute hierarchies
|
|
|
How many axes can a query have?
|
128, numbered from 0 to 127
|
|
|
What does the CurrentMember function do?
|
It takes a hierarchy and returns the current member in respect to a given cell coordinate. It is the default property of a dimension member and is often omitted.
|
|
|
What MDX function is frequently used to define the KPI Trend or Goal properties?
|
PrevMember
|
|
|
What MDX functions are used for navigating hierarchies?
|
PrevMember
Children Parent Members |
|
|
What MDX functions are used for navigating the time dimension?
|
Lag
ParallelPeriod PeriodsToDate |
|
|
Do calcultated members increase the cube size?
|
No, because a server only stores its defnition, not its data
|
|
|
Which MDX statement do you use to define a calculated member?
|
Create Member MDX
|
|
|
When are the two reasons to think about using a calculated member?
|
When you need a measure that spans measure groups
When you need a nonaddtivie measure that operates uniformly across dimension levels |
|
|
What do scope assignments do?
|
Scope assignments let developers write to the cube space and overwrite the measure aggregation behavior.
|
|
|
What is a named set?
|
A named set is an MDX construct that has an alias and that returns a set of dimension members.
|
|
|
What are the two types of named sets upported by SSAS and which one is the default?
|
Static named set and dynamic named set
BIDS sets dynamic named sets by default |
|
|
What are the first two axes of an MDX query?
|
Columns and Rows
|
|
|
What is the difference between a caculated member and a regular measure in terms of storage?
|
Regular measures are stored on the disk, and the values of a calculated member are calculated at run time
|
|
|
What is a named set?
|
A named set is a set consisting of dimension members.
|
