Day 2

Card Set Information

Author:
mcharliem
ID:
29563
Filename:
Day 2
Updated:
2010-08-10 17:49:35
Tags:
Day
Folders:

Description:
Day 2
Show Answers:

Home > Flashcards > Print Preview

The flashcards below were created by user mcharliem on FreezingBlue Flashcards. What would you like to do?


  1. What are the 2 types of Filters?
    • Report Filters - Affects SQL, can contain any objects
    • View Filters - Used after the SQL, contains only objects in Report Objects, requires OLAP
  2. 4 Types of Report Filters?
    • Attribute Qualification - allows users to select filter
    • Set Qualification - based on metrics
    • Shortcut to a Report
    • Shortcut to a Filter
    • (also an advanced qualification option)
  3. 3 Types of Set Qualifications for Report Filters?
    • Metric Value
    • Rank
    • Percent
  4. 4 Types of Set Operators in Filters
    AND, OR, OR NOT, AND NOT
  5. 4 Types of Metrics?
    • Simple - includes 1+ aggregate function, 1+ metric/attribute, 1 level, maybe conditions or transformations
    • Nested - functions within functions, include one or more level definition
    • Compund - based on existing Metric
    • Derived - run after the fact and part of OLAP
  6. 5 Types of OLAP analysis?
    • Cube Analysis
    • Derived Elements
    • Report Objects
    • View Filters
    • Derived Metrics
  7. What are aspects of Derived Metrics?
    • May include one or more functions and operators
    • based on attributes and metrics in the Report Objects
    • may be simple or compound
  8. 3 Types of Built in Metrics?
    • Percent to Total
    • Transformations
    • Rank
  9. 3 Advantages to Prompts?
    • Almost Unlimted flexibility
    • Few Reports are needed
    • Allows quick and easy data comparisons
  10. 4 Types of Prompts?
    • Filter Definition Prompt - allows user to select filter
    • Object Prompt - allows user to select Metrics, Attributes, even templates, or filters.
    • Value Prompt - requires user to select fill-in-the-blank value
    • Level Prompt - allows user to select data aggregation level
  11. 4 Options for a Filter Definition Prompt?
    • Choose from all attributes in a hierarchy (or all everywhere)
    • Qualify on an attribute - specifies the attribute
    • Choose from attribute element list - specifies attribute and list of answers
    • Qualify on a Metric (Value, Rank, Percentage)
  12. 4 Types of Value Prompts?
    • Date
    • Numeric
    • Text
    • Big Decimal
  13. What are the 5 Search Criteria?
    • Object Name and Location
    • Date Range of Object Creation
    • Object Type
    • Object Owner
    • Object ID

What would you like to do?

Home > Flashcards > Print Preview