Count of Parents in Platform Analytics: There is an OOTB metric called Objects, which calculates the parents of a component object. Top Tips: Setup and Support for ESRI Map Custom Shapes with MicroStrategy. 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. Create an empty MD shell in Microsoft Access. Selectors that contain attribute, custom group, or consolidation elements as selector items can also include an option to display totals. )Right-click the custom group, then select Edit. Choose File > New Consolidation. microstrategy. Mastering Business Intelligence with MicroStrategy; Credits. 1031 views | July 14, 2020 56:15. A report is a MicroStrategy object that represents a request for a specific set of formatted data from your data source. Split Hierarchy with M-M relationships: Explanation. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Enterprise Analytics Business Intelligence; HyperIntelligence; Cloud; Product Innovation; Education; Consulting HyperIntelligence and its Architecture. KB43303: After a consolidation is added to the sort-by in the runningsum parameters, the consolidation disappears after clicking OK and going back into the runningsum parameters in MicroStrategy 9. Article outlines why available cache is not utilised when drilling to an attribute inside of an Intelligent Cube report that contains a consolidation or custom group in MicroStrategy Developer (formerly Developer) and WebOnly 29% of organizations consolidate to reduce spending on licensing. Become a More Intelligent Enterprise. So, I've had this problem in my hands for the last couples of days and it drives me crazy. this allows users to perform the in-depth analysis of their data and get the valuable results from their data. 4. Select any project that is in the project source that contains the users and groups and click Next. Right-click the custom group, then select Edit. x, non-aggregatable metrics are used for this kind of calculation. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. Once data flows into the interface, the dashboard will come to life. About Custom Group Elements. There are three types of objects: schema objects, application objects, and configuration objects. Microstrategy Dossiers With the release of MicroStrategy 10. These groups provide a new view of report data for analysis and formatting purposes. Interact with the engaged MicroStrategy Community to get answers to all your. Follow the steps below: Right-click on the project and select 'Project Configuration. Click 'OK'. Description: MicroStrategy lets you create consoli. consolidation elements, which can be individually formatted. 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. To modify permissions for a user or group, from the Permission Level drop-down list for that user or group, select the predefined set of permissions, or select Custom to define a custom set of permissions. 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. Learn more. Right-click the dossier you want to certify. 6 and later) Installation Instructions. 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. Step 2. First, create a consolidation that has a few elements but specifically at least one element with more than 2 attribute elements in its consolidation. x, select 'Project Documentation' from the Tools menu to start the wizard. – Calculations. In the Calculations - Subtotals window, Select the desired Custom Group and select Yes in the Allow subtotals drop down. Custom groups. 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. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. Run the document on iPad, as shown below: 12. (i) the MicroStrategy Components developed and licensed by MicroStrategy Services Corporation (MicroStrategy) of McLean, Virginia to Oracle and imbedded in the MicroStrategy for Oracle Retail Data Warehouse and MicroStrategy for Oracle Retail Planning & Optimization applications. Finally, row level math can be performed. If a user enters more than 15 digits for a. Web Professional. Consolidations vs. Source: MicroRooster. The report is showing the correct results: Next, I created a Custom Group as follows: Now, add this custom group to the report and remove the Subcategory. 5-7 Years. For more details, see the Custom Groups and Consolidations chapter of the Advanced Reporting Guide. A badge icon appears on the item to indicate that it is certified. 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. Click Insert Visualization . To apply the selections as a slice,. Dashboard performance troubleshooting in MicroStrategy 10. When you open a web page the extension automatically scans web pages in your browser and underlines keywords that you can hover over to trigger cards. 4. -> Check -> Request Consistency. This object contains crucial project information that is generated and maintained by managers. '. mstr) files that can be sent through Distribution Services is defined by the MicroStrategy (. They can be defined from any of the following: Attribute elements from different levels of the same hierarchy, such as Region and Call Center in the Geography hierarchy. Calculate each attribute individual weight according to the level in the hierarchy (level in hierarchy/number of levels in hierarchy * 10). Now to fix this create a new Derived metric on Category attribute first with formula as Max (Category) {~ } and calling Books. utils; com. Second, create a metric that has the base attribute used in the consolidation as a part of the dimensionality. Where:The Profit metric is a simple sum of the Profit fact. Create or edit. Fine Tuning how to do from BI Developer standpoint; VLDB properties (Changing governor settings, tuning the report sql, table creation type, pre/post sql statements for any stats, etc. Type the following for the name: "Total for the #P #0". The attribute level follows a consecutive order from. Skip to content. The following is a quick reference table for a MicroStrategy Custom Group: A Custom Group is an Application Object that creates dynamic sets of data in such a way that it gives the ability to create several mini-reports inside a Report. By implementing the security policies and configurations provided by MobileIron, administrators can apply enhanced protections to mobile devices in use across the enterprise. When you open a web page the extension automatically scans web pages in your browser and underlines keywords that you can hover over to trigger cards. mstrc) Open Workstation. ,) SQL level tuning (Stats, Indexes, Cross Join Avoid, etc. Consolidations are used to specify the data that you want to view in your report. Example. The Document Properties dialog box opens. Using the. Your personal view subscription is saved, and you are returned to the report, document, or quick dashboard. Consolidations are groupings of attribute elements while custom groups are based on filter criteria. This is a database instance level VLDB setting. Examples of this category are simple mathematical. That is, we will not be able to create these elements using the. Browse to the folder in which to create the new custom group, then click the Create Custom Group icon. About the Authors; About the. Visit the data visualization and data dashboard galleries for inspiration. So distinct counts would not be possible. You can consider custom groups as many different reports "stacked up" together. ApplySimple() Accepts facts, attributes, and metrics as input. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . The following is a quick reference table for a MicroStrategy Custom Group: A Custom Group is an Application Object that creates dynamic sets of data in such a way that it. Submit Search. simply a grouping of attribute elements is called Consolidation. Handling slowly changing dimensions in a data warehouse depending on the user needs. Normally, users would accomplish this with an attribute by setting it to the level of that attribute, however that may not produce desirable values. The trouble of modifying custom SQL for every object which uses an Apply function when customers switch to different RDBMS and the SQL pattern changes for functions. The report data is as displayed below. Consolidation elements can also be an expression of attribute elements that make up a consolidation. MicroStrategy’s OLAP Services is an expansion of MicroStrategy Intelligence Server. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories. SASE and XDR are opportunities for consolidation: 41. | Meet MicroStrategy AI on the road. Using custom groups, you can group attribute elements in a way that is not defined in the data warehouse. The SQL will pull back counts for A and B. To install this visualization, download the . 3. Both documents and RS dashboards provide the freedom to design a dashboard pixel-by-pixel in multiple editing and previewing modes. To execute more than five statements, insert multiple statements in Report. it looks like MicroStrategy doesn't support it, please advise. 4. microstrategy. The grouping options for levels include: Standard, which groups by the attribute level of the target. 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. Consolidations are groupings of attribute elements while custom groups are based on filter criteria. Enable hierarchical display for the custom group. Designed Prompts and Filters to generate reports in grid and graph mode. 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. Change the formatting of the values to have different colors. How to create a MicroStrategy connection file (. Information about custom groups includes: About Custom Groups: Grouping Attribute Elements with Banding and Filtering Custom Group Effects on SQL Generation Custom Group Structure on Reports Creating a Custom Group Editing and Formatting a Custom Group Consolidations are groupings of attribute elements while custom groups are based on filter criteria. Michael Sandberg's Data Visualization BlogMicroStrategy ONE introduces new features that provide better performance and scalability to enhance the overall user experience. Below are the steps to enable/disable the settings of data blending: 1. DEFINITION: This custom group is a custom group banding qualification created on the metric, with band size banding type and a step size of '1' (integers). Consolidations: Virtual attributes. Create three reports named A (with attribute A), A&B (with attribute A and B),A&C (with attribute A and C) Create a dashboard based on the three reports created in last step. Custom groups are used to apply different filters to different rows of a report. Custom Group Effects on SQL Generation. A consolidation is a set of attribute elements grouped in a way that they were not originally grouped within the project, so that you can use the consolidation (the newly consolidated elements) just like a regular attribute on a report. West = Northwest, Southwest. 3 and later) Supports exporting to PDF (10. x, select 'Project Documentation' from the Tools menu to start the wizard. Consolidations vs Custom Groups. Each custom group element is made up of: A header, which contains the name of the custom group element and is displayed as a row in report results. To control the display of which Custom Group elements display sums, right click on the Custom Group element, and select "Show Display Options". This can be reproduced in Microstrategy Tutorial by following the steps below. The. Consolidations allow you to group attribute elements in new ways without changing the metadata and warehouse. For steps to create a custom group in MicroStrategy Developer, see the MicroStrategy. That is, we will not be able to create these elements using the. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. Consolidation elements can also be an expression of attribute elements that make up a consolidation. Zip File Name: Type a name for the zip file in the Zip File Name field. ( How?) Double-click in the Custom Group Definition pane. A derived element allows us to group on the basis of: – List of elements. Consolidations allow users to group attribute elements in new ways without changing the metadata and warehouse definitions. Copy cleanup. HRESULT : Aggregation ([out, retval] EnumDSSAEAggregation *pAggregation)Follow the steps below to create a list of all groups and the users in each group: In MicroStrategy Developer 9. Created different types of objects such as attributes, metrics, filters, prompts, Custom Groups and Consolidation. A sales team might use a business dashboard to connect. Custom Data Markers allow for the flexibility to add more context to your displayed data and personalize it to the business user. Copy the code for the D3 visualization you are using. certificateOn the Graph menu, choose Preferences. A consolidation is a set of attribute elements grouped in a way that they were not originally grouped within the project, so that you can use the consolidation (the newly consolidated elements) just like a regular attribute on a report. Custom groups; A custom group is a special filter that can be placed on a template and. The SQL for a report with a custom group is likely to be very complex. Enter a new name for the custom group element and press ENTER. Get inspiration at the MicroStrategy data visualization gallery. For example, you might group the Month elements into December. The header is an arbitrary name that you define when you create the element. ). Change the formatting of the values to have different colors. The. Create a Report Services Document 2. 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. When a user has additional attributes in the report objects window, the aggregation causes the consolidation to add up the percentages for the results for each attribute instead of dividing the overall numbers. Updated: November 2023. Recommendation. Custom groups are used to apply different filters to different rows of a report. The chart below contains a list of all the object types and object descriptions occurring in MicroStrategy metadata: Never used, and all functions should check that zero (0) never pass for a type. The following auto text codes allow you to add document variable information to your document. Open the Workstation window. It includes built-in geocoding that auto maps executive locations. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . Number of offices 3. Now your connection f. 3. Click Certify. Enter a description for the custom group in the Enter Custom Group Description Here field. 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. This knowledge base article explains an feature enhancement when using Consolidation or custom group. Your separator may vary depending on your number and date format locale. Architects can create custom-based transformations to provide details for time periods such as Last Year, Month, Date, and others. There are three types of objects: schema objects, application objects, and configuration objects. This object is based on another familiar one: the Filter. This is a single-value function. Consolidations enable users to create customized. Comprehensive analytical capabilities and Automated reporting: MicroStrategy offers wide range of analytical features including data visualizations, advance analytics, data discovery and predictive modeling. For example, the following image shows two facts with an Item/Day/Call Center level. Consolidation elements are attribute elements that define the consolidation. 1. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformCommunity & Support Search Discussions Open A Case View My CasesHyperIntelligence and its Architecture. Consolidations are used to create virtual attributes to allow reporting on attributes that do not exist in the data model. Custom Visualizations: Users can create or import custom visuals to make their reports more tailored and effective. x, select 'Project Documentation' from the Tools menu to. 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. Note: If a user enters more than 15 digits for a. The MicroStrategy Tutorial project uses aggregate tables by default. Derived metric based on attribute values Here is how could create and display data correctly on using below simple steps. The connection is automatically renewed, or reconnected if server’s session associated with the connection expires due to inactivity. Microstrategy Dossiers With the release of MicroStrategy 10. Result for new metric is blank. The following is a quick reference table for a MicroStrategy Custom Group: A Custom. To open a document in Editable Mode, from a folder, right-click the document, point to Run as, and select Editable. Relate tables contain the ID columns of two or more attributes, which will define associations between them. A cross join between datasets can result in rows or Group Header/Footer sections that do not have metric data. Compare all the important BI vendors with our 100% independent Business Intelligence tools comparison. ×Sorry to interrupt. From the File menu, click Open. They can be defined from any of the following: Attribute elements from different levels of the same hierarchy, such as Region and Call Center in the Geography. Being able to run this calculation would be useful for. 1. Enable hierarchical display for the custom group. In the list of categories on the left, click Subtotals. Execute one of the following options: To specify default prompt answers, click on 'Add'. 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,. By default, this executable is located in C:Program FilesMicroStrategyIntegrity Manager. It is expected to not see individual items under the custom group element as the filter qualification for the custom group excludes all data. x. Users can explore, filter, and visualize data with drag-and-drop functionality. MicroStrategy’s mobile support ensures flexible, real-time data exploration. Examples include "Region = Northeast" or "Revenue > $1 million". This calculation can be aggregated from the Employee level to the Region level. To enable totals or subtotals for a metric. For example, the before and after SQL that is generated for a. In the list of categories on the left, click Subtotals. 35K subscribers 2. Click the Options icon . The Custom Group Editor enables you to create and modify custom groups. The essential distinction is that consolidations work with attributes and custom groups use filters. In the Report Data Options Window, Select Calculations > Subtotals. By the way, there is no. To allow sorting on the attribute elements after sorting by the metric total value, users may follow the steps below: Create a level derived metric to calculate on the attribute level at which the subtotal is calculated. A recent survey by Gartner, Inc. The second most common hard skill for a microstrategy developer is bi appearing on 5. Creates a connection object which is used in subsequent requests and manages the user’s connection with the MicroStrategy REST and Intelligence Servers. In this case, only one form exists for each, as shown below: With MicroStrategy, SQL optimization is performed, by default, across passes corresponding to different elements of a Custom group when possible. 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. Tableau is a data visualization tool that helps create appealing charts, reports, and dashboards that are easy to share and interactive. com Twitter: @MicroRoosterFormat: A MicroStrategy Online Training Video blog. Another possible solution in MicroStrategy would be to create logical tables to create an hierarchy like: Dept -> Old Dept -> Sub-Dept -> Old. Enter a description for the custom group in the Enter Custom Group Description Here field. In the Grouping panel, right-click the grouping field to display horizontally, and select Grouping Properties. The Preferences dialog box opens. In MicroStrategy SQL Generation Engine 9. 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. Enable Subtotals and enable a basic total. 3. Case. This type of passthrough can be used to create flexible filters. microstrategy. In MicroStrategy Web, open the document in Design or Editable Mode. MicroStrategy functions are classified into the following types: Single-value functions (also known as Non-grouping or Scalar functions): These functions operate on each individual component of an input variable or argument, resulting in an output element for each component. exe using the command line. In MicroStrategy Web, click the metric for which you want to enable a grand total or subtotals. Development/ Integration system is taken as the source of these consolidation routes. 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. Vitaracharts for Microstrategy offers a variety of customizable data marker options for all charts including grids where there is a wide variety of use cases for this feature. The image below shows how the East Coast group derived element is created in the Derived Elements Editor:We provide industry standard online training on MicroStrategy Development , Administration and live project development with hand-holding support of expert t. The third-party product(s) discussed in this article is manufactured by vendors independent of MicroStrategy. In free-form layout, we provide an intuitive way to let you visually “group” containers together. Filters data related to a business attribute’s form (s), such as ID or description. 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. For example, we create a group that is “East Zone” and generate a list of regions that are in the east zone. '. Custom group expressions: A custom group is an object that can be placed on a template and is made up of a collection of elements called custom group elements. Open the document in Design or Editable Mode. Go to Project Configuration > Database Instances > Connection Mapping as seen below: Click on New to create a new Connection Map and fill in the Criteria for the USA users for their connection mapping, as shown below: Note: When creating a new connection map, the users can choose from the following two types of database instances. Same thing for Sub-Dept 201. 2. Note: Since performance of any query depends on factors outside MicroStrategy's control (especially database tuning and indexing), MicroStrategy cannot guarantee that there will be an improvement in performance using this technique. Consolidations enable users to create customized groupings that allow row calculations between elements of a given attribute. 1 and 10. 1. 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. . MicroStrategy makes no warranty, express, implied or otherwise, regarding this product, including its performance or reliability. To add a derived element to a document, open the document in Editable Mode. blogspot. User specifies the tables to load into memory; Attributes/Metrics are mapped to these tables. Case This function evaluates multiple expressions until a condition is determined to be true, then returns a. 0). For example, a report. The recursive hierarchy table has to be split into several tables, one for each level in the hierarchy. Displaying Top 5 Customers, Top 5 Employees, and Top 5 Items on the same report. For example, setting Metric Join type to "Outer" at the report level (Metric editor > Tool > Metric Join Type) overwrites the Metric Join Type set at the Database Instance Level: The subject of Outer Joins is a very broad one, however, as a. A custom group is made up of an ordered collection of elements called custom group elements. Tableau has unique graphics options to present data in a meaningful manner. 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. Create a report with Attribute "Year", custom group "Category" and Metric Revenue; Click in the Metric Revenue in Report Object and go to Insert Tab;When the custom group element is expanded in the Custom Group Editor, up to three SQL passes must be made for each custom group element. In contrast, consolidations. Ultimately, it was. The properties needed to define a column of a DB table (Columns) Top level object - represents a Castor installation (Castor Server Config. Dataset 2 contains Year and Profit, filtered to return data for only two years (2008 and 2009). Custom groups are used to apply different filters to different rows of a report. Consolidations are groupings of attribute elements while custom groups are based on filter criteria. KB42896: How to grant privileges to a user, user group or security role using MicroStrategy Command. You can only certify dossiers in the Dossiers area of the Navigation pane. A Document Autostyle is a collection of formatting properties saved in a document for various control types (sections, text fields, lines, etc. From the Home menu, point to Subscribe to, and select FTP. Open the custom group editor and drag an object from the object browser to create a custom group. Browse to the folder in which to create the new custom group, then click the Create Custom Group icon. MicroStrategy recommends to have only one child at the lowest level. To apply the same tooltip to every item in the graph, select the Labels and Values category. MicroStrategy recommends that you use event-triggered schedules in situations where it is important to control which node performs certain tasks. Custom Group vs Consolidation; Auto Styles (Report vs Document vs Dossiers) Reports Creation. Get inspiration at the MicroStrategy data visualization gallery. Let me illustrate. 2. For example, the separator is a comma (,) in English and a semicolon (;) in German. The algorithm that calculates the table sizes performs the following steps: Calculate the number of levels per hierarchy: Hierarchy 1: 3. Cards present predefined KPIs associated with a selected keyword sourced securely from MicroStrategy. Overall customer rating 9. Ragged Hierarchies. Adding consolidations and custom groups . An object is a basic building block in MicroStrategy. Microstrategy Dossiers With the release of MicroStrategy 10. Get Started. Query Generation. Group Elements. 1. comArchitects can now do more with MicroStrategy Workstation. Choose the option, Add an Attribute qualification. Loading. Consolidations allow you to qualify a report on a row-by-row basis. Grouping in a metric level determines how the metric aggregates. If the element name is shown, then the sum will be shown. The Create Personal View dialog box opens. exe to this machine. Right click and "Run as Administrator" to. You must have the MicroStrategy Report Services product to view and create documents and RS dashboards. It is made up of an ordered collection of elements referred as custom group elements. Subtotals are totals of selected groups of your metric data, totaled at a level you select. A custom Group allows you to combine unrelated "queries" with each other. Fact table levels: The context of your data. Define the advance sort on the derived. This has been tested to work successfully in a 9. Considerations for the use of star schemas with MicroStrategy SQL Generation. STEPS TO REPRODUCE: Follow the steps below in order to reproduce this issue using the MicroStrategy Tutorial project: 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 certain groupings. An online search reveals that MicroStrategy has less market penetration than Tableau. When running a report in MicroStrategy Web with a custom group on the template, after enabling subtotals to display for the grid, users will notice that no totals display. Select any project that is in the project source that contains the users and groups and click Next. Note that a custom group, 'Age Groups' from the MicroStrategy Tutorial project, is used in the page-by axis. Custom groups allow for unique aggregations of data elements and bands to provide a way for business users to analyze data in groups that do not exist in the original data source. Online Analytical Processing (OLAP) is a multidimensional analysis of business data. Select the Password protect zip file check box and type a password for the zip file. Use that metric in a custom group that bands based on metric value and for each metric value. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. Custom Groups : Custom groups are set of filters and. 9% of resumes. Following are the steps to create a custom group. If an environment does not already exist, an environment will need to be created first. MicroStrategy is a proprietary business intelligence suite based on a ROLAP back-end similar to Cognos or Business Objects. To choose a metric, execute one of the following: In the Metric box, enter in the desired metric name and click OK. Second, create a metric that has the base attribute used in the consolidation as a part of the dimensionality. The different kinds of value prompts are: Date prompt: Users enter a specific date for which to see data. com A 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. com. Group 1: Atlanta, San Diego, Berlin and San Francisco. Yes. Experience in creating dashboards using Microstrategy Involved in validating data returned in all reports, provided a detailed analysis of data, and identified data quality issues. blogspot. By implementing the security policies and configurations provided by MobileIron, administrators can apply enhanced protections to mobile devices in use across the enterprise. Add the Custom Group to Grouping, as shown below: On Call Center Group, right click and select Sort – Inherit attribute sort. Both products' features range. Custom groups are used to apply different filters to different rows. Configuration objects: Configuration objects enable us to connect with warehouse databases using MicroStrategy architecture. September 06, 2018. Depending on the options that you select in the Custom Group Editor, the custom group could appear on the report in MicroStrategy Developer as shown below.