Decision Insight 20200928 Save PDF Selected topic Selected topic and subtopics All content How to create multi-dimensional datagrids Case You want to aggregate messages which depend on 2 dimensions that have no links between them. In this example, we want to look for anomalies which depend on ‘Site’ and ‘Code’. How-to do that Create a datagrid and put the 2 dimensions, either as ‘Rows’, ‘Columns’ or ‘Global dimension’ : Then click on ‘Add value’, and ‘Would you like to bring attributes from another entity’. In the next window, select each of your ‘Path from dimension’, and reach ‘Anomalie’ : Click on ‘Done’, you will be on the list of attributes of ‘Anomalie’. You may then aggregate the appropriate attribute : After aggregations, you will have something similar : Tips If you find yourself with 3 dimensions on a datagrid, and only want to aggregate 2 dimensions, you just need to only specify 2 out of the 3 possible paths and this will create an aggregate on only the specified dimensions. Related Links
How to create multi-dimensional datagrids Case You want to aggregate messages which depend on 2 dimensions that have no links between them. In this example, we want to look for anomalies which depend on ‘Site’ and ‘Code’. How-to do that Create a datagrid and put the 2 dimensions, either as ‘Rows’, ‘Columns’ or ‘Global dimension’ : Then click on ‘Add value’, and ‘Would you like to bring attributes from another entity’. In the next window, select each of your ‘Path from dimension’, and reach ‘Anomalie’ : Click on ‘Done’, you will be on the list of attributes of ‘Anomalie’. You may then aggregate the appropriate attribute : After aggregations, you will have something similar : Tips If you find yourself with 3 dimensions on a datagrid, and only want to aggregate 2 dimensions, you just need to only specify 2 out of the 3 possible paths and this will create an aggregate on only the specified dimensions.