What are pass through function in MSTR?

Pass-through expressions, also called Apply functions, allow use of special functions or syntactic constructs beyond what MicroStrategy can create on its own, but can be obtained through the relational database. They act as containers for non-standard SQL expressions that MicroStrategy does not support.

What are case functions are used for?

Case functions return specified data in a SQL query based on the evaluation of user-defined conditions. In general, a user specifies a list of conditions and corresponding return values.

How do you write a multiple CASE statement in SQL?

Here are 3 different ways to apply a case statement using SQL:

  1. (1) For a single condition: CASE WHEN condition_1 THEN result_1 ELSE result_2 END AS new_field_name.
  2. (2) For multiple conditions using AND: CASE WHEN condition_1 AND condition_2 THEN result_1 ELSE result_2 END AS new_field_name.

What is derived attribute in MicroStrategy?

A derived attribute works the same as any other attribute. You can add it to a visualization, drag it into a text field to display it as a label, or use it as a filter. You can easily create a derived attribute that: Changes the data type of an existing attribute.

How do you create a conditional metric in MicroStrategy?

To Create a Conditional Metric

  1. In MicroStrategy Developer, choose File > New > Metric.
  2. Create the metric formula by adding facts, attributes, metrics, operators, and/or functions.
  3. Click Condition on the Metric component pane.
  4. Select the filter or prompt to place on the metric using one of the following methods:

IS null is not null?

The IS NULL condition is satisfied if the column contains a null value or if the expression cannot be evaluated because it contains one or more null values. If you use the IS NOT NULL operator, the condition is satisfied when the operand is column value that is not null, or an expression that does not evaluate to null.