After MicroStrategy 9.4.1, we have a new feature that has ability to add different objects such as attribute/metrics will be added from any dataset in the document to a grid/graph. This new concepts is also known as Data Blending.
To support this capability, the Analytical Engine behavior with respect to join data from multiple datasets has been enhanced. As a result the "Join Behavior" now have Primary or Secondary join type.
If a document/dashboard contains multiple datasets, you can decide which datasets determine the values that appear in the dashboard.
To display all the values in a dataset, regardless of whether they appear in other datasets, choose the dataset as a primary dataset. When you add a dataset to a dashboard, it automatically becomes a primary dataset. You can have multiple primary datasets in a dashboard.
The impact of changing the 'Join Behavior' for a dataset in a Report Services Document/Dashboard containing multiple datasets is as below.
Lets say we have two dataset (A and B)
dataset A contains data such as {0,1,2,3}
dataset B contains - {1,2,3,4}
Below are the possible joining and result behavior .
1) if A is primary and B is primary then full outer join will perform {0,1,2,3,4}
2) if A is primary and B is secondary then left outer join will perform {0,1,2,3}
3) if A is secondary and B is primary then right outer join will perform {1,2,3,4}. Since we do not have right out join MicroStrategy . So if we want to perform A right outer join B then MSTR will do like this B left outer join A, which means (A right outer join B or B left outer join A).
4) if A is secondary and B is secondary then inner join will perform {1,2,3}.
For more clarity take another example.
To support this capability, the Analytical Engine behavior with respect to join data from multiple datasets has been enhanced. As a result the "Join Behavior" now have Primary or Secondary join type.
If a document/dashboard contains multiple datasets, you can decide which datasets determine the values that appear in the dashboard.
To display all the values in a dataset, regardless of whether they appear in other datasets, choose the dataset as a primary dataset. When you add a dataset to a dashboard, it automatically becomes a primary dataset. You can have multiple primary datasets in a dashboard.
The impact of changing the 'Join Behavior' for a dataset in a Report Services Document/Dashboard containing multiple datasets is as below.
Lets say we have two dataset (A and B)
dataset A contains data such as {0,1,2,3}
dataset B contains - {1,2,3,4}
Below are the possible joining and result behavior .
1) if A is primary and B is primary then full outer join will perform {0,1,2,3,4}
2) if A is primary and B is secondary then left outer join will perform {0,1,2,3}
3) if A is secondary and B is primary then right outer join will perform {1,2,3,4}. Since we do not have right out join MicroStrategy . So if we want to perform A right outer join B then MSTR will do like this B left outer join A, which means (A right outer join B or B left outer join A).
4) if A is secondary and B is secondary then inner join will perform {1,2,3}.
For more clarity take another example.
For example, a dashboard contains the following datasets:
- Regional Revenue dataset
Region
|
Revenue
|
Central
|
$5,029,366
|
Mid-Atlantic
|
$4,452,615
|
Northeast
|
$8,554,415
|
Southeast
|
$2,239,951
|
- Regional Profit dataset
Region
|
Profit
|
Mid-Atlantic
|
$764,323
|
Northeast
|
$1,300,732
|
Northwest
|
$266,986
|
South
|
$336,675
|
If you place the region, revenue, and profit objects on a grid, all the regions are displayed, even if they do not have both a revenue value and a profit value, as shown below:
| Region | Revenue | Profit |
| Central | $5,029,366 | |
| Mid-Atlantic | $4,452,615 | $764,323 |
| Northeast | $8,554,415 | $1,300,732 |
| Northwest | $2,239,951 | $266,986 |
| South | $336,675 |
All the values for the Region attribute are displayed in the grid because both datasets are, by default, primary datasets.
If you change the Regional Profit dataset to be a secondary dataset, its values are displayed only if a primary dataset contains the same value. In this example, South is not displayed on the grid because the primary dataset Regional Revenue does not contain data for the South region. Central is displayed, even though it does not have any Profit data, because it belongs to a primary dataset.
All values are displayed for primary datasets, regardless of whether they appear in other datasets.
| Region | Revenue | Profit |
| Central | $5,029,366 | |
| Mid-Atlantic | $4,452,615 | $764,323 |
| Northeast | $8,554,415 | $1,300,732 |
| Northwest | $2,239,951 | $266,986 |
If both datasets are defined as secondary datasets, only the values that appear in all the datasets are displayed. In this case, only Mid-Atlantic, Northeast, and Northwest are displayed, since they are common to both datasets.
| Region | Revenue | Profit |
| Mid-Atlantic | $4,452,615 | $764,323 |
| Northeast | $8,554,415 | $1,300,732 |
| Northwest | $2,239,951 | $266,986 |
Hope this helps understanding the concepts better . Happy learning !!!..
Comments
Microstrategy Training
Microstrategy Online Training india