To configure or remove the existing version of the product, use the Add/Remove Program feature in. There's a reason we're at the top of the list. To Define a Join Between the Columns of Two Tables. 3 environment, we have a star schema that has multiple date dimensions. DealSizeUnit should be a metric that an attribute. INNER JOIN. This lack of support stems from how the SQL language handles nulls and cannot be changed. itemNo is not null AND Store. The year_date attribute from table 2 is added to the grid. Controls whether tables are joined only on the common keys or on all common columns for each table. An outer join includes data that applies to all components. id. 1. On the Freeform Sources tab, select one of the following options: To create an Intelligent Cube by creating SQL statements using the Freeform SQL Editor. CAUSE: In the example above, the final pass compares End_id of Temptable1 and End_id of Temptable2. For example, tutorial datasets may contain unrelated attributes and cross join metric values rather than joining the metric values. For information on how to display this property, see Viewing and Changing Advanced VLDB Properties. A join clause in the Structured Query Language combines columns from one or more tables into a new table. However, if you go to DB instance > VLDB Setting > Joins > Full Outer Join Support, you will find that by default “No Support” is selected. When talking about Theta joins the following operators are used < , ≤ , > , ≥ , ≠. SAP HANA 1. Join common key on both sides. This article also provides a workaround to avoid this behavior. 1, it is possible to identify specific attributes as having an incomplete lookup table by setting the “Preserve all final pass result elements” VLDB property within the attribute. This is a known defect in MicroStrategy 10. This attribute join type uses the second approach. from master_dimension m left outer join sub_dimension sub on m. Cross joins are seen in metrics when joining across unrelated attributes inside of data blending. Companies of all sizes use this platform to assess, visualise, and build dashboards. This video demonstrates how to create custom SQL filters in MicroStrategy. The options for this property are. For example: Metric, by default is Inner Join. All report metrics use outer join: No flags are generated. SELECT. Here is a sample SQL: SQL BEFORE 11. In the right corner of the dashboard, change the data source. To include the left outer join clause, follow the steps below: The following schema shows which setting takes precedence when set at different levels. Full Outer Join . . KB221464: The report SQL does not generate outer join due to one metric been mistaken as a nested aggregation metric in MicroStrategy Analytics Developer 10. In MicroStrategy Analytics Enterprise 10. Set the Attribute Join Behavior to "Outer Join - Preserve Filter" 4. 4. ( How?) Expand Database instances. FULL [OUTER] JOIN. Clear the Use default inherited value check box. NOTE: The aforementioned document and the example in this document use the logical view feature introduced in MicroStrategy 8. Name it "Outbound Force Join". Result: Acts mostly as one dataset, but missing values are. x-10. How to use an outer join to retrieve data when a metric on the report has a condition that is mutually exclusive with the report filter in MicroStrategy 10. ttl_weight from rep_so a, rep_so_p1 b where a. In MicroStrategy SDK 9. name,b. Specifically if a metric at a higher level is set to outer join while a lower level metric is set to inner join while both include an attribute the lower level metrics version of the attribute will be used to join to lookup tables despite being less complete. So, if there are rows in "Customers" that do not have matches in "Orders", or if there are rows in "Orders" that do not have matches in "Customers", those rows. How to use Guacamole to copy and paste text or files in MicroStrategy on AWS; All new Download site is now available!Community & Support Search Discussions Open A Case View My CasesFull Outer Join not returning unmatched join field values SQL SERVER 2005. Do the same with Response. When you specify a table to join with a fact, you are creating a table relation to extend a fact. There's a reason we're at the top of the list. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. x A report defined as shown below returns no data in Microstrategy 10. This article is to introduce a workaround to achieve the attribute left outer join on MicroStrategy Web. Full Outer Join : The full outer Join keyword returns all records when there is a match in left or right table records. 0. FULL [OUTER] JOIN without the intersection. 12, with Data Engine Version 2019 or above, there are duplicated rows of data returned in some scenarios for a dossier/report/document which is created based on an intelligence cube and has the join behavior for attributes set to be Outer Join-Preserve Filter. The join is important as the table contains an attribute in the entry level and the attribute to which to extend. Steps are as below. 8. Support, which assumes that the Join Type VLDB setting is Join 92; any other value in Join Type is ignored. The MicroStrategy SQL Generation Engine uses the COALESCE function to ensure correctness and consistency in full outer join results. Controls whether tables are joined only on the common keys or on all common columns for each table. OrderID. Full Outer Join Support = Outer-Join . A table relation defines a join on tables. Metric Join Type: VLDB. There's a reason we're at the top of the list. x. The SQL Engine makes three SQL passes:The following Syntax is for the left outer join. Select Support. 0: The SQL for a Report shows that two identical tables do a full outer join twice. Too bad!There's a reason we're at the top of the list. c2 FULL OUTER JOIN t3 ON COALESCE(t2. The following a sample code on how to modify. KB31133: Join conditions are omitted in the calculation of nested aggregation metrics in MicroStrategy SQL Generation Engine. You can right-click the line representing the join and select one of the four join types described above to modify the join type. Select the join type to use from the following options: A default join uses the joins already defined in each element of the compound metric. Make sure that the report filter override option is turned off. CustomerName, Orders. Change the Metric join type of the Revenue metric to Outer join in the Report Data Options, as shown below: The report should appear as shown below. This preference is located under the Tools menu > My Preferences > Editors tab > Filter Options, in which the first option, "Show advanced qualification," should be checked. All rows of the intermediate table are preserved. 0 SP2 supports FULL OUTER JOIN syntax between tables in the FROM clause. PRIME stands for Parallel Relational In-Memory Engine, and it engulfs two types of in-memory cubes: OLAP cubes, or the traditional Intelligent Cubes that have existed since 9. You can define join behavior through Report Data Option in each individual report in design view. The following commands have been added for Intelligent Cube management: Get the status of a Multi-Table Data Import (MTDI) cube refresh ; Get the status of table refresh within a MTDI cube NOTE:SQL OUTER JOIN overview and examples. 0, a VLDB property is available to control. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. You can configure properties such as SQL join types, SQL inserts, table creation, Cartesian join evaluation, check for null values, and so on. Create three reports named A (with attribute A), A&B (with attribute A and B),A&C (with attribute A and C) Create a dashboard based on. FROM Table-1 LEFT OUTER JOIN Table-2ON (col1 = col2) <WHERE condition>; You can replace LEFT OUTER JOIN by RIGHT OUTER JOIN or FULL OUTER JOIN for the respective output. This can cause outer joins. Create another logical table (or view) for your prices: Full Outer Join Support: Support: Select/Insert: Bulk Insert String ; Select/Insert: UNION Multiple INSERT: Use UNION: Select/Insert: Distinct / Group By option: Use DISTINCT: Query Optimizations: Sub Query Type: Use temporary table; falling back to IN (SELECT col) for correlated subquery: Query Optimizations: SQL Global Optimization Click the Joins folder to expand it and then choose Full Outer Join Support. The location of the (+) indicates which table you're outer joining. x when joining two datasets together on a document or dashboard data blending is used. SUBCAT_ID SUBCAT_ID, Certain databases do not allow a full outer join to be written into a SQL statement's FROM clause using SQL-92 syntax. Additional Final Pass Option is an advanced property that is hidden by default. The SQL standard defines three types of OUTER JOINs: LEFT, RIGHT, and FULL but SQLite supports only the natural LEFT OUTER JOIN. zip file, with the. Additionally, the COALESCE function can be included in the SQL query. This video also has a a brief discussion about how to create advanced filters as joint. Join 92 is the later standard wherein the joins are performed in the FROM clause. In terms of join behavior this means the setting applies to metric joins between datasets. Create a new dataset. This article is to introduce a workaround to achieve the attribute left outer join on MicroStrategy Web. The first pass calculates Sales; the second pass calculates Item Sold. CUSTOMER. The options on the top become active. If you created two facts with the condition inside than you don't need the conditional metrics and the outer join –This article describes how SQL Global Optimization handles inner versus outer joins between metrics in MicroStrategy. Join common attributes (reduced) on both sides. To pick up the fix, upgrade to MicroStrategy 2021 or above and enable project level setting "Data Engine Version" to 2021 or above. Share. That will help people help you. many-to-many and jointing child relationships; Logical Charts Size the lightweight way to understandI want implement an outer join in Microstrategy 7. MicroStrategy provides ETL, data warehousing and data mining for data analysis. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. The sql statement for this metric is shown below. 99K subscribers Subscribe 4. Example-- full join Customers and Orders tables -- based on their shared customer_id columns -- Customers is the left table -- Orders is the right table SELECT. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. An inner join is a standard type of join. Full outer join support is enabled in the Amazon Redshift object by default. LEFT (OUTER) JOIN: Returns all records from the left table, and the matched records from the right table. 2 (Database is Oracle 8. N FROM table_A FULL OUTER JOIN table_B ON table_A. x. (See Example 1: Same attributes, same filter) Example 2: Same attributes with different element values. Extra SQL passes are generated when the metric join type is set to Outer Join and SQL Global Optimization is set to Level 4 in a report, we will remove the extra SQL passes to improve performance. This issue has been addressed starting in MicroStrategy 9. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. Similar to scenario 1, three passes are generated. I'm assuming that a16. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. In this situation the presence of Year_date on the grid limits the data to just rows that exist in table 2 which is why the year 2016 is not seen. The following sample query demonstrates how MicroStrategy supports outer join against PostgreSQL. id = p. But sub-queries have performance issues. Having the following hierarchy: Country > Distribution Center > Calling Center > Full Outer Join Support is an advanced property that is hidden by default. To Create an Intelligent Cube Using Freeform SQL or Query Builder. ttl_qty, b. 0 SP2 supports FULL OUTER JOIN syntax between tables in the FROM clause. MySQL does not have FULL-OUTER-JOIN syntax. When MicroStrategy SQL Generation Engine tries to identify the common key to join the tables in the final pass, the mismatch between the keys causes the Engine to join on only one attribute (Customer City). 52K KB440718: Aggregate from base derived metric with an attribute to ignore filter does not get ignored in. Now my objective is to generate an SQL which will look like the following: select. Perform the data aggregation first, then perform a left outer join to bring in all attribute elements. Solution: SELECT first_name, last_name, COUNT (v. (UNION ALL keeps duplicates) 2. Select Right Outer Join to include all records from the column in the second table and only those records from the column in the first table in which the join condition is satisfied. We will learn all JOINS in SQL server with examples: INNER JOIN/simple join. When no matching rows exist for a row in the left table, the columns of the right table will have NULLs for those records. Here are the different types of the JOINs in SQL: (INNER) JOIN: Returns records that have matching values in both tables. If you are finished adding to Cube A, click Update Dataset. Rerun the report and it should bring back all the data you need. For more details on enabling the setting, refer to Change Data Engine Version After the fix, metric outer join works and data returns. The customers with cust_id “3” have no orders, and the orders with order_id “103” has an id order and no matching customer, so their respective columns contain NULL values in the result. the outer parts of a Venn diagram union. Starting MicroStrategy 11. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. A,table_a. Advanced Settings. Different types of Joins are as follows: INNER JOIN. For information on how to display this property, see Viewing and Changing Advanced VLDB Properties. Instead of listing all columns in the SELECT clause, we just used the asterisk (*) to save some typing. Installation of this version cannot be completed. Downward Outer Join Option. This article is to introduce a workaround to achieve the attribute left outer join on MicroStrategy Web. Create three reports named A (with attribute A), A&B (with attribute A and B),A&C (with attribute A and C) Create a dashboard based on the three reports created in last step. [Category],[Year]} / [Revenue])) as [DM2] from DBRM2 to Ex7_tempcube1 select * from Full Outer Join( Ex7_tempcube0, Ex7_tempcube1 ) on Year, Category to Ex7_tempcube2 Drop Ex7_tempcube0 Drop Ex7_tempcube1. This method exists as attribute only outer joins will not be generated on their own by the MicroStrategy SQL engine. This issue has been addressed in MicroStrategy 2021. Levels at Which You Can Set This . Create a metric out of the 3 columns you mentioned and outer join them. Brief instructions are provided using the example below. Enable optimization to remove repeated tables in full outer join and left outer join passes. It's true that some databases recognize the OUTER keyword. Inner Join : When the inner join is used, it considers only those attributes that we want to match both the table and, if anything that doesn’t, wouldn’t be included in our result table. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformSo the existence of GODWFLAG is expected as metric A and B are not independent from each other though they are all outer join metrics. SQL FULL OUTER JOIN examples. INSERT, UPDATE, and DELETE on Views. Those intermediate passes will then be merged in a last pass (if metric join type is set to outer then the last pass is a full outer join). For attributes, the default join type is Outer Join. This filter must be applied in the final pass to find the correct store-region relationship, even though the final pass is a normal join instead of a downward join. The following descriptions use an example of a report containing the Region attribute, the Sales metric, and the Budget. . You have to emulate it by doing both LEFT JOIN and RIGHT JOIN as follows: SELECT * FROM t1 LEFT JOIN t2 ON t1. x. A FULL OUTER JOIN returns unmatched rows from both tables as well as the overlap between them. Full Outer Join Support is an advanced property that is. id = t2. The subsets you separate your business data into are called pages, and you then page your way through the report, viewing one data subset at a time. 1/10. In the right corner of the dashboard,. This issue has been addressed in MicroStrategy 2021. The setting can be found under the Advanced tab. Glossary. Click on 'OK' and save the Attribute. There are 2 rows in the Forecast table that have the same combination of Model, Month, Country, rows with ID 2 and 3: Why MicroStrategy Why MicroStrategy; Customer Stories; Platform As a result, the metrics' join types fall back to the project default, which is inner join for MicroStrategy Tutorial. LEFT [OUTER] JOIN without the intersection. It is dynamically created when a new report is created in MicroStrategy MicroStrategy Developer 9. This article documents the process to create a SQL query with left outer join between metric passes and lookup tables in MicroStrategy 9. Open the VLDB Properties Editor to display the VLDB properties for the level at which you want to work. It selects records that have matching values in these columns and the remaining rows from both of the tables. Go back to Public Objects-->Reports. This will help authors of dossiers embed workflows that provide consumers with options for guided analyses. In MicroStrategy Workstation, right click on any cube created via Data Import and select Properties. The strength of NSS lies in its outstanding model. For metrics, the default join type is Inner join. 58K. Visit the data visualization and data dashboard galleries for inspiration. You can right-click the line representing the join and select one of the four join types described above to modify the join type. An outer join includes all data from every element (the union of all. There's a reason we're at the top of the list. Another way is to use the Lowest level attribute in the report object pane. A UNION clause can be used as an alternate to get the same result as FULL OUTER JOIN. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformAs a result, the metrics' join types fall back to the project default, which is inner join for MicroStrategy Tutorial. The Full Outer Join Support property specifies whether the database platform supports full outer join syntax: 9. 0, this Feature Flag is removed and replaced with project level setting called "Data Engine Version". In the Tutorial project, the user needs to create a report, for. ShelfNo WHERE Department. Here is the list of 7 types of JOINs that you are going the use quite a lot in SQL. Inner joins versus outer joins. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. For these databases, MicroStrategy implements a technique of analyzing each metric's result pass to obtain all the distinct attribute elements that are required to preserve the rows. Watch the video below to see some creative use cases and learn how to build! 5 new visualizations unlock meaningful ways to explore your data including Modern Grid, Sankey, Time Series, Multi-Metric KPI,. The MicroStrategy SQL Engine applies the designated join type to the data pulled from your data source's tables. Levels at which you can set. In this article, we will discuss FULL OUTER JOIN using LEFT OUTER Join, RIGHT OUTER JOIN, and UNION clause. By selecting this option, the Join Type VLDB property is assumed to be Join 92 and any other setting in Join Type is ignored. Great idea, but does not work! From a no apparent reason, no metric dimensioned in MicroStrategy can be “conducting”, ie standing in a LEFT OUTER JOIN on the left side. To group data into subsets, you can use the page-by feature. id) AS vinyl_count FROM customer c FULL JOIN purchase p ON c. Create three reports named A (with attribute A), A&B (with attribute A and B),A&C (with attribute A and C) Create a dashboard based on the three reports created in last step. The MicroStrategy product has been built from the ground up to focus on metrics and analysis of aggregated and calculated values. Join Type for "All Attributes" is set to "Outer Join - Preserve Filter" for the Visualization. With MicroStrategy Web, business users perform any of or all the major styles of BI - Scorecards and Dashboards, Enterprise Reporting, OLAP Analysis, Predictive Analysis, and Alerts and Proactive Notification - within a single, unified Web interface. A simple idea would be to modify the metric by means of dimensionality, namely, the LEFT OUTER JOIN attributes with the setting ignore add / None. The full outer join or full join returns all rows from both tables, matching up the rows wherever a match can be made and placing NULL s in the places where no matching row exists. Note that if there are other metrics on the report whose report level metric join type is set to 'inner join,' the report SQL will reflect inner joins and left outer joins depending on the reporting scenario. SQL Full Outer Join W/ Coalesce. The options for this property are No support Support, which assumes that. Controls whether tables are joined only on the common keys or on all common columns for each table. Therefore, SQL is generated for the filtering report using an inner join between the two metrics, and since the metrics have no attribute elements in common, all data are excluded. In short, an inner join includes only data that is common to all components of the join. The key thing is, MS uses the exact opposite concept from the database outer join - I am not sure why, but say metric A you need for sure, metric B is optional, you need to set metric A as OUTER JOIN metric,. ShelfNo = Department. Step 2) Loading and Displaying Data. Let us take two tables to demonstrate full outer join: table_A. This should happen only if you use the first approach. A Venn diagram representing the full join SQL statement between tables A and B. Login MicroStrategy. The join type determines what type of join (inner or outer) is used by the SQL Generation Engine for each one of the metrics in a given report. The following window appears: Highlight the table 'LU_REGION' under 'Source tables' and click on the 'Set as Lookup' button. If the parent report is configured, under Report Data Options > Attribute Join Type, to preserve all lookup table elements joined to the final result table, then the target report will also preserve lookup table elements. KB483322: Two identical tables for a full outer join twice when metric join type is set to Outer Join and SQL Global OptimOuter join: Left Outer Join; Right Outer Join; Full Outer Join; Inner Join. SYMPTOM. If the cross join is not needed and the fact extension is required to take effect, change the grouping by "None" to "Standard" or remove the related attribute or user hierarchy from the level metric. x. To do so just go to Menu Data -> Report Data Options and change the Metric Join type for the report where you. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. solutions Forum; Outer Join on attributes. The table now appears in bold as shown below. In MicroStrategy, there are two settings that users can access to control Outer Join behavior: Formula Join Type and Metric Join Type. As shown in the example above, all data for cost is aggregated together and shown for every row of a category. User can define the inner/outer join behavior through Report Data Option in each individual report. Note that if you want to have consecutive ranks, you can use the DENSE_RANK() function. •. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform So the existence of GODWFLAG is expected as metric A and B are not independent from each other though they are all outer join metrics. Chapters. Go to Web and open New Dossier template-->File-->Dossier Properties -> Join Behavior-->Uncheck the setting-->Save and close the template. The concept is simple. This technique is also great for developing Freefrom SQL queries in MicroStrategy. from master_dimension m left outer join sub_dimension sub on m. The . ttl_qty, b. By default MicroStrategy uses inner join for your metrics. For example, in the MicroStrategy Tutorial project, the user creates the following objects: Metric : Sum (Revenue). The purpose is to show how a filter can be manipulated to give the developer full access over the where clause generated by MicroStrategy's SQL engine. There are mainly 4 different types of JOINS in SQL server. RIGHT [OUTER] JOIN without the intersection. KB441377: Full Outer Join Optimization implemented in MicroStrategy 11. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. 4. Given a choice, it is recommended to use a JOIN over a sub query. CustomerID. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. id = t2. The Link Attributes Dialog opens. For these databases, MicroStrategy implements a technique of analyzing each metric's result pass to obtain all the distinct attribute elements that are required to preserve the rows. 29K. Great idea, but does not work! From a no apparent reason, no metric dimensioned in MicroStrategy can be “conducting”, ie standing in a LEFT OUTER JOIN on the left side. It tells Oracle you want to see all records in. In Microstrategy Tutorial Database, let us take three tables ORDER_FACT,LU_ORDER and LU_CUSTOMER. 9. Note that if there are other metrics on the report whose report level metric join type is set to 'inner join,' the report SQL will reflect inner joins and left outer joins depending on the reporting scenario. Notice the outer join is applied, and that in the last pass of the CSI, there is a cross join between L_Category & L_Year and then "left outer join" to the Metric result. A FULL JOIN returns unmatched rows from both tables as well as the overlap between them. VLDB Properties. The properties are saved in different folders, as indicated in the previous list. There's a reason we're at the top of the list. Right outer join: Performs a right outer join on the columns. ACTIONThe downward outer join algorithm introduces a cost, in terms of performance and an inflated number of result rows, in exchange for improved data reliability. This will return all the elements present in the lookup table even if they don't exist in the fact table. An outer join means return all rows from one table. My report will have these two. Make sure that this attribute is stored at the specific level in the Fact table which you want to join. MicroStrategy Technical Support can assist with resolving cross joins in a specific report, however caution should be taken when resolving such issues. key, len (little. In the right corner of the dashboard, change. Inner and outer joins are discussed with examples. Things you. Database instance, report. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Steps to reproduce This example uses the MicroStrategy Tutorial warehouse that is shipped with MicroStrategy. Log into MicroStrategy Developer. For information on how to display this property, see Viewing and Changing Advanced VLDB Properties. BakkerJoop. In an inner join, only those tuples that satisfy the matching criteria are included, while the rest are excluded. Join common key on both sides. I worked around it but din't make any difference. calldate='2004-08-24 10:29:42. PIVOT. For example, the following screenshot shows a full-outer join on DS1 and DS3, and DS2 and. Slowly Changing Dimensions (SCD) or report filters should be used in order to address the need for Theta joins. The join type for all metrics on the Report is set to "Outer". solutions Forum Left outer joins iolaper (MIS) (OP) 19 Jul 04 09:53 Hello guys, I am trying to generate a. This can be done with a union of the IDs of the multiple intermediate tables that need to do an outer join and then using the union table to left outer join to all intermediate tables, so this approach generates more passes. Open MicroStrategy Developer. Join queries. You want to place metrics on the report and make the join types Outer Join. If you write your queries with just ‘ FULL JOIN ‘, SQL Server knows you want to do a FULL OUTER JOIN. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. And I have another attribute called Address from Address table which is straightforward. KB483322: Two identical tables for a full outer join twice when metric. Video. There's a reason we're at the top of the list. To learn more about how the Global Optimization levels 3 and 4 handle inner and outer joins between metrics in MicroStrategy SQL Generation Engine, the below technical note can be used as reference. Data can come from any source accessible by Microstrategy 8, including the data warehouse, data. The default folder is: C:Program Files (x86)MicroStrategyProduct Name when installed on a 64-bit Windows environment. APPEND / UNION merges records from similar columns and removes duplicates. If there's no matching row, return null. There's a reason we're at the top of the list. Forum: Search: FAQs: Links:. Refresh individual tables and check status of the table refresh is available MicroStrategy 10. The FULL OUTER JOIN command returns all rows when there is a match in either left table or right table. If two columns both have null values, those columns are not recognized as "Equal". x:The report returns the following: Notice in the screen shot above that the Data for Project B is missing. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. The general case of JOIN operation is called a Theta join. NATURAL JOIN. 2. x, once a custom group and a level metric are add into a report, though you enable join type to outer join, null value still can’t been seen. To perform an outer join against a lookup table Open the Project Configuration Editor. FROM t1 FULL OUTER JOIN t2 ON t1. Maybe try running one report each with each metric and making sure that there really are valuse that you are missing. 0. We specialize in MicroStrategy and are expert in producing quicker, impactful and user-friendly analytics within Data Warehousing and Business Intelligence domains. ACTION: To take advantage of this new feature upgrade to MicroStrategy 10.