Expression dialog box

When you are importing data from a database by building a SQL query or from Google BigQuery, you can define an expression based on a column to select the data that you want to import. To define an expression, type the expression into the Expression pane in the middle of the Expression dialog box.

The following options are available:

Insert Insert icon: Click this icon to select a MicroStrategy function to insert into the expression. You can select a function or choose Search Function to search for or browse to your function using the Select a Function dialog box.
Syntax validation Syntax Validation icon: Click this icon to check your expression for valid syntax. If the expression is valid, a message appears in the bottom of the Expression pane to inform you that your syntax is valid. If the expression is not valid, the message explains the syntax problem.
Clear Clear icon: Click this icon to clear the contents of the Expression pane.

Prerequisites

This procedure assumes that you are importing data from a database by building a SQL query and have added at least one database table to the editor pane. For steps to import data from a database, see Importing data from a database by building a SQL query.
You are importing data from one of the following:
A database by building a SQL query. For steps, see Importing data from a database by building a SQL query.
Google BigQuery. For steps, see Importing data from Google BigQuery.
You must have added at least one database table to the Editor panel.

To select data to import based on an expression

1 On the Editor panel in the Import from Tables page, hover the cursor over the data column to use to create the expression, then click the arrow icon that appears. A menu is displayed. Point to All Functions, point to the type of function to use (such as Logical or String), and then select the function to use. The Function Arguments dialog box opens.
2 Select the appropriate options to provide arguments for the function. Click OK. The Expression dialog box opens, with the function displayed.
3 In the Expression pane, modify the expression as needed. You can type additional syntax, or insert an additional function into the expression by doing the following:
a Click the Insert icon Insert icon. A pop-up menu is displayed.
b To select a function, choose the name of the function from the list. The Function Arguments dialog box opens.
c Select the appropriate options to provide arguments for the function and click OK. Your function is displayed in the Expression pane.
4 Repeat the steps above as appropriate to define your expression.
5 To check your condition for valid syntax, click the Syntax validation icon Syntax Validation icon. If the condition is valid, a message is displayed in the bottom of the Expression pane to inform you that your syntax is valid. If the condition is not valid, the message explains the syntax problem.
6 To clear the contents of the Expression pane, click Clear Clear icon.
7 When you are finished editing your expression, click Save to apply your changes and create the expression.

Related topics

Select a Function dialog box
Importing data from a database by building a SQL query
Importing data from Google BigQuery