MicroStrategy ONE
Join Editor
After performing the step of adding table to create your Query Builder report, you must create joins between the tables. Once you create a join within Query Builder, you can access the Join Editor by double-clicking the line representing the join between two columns.
In the Join Editor, you can select from the following join types:
-
Inner join: Performs an inner join on the columns.
-
Left outer join: Performs a left outer join on the columns.
-
Right outer join: Performs a right outer join on the columns.
-
Full outer join: Performs a full outer join on the columns.
You can right-click the line representing the join and select one of the four join types described above to modify the join type.
You can modify the join expression in one of two ways:
-
Simple expression: This is the default join expression pane that appears in the Join Editor. In the lower join expression pane you can view the column names that are included in the join expression. You can also modify the join operator by selecting a join operator from the Operator drop-down list. You can choose from the following join operators:
-
Equal (=): Joins two rows if the two column values are equal to each other.
-
Greater than (>): Joins two rows if the first column value is greater than the second column value.
-
Less than (<): Joins two rows if the first column value is less than the second column value.
-
Greater equal (>=): Joins two rows if the first column value is greater than or equal to the second column value.
-
Less equal (<=): Joins two rows if the first column value is less than or equal to the second column value.
-
-
Advanced expression: Click the Advanced Expression button on the Join Editor to modify the advanced join expression. This allows you to modify the join expression in the following ways:
-
Column expression: You can modify the columns that are selected for the join as well as perform arithmetic or functional operations on the column expressions. These modifications can be done manually by typing the correct syntax or by using the options on the join expression toolbar. For more information on the possible column expression modifications, see Defining a column expression in Query Builder.
-
Join operator: You can modify the join operator by manually typing in a different operator. For example, to join values from the first column with values from the second column when the first column values are greater than the second column values, change the operator from = to >.
-