Right click on the Grid object and select Properties and Formatting to set Photo Uploader as the widget under Widget setting unchecking full screen for android phone as following. ” icon to expand it: All page-by attributes will. All articles. It is used to apply database (row-level) security to a MicroStrategy user. Double-click 'Add Qualification'. Navigate to and select a Transaction Services report, then click OK. To execute more than five statements, insert multiple statements in Report. A custom group is a special filter that can be placed on a template and is comprised of an ordered collection of elements called custom group elements. Use consolidation editor: use the Consolidation Editor: USECONSOLIDATIONEDITOR: Use custom group editor: use the Custom Group Editor: USECUSTOMGROUPEDITOR: Use data mart editor: use the Data Mart Editor: USEDATAMARTEDITOR:. KB46734: In MicroStrategy Web 9. The "Grouping" property has six possible. Case. A sample report is: Attributes: Metadata, Project, Object, Object Type, Component Object Type. And leverage the Page-By function to focus your analysis on one element. The metric can also show a total by page, show a total for each value of the attribute, or show the grand. 9% of resumes. For example, we create a group that is “East Zone” and generate a list of regions that are in the east zone. Zip File Name: Type a name for the zip file in the Zip File Name field. Selectors that contain attribute, custom group, or consolidation elements as selector items can also include an option to display totals. That is, we will not be able to create these elements using the. . The tooltip will show the dataset type listed as a Super Cube. You can consider custom groups as many different reports "stacked up" together. For example, a document contains two datasets. A custom group element is a logical expression of qualifications. In the bottom left corner, click on the button "Generate Connection File". The Custom Learning Portal is a customized learning page, hosted on MicroStrategy. Schema objects include facts, hierarchies, and custom groups; application objects include reports, documents, and metrics; and configuration objects include project sources, database instances. The properties needed to define a column of a DB table (Columns) Top level object - represents a Castor installation (Castor Server Config. custom groups. {&GROUPLABEL} Name of the graph. This approach makes it easier for you to specify a flexible partitioning. comArchitects can now do more with MicroStrategy Workstation. The total is calculated for all the selector items. 2. exe to this machine. Insert an HTML container (and not an image) and insert the script below. Custom groups are. MicroStrategy is a data visualization tool. Created different types of objects such as attributes, metrics, filters, prompts, Custom Groups and Consolidation. A split hierarchy is one - that at the lowest level - has more than one child. xmay wish to see data in Region wise. A custom group is made up of an ordered collection of components called custom group elements. Create a new Metric called '1997 Dollar Sales' using 'Dollar Sales' with Year = 1997 as an embedded filter in the metric, and use the new metric when creating the custom group. What are custom groups? Custom Group or Consolidation? - MicroStrategy James Oliver 10. Derived elements are available only from MicroStrategy web. Custom Group and Consolidation Comparison summarizes the differences between these objects. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. The. From the Tools menu, select Grouping. 1. The Consolidation Editor contains the following sections: The left pane contains an element list that includes the consolidation element you add. Designed Prompts and Filters to generate reports in grid and graph mode. Syntax . For tp & TPPARAM: System Overview Screen -> SAP System -> Check -> Transport Tool. For example, you may want to see all the customers in a retail store that bring in over. This calculation takes place in an analytical Engine so this helps for better performance when compared to Custom Group. 1K views 5 years ago MicroStrategy. The recursive hierarchy table has to be split into several tables, one for each level in the hierarchy. When this custom group is placed on a report with the metric and an answer of '8' for the prompt, the following results are returned:Tile grid map is an abstraction of the map data to solve the issue of difference in sizes causing issues with shading and making it difficult to compare geographic information. Sankey diagrams visually emphasize the major transfers or flows within a system, helping users locate dominant contributions to an overall flow. Change the formatting of the values to have different colors. Consolidation with diff groups of cities as regions. September 18, 2018. -> Check -> Request Consistency. •. Description: MicroStrategy lets you create consoli. DOWNLOAD NOW. {&GROUPLABEL} Name of the graph item's category. Such as Sum Metric = Metric 1 + Metric 2 + Metric 3The "Custom Group Element Header Display Position" should be selected to reflect where the user would like to display the partial sum. 35K subscribers 2. Custom Group Effects on SQL Generation. 3. x. The consolidation calculates at the report dataset level, aggregates that, and then does the consolidationCustom Tooltips in Microstrategy developer and Web The following table describes the macros you can use to customize graph tooltips in both MicroStrategy Developer and MicroStrategy Web: Macro Information Displayed {&TOOLTIP} All relevant labels and values associated with a graph item. UX Designer, MicroStrategy To enable totals or subtotals for a metric. The Subscribe to FTP dialog box opens. ApplyAgg. Custom Tooltips in Microstrategy developer and Web The following table describes the macros you can use to customize graph tooltips in both MicroStrategy Developer and MicroStrategy Web: Macro Information Displayed {&TOOLTIP} All relevant labels and values associated with a graph item. Create New Metric in a report or VI. Autotext code/macros in Microstrategy Document/dashboard. The best part I liked the most about the tool is we can have a different kind of security which can be implemented like the object kevel security, data level security or. Select any project that is in the project source that contains the users and groups and click Next. The purpose of this Tutorial is to create a report which displays the top ten contributors versus all other contributors by use of custom groups in MicroStrategy Web. The Custom Group content should be similar to: 2) Create a RunningSum metric over the regular Revenue metric:1. Display the hierarchical view in the report (MicroStrategy Developer only) These tasks are completed at different levels and in different MicroStrategy. IF (Condition, TrueBranch, FalseBranch) In this guide, lists of attributes, metrics, values, parameters, etc. Source: MicroRooster. ). MicroStrategy - Real Time Consolidations & Custom Groupings - Online Training Video by MicroRooster MicroRooster 6. Consolidation ; Custom group; Fact; Metric; Subtotal; Transformation; For information about consolidations, custom groups, metrics, and subtotals, see the Advanced Reporting Guide. Fact table levels: The context of your data. Consolidations serve two powerful functions that can greatly enhance your reporting abilities: You can create a. Below were my list of questions to be aware as an basic MicroStrategy Developer from my personal experience (dusted from my backup to share with you all). The grouping options for levels include: Standard, which groups by the attribute level of the target. Recommendation. To add a derived element to a document, open the document in Editable Mode. Right-click the custom group, then select Edit. They allow you to group attribute elements in new ways without changing the metadata and. The following table summarizes the similarities and differences between consolidations and custom groups. First, create a consolidation that has a few elements but specifically at least one element with more than 2 attribute elements in its consolidation. The Grouping panel is displayed. Schema objects include facts, hierarchies, and custom groups; application objects include reports, documents, and metrics; and configuration objects include project sources, database instances. This prompt is used in a filter. Technically this will result is different queries on the database, due to the fact that each calculation level is different. By default, this executable is located in C:Program FilesMicroStrategyIntegrity Manager. Say you want to create a custom group called "Sales Region" based on the State attribute: Tom sales region - California, Oregon, Nevada; Mary sales region - Atlanta,. The “ #n” code in Apply function syntax serves as placeholders for the MicroStrategy objects being passed to your database. We will explore two objects that serve this purpose: Custom Groups and Consolidations. In MicroStrategy Web, right-click an object and select Share. community. In MicroStrategy Workstation, right click on any cube created via Data Import and select Properties. ×Sorry to interrupt. Per Cell: Allow MicroStrategy to display the selected metrics using the axis values best suited to display the metric data. MicroStrategy Interview Questions. The report displays derived elements defined using. Custom number format syntax — If none of the built-in number formats meet your needs, you can create your own custom format in the Number tab of the Format. Refresh. for each successive object passed. Source: MicroRooster. Autostyles can be either saved based on an existing document or they can. Content groups can be defined for a custom application to limit the content that can be viewed by end users in the Sidebar menu of all Library clients, including mobile. In the MicroStrategy Mobile app, depending on your device, you can navigate to the Shared Reports folder in a variety of ways: When the Mobile user taps the URL on the mobile device, the user may be prompted to provide a user name and password to log in to MicroStrategy Mobile Server using this authentication mode. All attribute element data is added together to form the metric values for the new Group derived element. Credits; About the Authors. Open the custom group editor and drag an object from the object browser to create a custom group. Drag an attribute from the Datasets panel to the Rows area of the Editor panel to add attributes to the rows. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. To open a document in Editable Mode, from a folder, right-click the document, point to Run as, and select Editable. Consolidations are used to group the attributes without disturbing the schema and it can group attributes based on the elements. x, select 'Project Documentation' from the Tools menu to start the wizard. Create a consolidation with Region grouping 1-2 different attribute elements. It leverages data connectivity, machine learning and mobile access to offer users comprehensive control over their insights. The schema looks like the following diagram. V. Create a consolidation with Region grouping 1-2 different attribute elements. This article will help. What is relevant, rather than the sum, is the last atomic inventory value in a given period of time. Mastering Business Intelligence with MicroStrategy; Credits. Dynamic Custom Group in Dashboards or Dossiers. If you have many reports or tasks that need to be executed on the same time-based schedule, consider creating several similar schedules that trigger 15 minutes apart. It allows users to customize data visualizations and build personalized real-time dashboards. As you can imagine, the SQL Engine. Why MicroStrategy Why MicroStrategy; Customer StoriesThe user privileges that take up a Transaction Services license are denoted by 4 asterisks (****) in the User Editor. How to create a MicroStrategy connection file (. For example - We need to see a…Custom number format syntax — If none of the built-in number formats meet your needs, you can create your own custom format in the Number tab of the Format Cells dialog box. Supports custom properties (10. 5% of organizations plan to have adopted SASE by the end of 2022. The Create Personal View dialog box opens. microstrategy. The goal is to create an image link that is used to export the grid, like shown below: Document in Edit Mode Follow the steps below: 1. Browse to the folder in which to create the new custom group, then click the Create Custom Group icon. x, select 'Project Documentation' from the Tools menu to start the wizard. Once data flows into the interface, the dashboard will come to life. MicroStrategy recommends that you use event-triggered schedules in situations where it is important to control which node performs certain tasks. 0). So distinct counts would not be possible. Loading. A connection map in MicroStrategy is a link between a MicroStrategy user, a database connection, and a database login. For example, the separator is a comma (,) in English and a semicolon (;) in German. Ca se functions Microstrategy Case functions return specified data in a SQL query based on the evaluation of user-defined conditions. The attribute level follows a consecutive order from. Other notable enhancements. MicroStrategy manages the mapping between the logical table and the physical tables. Custom Tooltips in Microstrategy developer and Web The following table describes the macros you can use to customize graph tooltips in both MicroStrategy Developer and MicroStrategy Web: Macro Information Displayed {&TOOLTIP} All relevant labels and values associated with a graph item. x. 6. If a user enters more than 15 digits for a. Since the Query Engine uses a smart algorithm to combine consolidation elements and determine the minimal number of SQL passes, only one SQL pass may be needed for all the consolidation elements. Disadvantages of Power BI: Limited Data Capacity in Free Version: The Power BI Desktop version has a data capacity restriction, which can limit in-depth data analysis for larger datasets. Description: A training video demonstrating how to create, use and forma. Numeric prompt: Users enter a specific number, up to 15 digits, which is then used as part of a filter, or within a metric, to look for specific numeric data. Custom Group or Consolidation? - MicroStrategy James Oliver 10. In order to set up an incremental refresh report, the user should first right click on the Intelligent Cube and select "Define Incremental Refresh Report": This will bring up the Incremental Refresh Options editor: Here, the user can define one of the following Refresh type options: Update: If new data is available, it is fetched and added to. How to create a consolidation in MicroStrategy. Starting in MicroStrategy 2021 Update 1, there is an new out-of-the-box, feature-rich. ALTER CUSTOMGROUP "My Custom Groups" IN FOLDER "Public ObjectsCustom Groups" NAME "Modified My Custom Groups" DESCRIPTION "Modified Copy of My Custom Groups" FOLDER "Public ObjectsCustom GroupsModified Custom Groups" ENABLEHIERARCHICALDISPLAY FALSE ENABLESUBTOTALDISPLAY TRUE. In MicroStrategy SQL Generation Engine 9. Step 1. In the list of categories on the left, click Subtotals. Microstrategy Dossiers With the release of MicroStrategy 10. Retrieve a list of user groups and the associated users in MicroStrategy Developer Follow the steps below to create a list of all groups and the users in each group: In MicroStrategy Developer 9. Become a More Intelligent Enterprise. bandings on Attributes or Metrics to group the. Custom Tooltips in Microstrategy developer and Web The following table describes the macros you can use to customize graph tooltips in both MicroStrategy Developer and MicroStrategy Web: Macro Information Displayed {&TOOLTIP} All relevant labels and values associated with a graph item. How MicroStrategy empowers you to design and deploy compelling, responsive Dossiers suited for all audiences and devices in under a day Speakers: Amy Laresch, Product Manager, MicroStrategy; Keng-Fu Chu, Principal UX Designer, MicroStrategy; Jeff Courcelle, VP of UX Design, MicroStrategy; Julia Zhu, Sr. KB4377. For example, ApplySimple ("#0 * #1", [col1], [col2]) indicates that two items, col1 and col2, referenced. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . Place the newly created consolidation in the template. On the toolbar, click Add Element. This article will help you learn to use these elements to create more powerful and unique grids. Consolidations are used to group the attributes without disturbing the schema and it can group attributes based on the elements. In free-form layout, we provide an intuitive way to let you visually “group” containers together. But then it will add these 2 together for A+B. Subtotals. x and 10. 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. Do one of the following: To apply the selections as a filter, select the Apply selections as a filter for all new targets check box. Being able to run this calculation would be useful for. Cards present predefined KPIs associated with a selected keyword sourced securely from MicroStrategy. Group Elements. com Format: A MicroStrategy Online Training Video blog. Right-click on the metric header to apply the condition or threshold and select 'Alerts': Specify the conditions to meet for the delivery to be triggered in the filter editor: Expand the Delivery Settings section. To access the setting, in MicroStrategy Developer right-click on the project and select Project Configuration…Then, In the Project Configuration dialog box, choose Project Definition >. 1, custom group selector does not have the custom group elements, while in 9. In MicroStrategy Web, edit or execute a report. 3. Second, create a metric that has the base attribute used in the consolidation as a part of the dimensionality. For information on whether your database supports various date and time functions, see MicroStrategy and Database Support for Functions. Normally, users would accomplish this with an attribute by setting it to the level of that attribute, however that may not produce desirable values. A Document Autostyle is a collection of formatting properties saved in a document for various control types (sections, text fields, lines, etc. The report execution process is a three-step process: 1. These values are set by default when the "Hive 0. Number of years active 18. Custom Visualizations: Users can create or import custom visuals to make their reports more tailored and effective. – Calculations. These groups provide a new view of report data for analysis and formatting purposes. A custom group is a set of special filters that can be placed on a template. Add the Age Groups Custom Group and the Profie and Revenue metrics to a report in MicroStrategy 10. A user may have a report with a custom group/consolidation and attributes and want to return the total within each custom group/consolidation element. blogspot. Consolidations allow users to group attribute elements in new ways without changing the metadata and warehouse definitions. 1. The Document Properties dialog box opens. West = Northwest, Southwest. For this class,. Get inspiration at the MicroStrategy data visualization gallery. It includes built-in geocoding that auto maps executive locations. Consolidations allow you to qualify a report on a row-by-row basis. The settings are numbered 1-5. From the perspective of the report design process, a custom group is an object that can be placed on a template. The index for referencing these objects begins with 0 and increases by. When this report is executed, only two custom group elements are displayed even though five elements are defined in the custom group. To support best dashboard execution and concurrency performance, MicroStrategy has chosen to limit the number of logical CPUs engaged for any single grid evaluation to 4. Click OK. MicroStrategy is the best BI tool used for reporting the data in very good design and graphical way. This allows you to group attribute elements on a report in a way that is not defined in your data warehouse. This option is available only when the Compress Contents check box is selected. Starting in MicroStrategy 2021 Update 2, you can create or edit standalone consolidations for a project. Labels: #Creat transaction services photo uploader #transaction. Interact with the engaged MicroStrategy Community to get answers to all your. Both products' features range. To Create a Custom Group. Select any project that is in the project source that contains the users and groups and click Next. Below are the new features exclusive to. Reports are now available to use and interact with in MicroStrategy Library: View standard reports in MicroStrategy Library to get a simple, grid view of data. Otherwise, to define tooltips for a single series, select the name of the series. Extensively worked in creating and integrating MicroStrategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) with the data warehouse. Slowly changing dimensions in MSTR. Modified 3 months ago. They are made up of custom group. If the document is already open in Design Mode, click the Editable Mode icon . 7x" database object is used (set at Configuration Managers > Database Instances > Database Instance > Database connection type) Selected Default VLDB Properties for Hive 0. It is made up of an ordered collection of elements referred as custom group elements. 5. 4. Unique Features. Consolidation elements can also be an expression of attribute elements that make up a consolidation. However, it is not expected to see a metric value corresponding to the Custom Group. MSTR Secure Enterprise. MicroStrategy Advanced Reporting Guide provides comprehensive information on advanced topics for using the MicroStrategy query and reporting products. – Filters. Creates a connection object which is used in subsequent requests and manages the user’s connection with the MicroStrategy REST and Intelligence Servers. Type the following for the name: "Total for the #P #0". That is, we will not be able to create these elements using the. Custom Group vs Consolidation; Auto Styles (Report vs Document vs Dossiers) Reports Creation. comA selector can change panels, the focus of a Grid/Graph, or dynamic text fields (a text field that is a reference to an object on a report) in a panel stack. Consolidations and custom groups can support, because another sql statement may be created and retrieve the correct results from base tables. 4. Study MicroStrategy Advanced Reporting flashcards. Enable hierarchical display for the custom group. . Selectors that contain attribute, custom group, or consolidation elements as selector items can also include an option to display totals. VLDB Category. Next, browse and choose the required attributes to create the. For example, you need to analyze data by season (Fall, Winter, and so on) although your project does not contain a Season attribute. This is a list of the available auto text macros that the Report Services Document engine recognizes. Asked 4 years, 11 months ago. Go to Start -> Programs -> MicroStrategy -> Tools, run ScanMD. MSTR Health Center (if it's not uninstalled) MSTR Office (if installed) DHTML Editing Component (if installed) Restart the machine. For example, you might group the Month elements into December. The Preferences dialog box opens. (For a definition and examples of levels of aggregation, see How data is aggregated on a report: metric level . . The Configure Transactions Editor opens. Close the Visualization Builder, and then re-open it. Retrieve a list of user groups and the associated users in MicroStrategy Developer Follow the steps below to create a list of all groups and the users in each group: In MicroStrategy Developer 9. Learn more. Problem. Compare all the important BI vendors with our 100% independent Business Intelligence tools comparison. Copy the code for the D3 visualization you are using. A custom group is made up of an ordered collection of elements called custom group elements. . The report should contain the attributes, metrics, and other objects that you want to use as columns in the data mart table and which will populate the data mart table. Microstrategy Dossiers With the release of MicroStrategy 10. The Metric Editor opens in either Function Editor mode or Formula Editor mode, depending on the type of metric you chose to edit. A Group derived element is a combination of attribute elements into a single derived element. The report displays derived elements defined using. Specify the desired delivery options including recipient address, subscription name. In the Navigation pane, click Dossiers. Select only Configuration Objects for documentation. Whether you're working with dossiers, cards, documents, or managing an entire intelligent enterprise, Workstation empowers you to do everything from one place. utils; com. For example you can determine Top 20 customers, report the revenue of all customes with M, and add some regional figures in a single custom group. In addition, this release introduces new features across the analytics, mobility, and security platforms—making it easier for users to build applications faster. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Enterprise Analytics Business Intelligence; HyperIntelligence; Cloud; Product Innovation; Education; Consulting HyperIntelligence and its Architecture. Custom Tooltips in Microstrategy developer and Web The following table describes the macros you can use to customize graph tooltips in both MicroStrategy Developer and MicroStrategy Web: Macro Information Displayed {&TOOLTIP} All relevant labels and values associated with a graph item. x, select 'Project Documentation' from the Tools menu to. None, which excludes the attribute in the target from the GROUP BY clause in the SQL statement. The goal is to create an image link that is used to export the grid, like shown below: Document in Edit Mode Follow the steps below: 1. For example, you might group the Month elements into December. These groups provide a new view of report data for analysis and formatting purposes. Right-click the header of the attribute whose elements you want to use to. Considerations for the use of star schemas with MicroStrategy SQL Generation. 9K views 4 years ago MicroStrategy In this video I will discuss when you should use a. However, you can use the advanced sorting functionality to sort a custom group in either of the following ways: Sort on the IDs of the attributes that compose the custom group. Watch this to learn about creating custom groups, time-based transformations, and shortcuts—all in. 4. When creating a VI Dashboard which contains a grid dataset along with either a consolidation or custom group object, the 'Create Attribute' option does not display for any other normal attribute in the dataset. Overall customer rating 9. Make two grids with different attributes and metrics in each 3. Add a condition to a custom group element. Consolidations allow you to qualify a report on a row-by-row basis. Filters data related to a business attribute’s form (s), such as ID or description. The maximum file size of dashboard (. II. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . In the "Metadata Repository" screen, select the "Project Source Name" and check the "Export Translations" option, as shown in the. blogspot. Define the advance sort on the derived. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . But it’s nipping at the heels of leading BI. Custom groups are used to apply different filters to different rows of a report. )Right-click the custom group, then select Edit. Click the name of a custom group element and type a new name in the field. ApplySimple() Accepts facts, attributes, and metrics as input. A custom group is a set of filters that can be placed on a template. Creating Powerful (and Beautiful) Dossiers. Use a percent-to-total shortcut metric to show cell-level values as percents of an accumulated row or column total. Explanation. A derived element is a grouping of attribute elements on a report. The different kinds of value prompts are: Date prompt: Users enter a specific date for which to see data. Skip to content. Uninstall all the MicroStrategy and related products from Control Panel: Any MSTR Hotfixes applied. February 24, 2017 Uncategorized Consolidation and Custom grouping are special type of grouping filters and they are used when a User wants to see the metric values based on. com Format: A MicroStrategy Online Training Video blog. Notice that the bars are described by the labels on the X Axis, which break down as follows: Central (Region attribute), Jan 2010 (Month attribute), and either Lethal Weapon 4 or Zorro (custom group elements based on Item attribute). Select the 'Advanced' tab, as shown below: Change the setting for 'Attribute element browsing' (circled in red above) to the limit that is desired for the project. The Running Sum is defined as follows: RunningSum<BreakBy= {Subcategory}, SortBy= (Month) > ( [Units Received]) and should be the sum of the Units Received + Running Sum. Calculate each attribute individual weight according to the level in the hierarchy (level in hierarchy/number of levels in hierarchy * 10). One of the powerful advantages of consolidations is the ability to create virtual attributes, which allow you to group attribute elements in a customized way. Ans: MicroStrategy enables ad hoc analysis through an intuitive interface. If projects are distributed asymmetrically across the cluster, when you assign an event-triggered schedule to a project, make sure you trigger the event on all nodes on which that project is loaded. 5. There are several ways to do this but I guess the easiest one will be creating a Metric which is the sum of all the metrics to be used in the report. To resolve this issue, perform the following steps: Right-click on the Project in MicroStrategy Desktop and go to Project Configuration. Examples of this category are simple mathematical. All", change the definition as below and save it as "Top 5. Select only Configuration Objects for documentation. The following window appears on completing the above step. Normally, users would accomplish this with an attribute by setting it to the level of that attribute, however that may not produce desirable values. Each of the individual "mini-reports" that make up the entire custom group report will have at least one, if not more, SQL passes of its own. Click "Add Photo" and select photos to upload. 5K subscribers Subscribe 3. Level metrics allows the users to choose the right combination of level target, filtering, and grouping (referred to as elements) to achieve your desired results. – Calculations. Fu nction Types. They can create custom calculations, prompt for inputs, and easily share findings. This prompt is used in a filter. Microstrategy Dossiers With the release of MicroStrategy 10. 3. x, select 'Project Documentation' from the Tools menu to start the wizard. . An object is a basic building block in MicroStrategy. Without data, the dashboard will not show the user anything. The developer would create one or more Filter. Click Save to save changes. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. A consolidation allows you to group together the elements of the Month of Year attribute into various seasons and place them on the template. In its most basic form it consists of two parts: A report template (usually simply called a template), which is the underlying structure of the report. From the Tools menu, select Document Properties. Inherit Attribute Sort, which uses the default sort of the attribute form set to display first. The third most common microstrategy developer skill is templates on 5.