You can create a Grid/Graph for each of the datasets, so that each Grid/Graph shows the data from its respective dataset, with no impact from the other datasets. The Grid/Graph would display the same four rows and data, as shown below: You can also create a Grid/Graph that contains the attributes and metrics from the two datasets. In this case, because the attributes and the filter are the same, the result displayed in the Detail section has the same number of rows as the original reports, but it can display all three metrics together, as shown below. When the document is executed, it creates a virtual dataset by joining the two datasets. Dataset 1 (the grouping and sorting dataset) contains the metrics Revenue and Units Sold, while dataset 2 contains the metric Profit.Ī document contains these two reports as datasets. Both datasets contain the same Region and Year attributes. Two sample dataset reports are executed as standard MicroStrategy reports displayed in grid view. The result is that the Detail, Group Header, and Group Footer sections behave as if the document has only one dataset. This example explains how a document behaves with multiple datasets that have the same attributes and the same report filter. Result: All Detail is at a level combining all attributes. (See Example 3: Dataset with a superset of attributes that are in another dataset)Įxample 4: Different attributes. (See Example 2: Same attributes, different filter)Įxample 3: Dataset with attributes that are a superset of attributes in other datasets. Result: Acts mostly as one dataset, but missing values are blank. (See Example 1: Same attributes, same filter)Įxample 2: Same attributes with different element values. Įxample 1: Same attributes in both datasets, different metric, and same filter (same element values).The following examples show how datasets are joined.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |