Microstrategy Analytics

VLookup kind of Dynamic Custom Group in Dashboard/Dossier  Custom groups enable users to view specific elements based on a metric or specification. For example, you may want to see all the customers in a retail store that bring in over $1,000k in revenue per month, or a teach may want to only view data on students who scored over 2000 on their SATs.  The Scenario Let's assume you have a table that clusters your Employees by the Cost brackets. Based on those brackets a Rating is defined (like A, B, C...). This table can be imported from Excel file or from a table in relational database. You will notice there is a flag column that contains value '1' for each row. If you don't have this column in your data don't worry! Just use the Upper column instead in the formula (see formula of 'Rating Metric' below). Continue on with the process.  Methods for creating a custom group Currently, your Dashboard or Dossier displays  Cost per Employee , but it is missing ...

Custom group and consolidation comparison Both consolidations and custom groups provide flexibility in reports, but the objects differ in their structure and use. The essential distinction is that consolidations work with attributes and custom groups use filters. Consolidations are groupings of attribute elements while custom groups are based on filter criteria. Custom groups are used to apply different filters to different rows of a report. Consolidations are used to create virtual attributes to allow reporting on attributes that do not exist in the data model. Finally, row level math can be performed with consolidations but not with custom groups. Custom groups are more flexible than consolidations because you do not have to know much about your data to create filters for a custom group. In contrast, consolidations require that you know exactly which attribute elements to select when creating the consolidation. To continue with the examples from the previous sect...