What is consolidations in mstr?
Consolidations allow you to group attribute elements in new ways without changing the metadata and warehouse definitions. You can use consolidations on a report just like regular attributes. Consolidations allow you to qualify a report on a row-by-row basis.
What is the difference between custom group and consolidation?
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.
What are custom groups in microstrategy?
A custom group is a set of special filters that can be placed on a template. A custom group is made up of an ordered collection of elements called custom group elements. Consolidations are used to specify the data that you want to view in your report.
How do you create consolidation?
Select the upper-left cell of the area where you want the consolidated data to appear. On the Ribbon, Choose Data > Consolidate to view the Consolidate dialog: In the Function box, click the summary function that you want Excel to use to consolidate the data.
How do I create a custom group?
To Create a Custom Group Browse to the folder in which to create the new custom group, then click the Create Custom Group icon. The Custom Group Editor appears. Enter a name for the custom group in the Enter Custom Group Name Here field.
What is a custom group?
Custom groups (sometimes referred to as user-defined groups in other systems) can be used to manage groups of students, guardians or staff for specific purposes, such as making custom reports or easily contacting them. Custom Report Writer – Use filters to include or exclude students in certain custom groups.
How do I consolidate large amounts of data in Excel?
Click Data>Consolidate (in the Data Tools group). In the Function box, click the summary function that you want Excel to use to consolidate the data. The default function is SUM.
How do I create a custom group in Microstrategy?
To Create a Custom Group
- Browse to the folder in which to create the new custom group, then click the Create Custom Group icon.
- Enter a name for the custom group in the Enter Custom Group Name Here field.
- Enter a description for the custom group in the Enter Custom Group Description Here field.
How do I create groups on my desktop?
To add your own group containers to the desktop, click the Nimi Places icon in the system tray. This will open the window as shown in the screenshot below. Click the + button at the bottom right to make a new container. Then click Place, and select one of your desktop shortcut folders.
Can you merge data in Excel?
You can use the Excel merge and converge functionality to keep things organized. Excel offers more than five ways to merge spreadsheets or consolidate data rows and columns in a primary workbook.