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 >. Labels: #Creat transaction services photo uploader #transaction. Right-click the header of the attribute whose elements you want to use to. Fu nction Types. 3 and later) Supports exporting to PDF (10. 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. The Item_id, Day_id, and Call_Ctr_id columns in the table above represent practical levels at which sales. Get Started. . This calculation can be aggregated from the Employee level to the Region level. Autostyles can be either saved based on an existing document or they can. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Enterprise Analytics Business Intelligence; HyperIntelligence; Cloud; Product Innovation; Education; Consulting HyperIntelligence and its Architecture. g. When creating or editing a custom group in MicroStrategy Developer 9. In the Report Data Options Window, Select Calculations > Subtotals. Derived elements are available only from MicroStrategy web. Business consolidation is used to improve operational efficiency by. Click Certify. 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. 35K subscribers 2. Choose the option, Add an Attribute qualification. Consolidations are used to group the attributes without disturbing the schema and it can group attributes based on the elements. Click New Custom Group Element. Content Groups are MicroStrategy objects that can be migrated between environments. 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. To choose a metric, execute one of the following: In the Metric box, enter in the desired metric name and click OK. | Meet MicroStrategy AI on the road. We need to establish a consolidation route for each transport layer. A Group derived element is a combination of attribute elements into a single derived element. Display the hierarchical view in the report (MicroStrategy Developer only) These tasks are completed at different levels and in different MicroStrategy. Custom Data Markers allow for the flexibility to add more context to your displayed data and personalize it to the business user. In MicroStrategy Workstation, right click on any cube created via Data Import and select Properties. Here are the series of steps to setup report objects in which metrics and subtotals so only the subtotal field will contain the RunningSum and the regular metric values will be standard sum values. The Custom Group content should be similar to: 2) Create a RunningSum metric over the regular Revenue metric:1. Application objects: Application objects include filters, prompt, documents, templates, reports, custom groups, and. It is a worthwhile technique. 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. Consolidations enable you to group together and to pick specific attribute elements. The following options are available: Ø Transaction Mapping options. To decide for yourself whether you should or should not use custom group, you must first understand the SQL executed by Microstrategy when you create a custom group. MicroStrategy Desktop will then return data ordered by DESC ascending as follows for that report: From Desktop, create a new document and select the report that you just created as dataset. None, which excludes the attribute in the target from the GROUP BY clause in the SQL statement. Right-click on an existing environment and choose Properties. Visit the data visualization and data dashboard galleries for inspiration. Ultimately, it was. Video Tutorials. MSTR Secure Enterprise. Case This function evaluates multiple expressions until a condition is determined to be true, then returns a. The Report Pre Statement settings insert custom SQL statements at the beginning of the report SQL. In MicroStrategy Web, click the metric for which you want to enable a grand total or subtotals. 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. 3. Passes that hit the same fact table across different elements of a custom group are merged provided that they satisfy certain conditions. That is, we will not be able to create these elements using the. Relationship tables in Microstrategy. The. utils. Enter a name for the custom group in the Enter Custom Group Name Here field. We will explore two objects that serve this purpose: Custom Groups and Consolidations. ). ApplySimple() Accepts facts, attributes, and metrics as input. MicroStrategy is a data visualization tool. To control the display of which Custom Group elements display sums, right click on the Custom Group element, and select "Show Display Options". What are custom groups? Custom Group or Consolidation? - MicroStrategy James Oliver 10. Updated: November 2023. This function evaluates multiple expressions until a condition is determined to be true, then returns a corresponding value. Property indicates whether the aggregation over the consolidation is allowed for the consolidation on the template unit Property indicates whether the aggregation over the consolidation is allowed for the consolidation on the template unit. In the Microstrategy Developer go to Tools -> Preferences(Not my prefernces :)) Under Developer category -> select Browsing on the browsing tab you see all the options like below: 3. Type the following for the name: "Total for the #P #0". KB4377. MicroStrategy makes no warranty, express, implied or otherwise, regarding this product, including its performance or reliability. From the perspective of the report design process, a custom group is an object that can be placed on a template. The tooltip will show the dataset type listed as a Super Cube. Custom groups enable users to view specific elements based on a metric or specification. cache; com. Group 1: Atlanta, San Diego, Berlin and San Francisco. template, consolidation, and custom group objects in an Enterprise Data Warehouse team environment. Number of consultants & teachers ___. When this report is executed, only two custom group elements are displayed even though five elements are defined in the custom group. Below are the recommended best practices when scheduling jobs and administrative tasks in MSTR: Executing simultaneous reports can strain system resources. Consolidations are used to group the attributes without disturbing the schema and it can group attributes based on the elements. Description: A training video demonstrating how to create, use and forma. Passes that hit the same fact table across different elements of a custom group are merged provided that they satisfy certain conditions. To Modify Permissions for an Object in MicroStrategy Web. The following table summarizes the similarities and differences between consolidations and custom groups. bandings on Attributes or Metrics to group the. Drag an attribute from the Datasets panel to the Rows area of the Editor panel to add attributes to the rows. One common way to do this is to compare the date information you have stored to the current date. 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. Enable Subtotals and enable a basic total. The Document Properties dialog box opens. The data for the Lookup_Region table came from a different source system than the data for the Lookup_Call_Ctr and the source systems have different naming conventions. You'll find everything from waterfall charts to word clouds in our community. Consolidations: Grouping Attribute Elements with Arithmetic and Logical Operators. The maximum file size of dashboard (. Ans: MicroStrategy enables ad hoc analysis through an intuitive interface. Without data, the dashboard will not show the user anything. The following schema shows which setting takes precedence when set at different levels. See below: Notice in Developer, you can currently right click on this document and select the 'Edit' option. A custom group element is a logical expression of qualifications. SASE and XDR are opportunities for consolidation: 41. x and 10. 4. x, there is no way to duplicate a custom group element. community. These auto text codes are automatically replaced by information about the document. Add a condition to a custom group element. custom groups. Execute one of the following options: To specify default prompt answers, click on 'Add'. 2. A derived element allows us to group on the basis of: – List of elements. 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. 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. From the Visualizations panel, select Grid . 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. x. 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. The report-related objects placed on the template, such as. If the report definition of a report with multiple custom groups is fairly complex, with many metrics and filtering criteria, the resulting complexity and size of the. 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. Create a new consolidation with three elements - Winter, Spring and Winter + Spring, as illustrated below: Create a report with the above created consolidation and three metrics -. 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. 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,. We will explore two objects that serve this purpose: Custom Groups and Consolidations. Dataset 2 contains Year and Profit, filtered to return data for only two years (2008 and 2009). 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. 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. Cross-tab: Pivot and display sorting and page-by Each of the engines plays an important part in the report execution process. 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. Source: MicroRooster. But it’s nipping at the heels of leading BI. It enables you to group attribute elements in new ways without altering the metadata and warehouse. 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. {&GROUPLABEL} Name of the graph item's category. 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. For example, we create a group that is “East Zone” and generate a list of regions that are in the east zone. new_customgroup_name is the new name of the custom group, of type string, between double quotes ("). For example, we create a group that is “East Zone” and generate a list of regions that are in the east zone. Each element contains a set of filtering or banding qualifications. A recent survey by Gartner, Inc. Cards present predefined KPIs associated with a selected keyword sourced securely from MicroStrategy. The different kinds of value prompts are: Date prompt: Users enter a specific date for which to see data. Learn more. A custom group lets you group attribute elements from the same or different attributes to meet your reporting requirements. 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. Visit the data visualization and data dashboard galleries for inspiration. Recommendation. 0). . You can consider custom groups as many different reports "stacked up" together. In MicroStrategy Web, open the document in Design or Editable Mode. Open up the same document in MicroStrategy Web 10. TYPE: Custom Group. The Compound Grid is a new visualization introduced in the MicroStrategy 2020 release. 1) Create Metric 1 which is the sum of the fact that is to be in the columns. 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. Custom Group Effects on SQL Generation. a) Attribute form qualification. The connection is automatically renewed, or reconnected if server’s session associated with the connection expires due to inactivity. MicroStrategy Advanced Reporting Guide provides comprehensive information on advanced topics for using the MicroStrategy query and reporting products. For example, the before and after SQL that is generated for a. If the quarter attribute is removed from the template, all custom group elements are displayed, with empty metric values for the custom group elements that lie outside of the report filter. A consolidation element expression defines how the attribute elements are calculated. 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. Step 1. 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. 1K views 5 years ago MicroStrategy. MicroStrategy - Real Time Consolidations & Custom Groupings - Online Training Video by MicroRooster MicroRooster 6. The syntax is: FileLocation is the path to the saved test file. 9K views 4 years ago MicroStrategy In this video I will discuss when you should use a. Viewed 13k times. 4. Click the Options icon . 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. This feature is similar to what we see in web pages. 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. Step 3. Consolidations: Virtual attributes. Follow the steps below for an example of how to do this. After you find the microstrategy. '. Dynamic Custom Group in Dashboards or Dossiers. CSS ErrorAnswer You can always convert a consolidation to a custom group, but you can only convert a custom group to a consolidation when the custom group filters are from the same table or very similar tables. An object is a basic building block in MicroStrategy. In MicroStrategy Web, click the metric for which you want to enable a grand total or subtotals. DAY_DESC. Tableau can map latitude and longitude coordinates and link them to spatial data. Grouping in a metric level determines how the metric aggregates. Starting in MicroStrategy 2021 Update 1, there is an new out-of-the-box, feature-rich. 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. For example, ApplySimple ("#0 * #1", [col1], [col2]) indicates that two items, col1 and col2, referenced. Source: MicroRooster. The Code Editor tab should be open. The grouping options for levels include: Standard, which groups by the attribute level of the target. Explanation. In the list of categories on the left, click Subtotals. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. 1. zip file below and deploy it in the environments where you want to use it - MicroStrategy Desktop, Workstation, Web, or Mobile. They can create custom calculations, prompt for inputs, and easily share findings. Homogeneous mapping: For consistency, it is a good idea for columns that contain the same data to. exe using the command line. Moving the CG/Consolidation to the left as a first column may fix the problem. This is a list of the available auto text macros that the Report Services Document engine recognizes. The index for referencing these objects begins with 0 and increases by. You can even import consolidation elements from other consolidations in the project to create consolidation elements. From the File menu, click Open. Syntax. The header is an arbitrary name that you define when you create the element. Consolidations and custom groups can support, because another sql statement may be created and retrieve the correct results from base tables. Consolidations vs Custom Groups. 1. Schema objects include facts, hierarchies, and custom groups; application objects include reports, documents, and metrics; and configuration objects include project sources, database instances. By default, this executable is located in C:Program FilesMicroStrategyIntegrity Manager. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. Development/ Integration system is taken as the source of these consolidation routes. With pass-through functions, you can create custom expressions to define attributes, metrics and filters. 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. To Create a Custom Group. 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. Change the band names to Top Performers, Average Performers, and Under-Performers. Qualifications are the actual conditions that must be met for data to be included in the custom group element. 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. 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. If a user enters more than 15 digits for a. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. 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. Find an event in a city near you. Custom groups enable users to view specific elements based on a metric or specification. This prompt is used in a filter. Login to MSTR Developer then go to: User Manager > User Definition > Project Access. Watch this on-demand webinar to learn why MicroStrategy Workstation is such a valuable tool and how you can leverage it as a one-stop shop for operating and administering your MicroStrategy ecosystem. simply a grouping of attribute elements is called Consolidation. Create a consolidation with Region grouping 1-2 different attribute elements. II. This approach makes it easier for you to specify a flexible partitioning. Consolidation with diff groups of cities as regions. . Supports custom properties (10. It is expected to not see individual items under the custom group element as the filter qualification for the custom group excludes all data. Connection mapping allows administrators to assign a user or group in the MicroStrategy system to a specific login ID on the data warehouse. The Custom Group Editor appears. 3. The Metric Editor opens in either Function Editor mode or Formula Editor mode, depending on the type of metric you chose to edit. x, select 'Project Documentation' from the Tools menu to start the wizard. The “ #n” code in Apply function syntax serves as placeholders for the MicroStrategy objects being passed to your database. Run the document on iPad, as shown below: 12. 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. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. 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. 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. The essential distinction is that consolidations work with attributes and custom groups use filters. The SQL for a report with a custom group is likely to be very complex. Under Elements for this consolidation, right-click and select Add Element. 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. The designed behavior is explained using an example consolidation and compound metric based on objects in the MicroStrategy Tutorial project. Credits; About the Authors. By implementing the security policies and configurations provided by MobileIron, administrators can apply enhanced protections to mobile devices in use across the enterprise. 1. 3. This allows you to group attribute elements on a report in a way that is not defined in your data warehouse. Tableau is a data visualization tool that helps create appealing charts, reports, and dashboards that are easy to share and interactive. To open a document in Editable Mode, from a folder, right-click the document, point to Run as, and select Editable. 3. Each element contains a set of filtering or banding qualifications. The. Open the report’s subscriptions in MicroStrategy Web: Scroll down to the Email subscription and click the option to “Add email subscription”: Choose the schedule by clicking the drop-down and selecting the required schedule. A new custom group element is created, with the default name Custom Group Element1. To resolve this issue, perform the following steps: Right-click on the Project in MicroStrategy Desktop and go to Project Configuration. User specifies the tables to load into memory; Attributes/Metrics are mapped to these tables. KB13530: Feature in MicroStrategy SQL Generation Engine: Set Operator Optimization . 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. Select only Configuration Objects for documentation. 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 to create a consolidation in MicroStrategy. Click "Add Photo" and select photos to upload. 4. Subtotals. An online search reveals that MicroStrategy has less market penetration than Tableau. {&GROUPLABEL} Name of the graph. Relate tables store information about the relationship between two attributes when one a parent of the other or vice-versa. A badge icon appears on the item to indicate that it is certified. From the left, click Document. MicroStrategy has partnered with MobileIron to add an extra layer of security to MicroStrategy Mobile applications running on iOS devices. Consolidations are groupings of attribute elements while custom groups are based on filter criteria. Normally, users would accomplish this with an attribute by setting it to the level of that attribute, however that may not produce desirable values. And leverage the Page-By function to focus your analysis on one element. Autostyles based on one document can be applied to another document in order to change its formatting or appearance. (For a definition and examples of levels of aggregation, see How data is aggregated on a report: metric level . Qualifications are the actual conditions that must be met for data to be included in the custom group element. Microstrategy removing rows with Zero metric values If there are more than one metric and want to remove the rows with Zero metric values. 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. This article will help you learn to use these elements to create more powerful and unique grids. On the toolbar, click Add Element. Your personal view subscription is saved, and you are returned to the report, document, or quick dashboard. Unique Features. Create a new custom subtotal, as shown below: This will generate a report with the sum of all the 'End on hand' across subcategory, as shown below: To hide the auxiliary metric, in the grid options menu from the Columns and Rows tab, change the selection to fixed, as shown below:MicroStrategy Features . if both conditions are met, then Red, else Green. 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. Experience. 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. For example, the report below contains Region, Category, and Profit. community. When using a Custom Group or Consolidation as a selector, the option Apply selections as a filter is grayed out under the selector properties in MicroStrategy 9. This report is made up of custom group elements that consist of a header a. In the Grouping panel, right-click the grouping field to display horizontally, and select Grouping Properties. In MicroStrategy Web, open the document in Design or Editable Mode. Click Add New Element to create a new consolidation element. )Right-click the custom group, then select Edit. Select the environment and project where you want to create your consolidation. ApplyComparison. Execute the report. 3. Comprehensive analytical capabilities and Automated reporting: MicroStrategy offers wide range of analytical features including data visualizations, advance analytics, data discovery and predictive modeling. x. Enable hierarchical display for the custom group. In the list of categories on the left, click Subtotals. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. Click the arrow to the left of a custom group element to expand it. Description: MicroStrategy lets you create consoli. This is a single-value function. I have a bunch of table that looks like this: Fact table 1. A connection map in MicroStrategy is a link between a MicroStrategy user, a database connection, and a database login. To begin, the architecture for dashboard execution is. Say you have product group A, product group B, product group A+B. Dataset 1 contains Year and Revenue, with data for three years (2007-2009). Choose File > New Consolidation. You can only certify dossiers in the Dossiers area of the Navigation pane. Custom Group and Consolidation Comparison summarizes the differences between these objects. Number of offices 3. This article might want you to upgrade faster to the newest version and enjoy all of the enhancements in creating your stories!. By implementing the security policies and configurations provided by MobileIron, administrators can apply enhanced protections to mobile devices in use across the enterprise. Overall customer rating 9. Group Elements. This consolidation will contain four consolidation elements, one for each season. Details of Document Execution Request, introduce the Performance Troubleshooting Cycle, and present links to other resources with detailed steps for troubleshooting specific components that may affect performance. In addition, this release introduces new features across the analytics, mobility, and security platforms—making it easier for users to build applications faster. Designed Prompts and Filters to generate reports in grid and graph mode. One element will show the top ten customers and another element will show all customers. Depending on your MicroStrategy product and licensing, this function may not be available. Prompt-in-prompt is a feature in which the answer to one prompt is used to define another prompt. 5-7 Years. Consolidations are used to define the data you want to view in your report. 3. $50,000 per year [includes deployment, hosting, maintenance, and 80 hours of custom course creation]As shown in the table in Custom Group Structure on Reports, you can enable custom group subtotals at the report or custom group level in Developer, as described below: The report level is governed by the Report Data Options, which allow you to disable or enable subtotals for each custom group on a particular report. Then, for mobile devices, our Responsive View will take over the layout and place groups. Define the advance sort on the derived. Right click and "Run as Administrator" to. 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. You can use DateDiff to create a metric or attribute form that lists the length of time between two dates. For example, the report below contains Region, Category, and Profit. For example, the before and after SQL that is generated for a. This option is only available for alerts sent to email addresses. Case. 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. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. STEPS TO REPRODUCE: Create a document in MicroStrategy Developer or Web 10. Define conditions to use to filter data by selecting an attribute, metric, report, or filter, then specifying the appropriate options. The Custom Group Editor enables you to create and modify custom groups. Enter a new name for the custom group element and press ENTER. Tableau has unique graphics options to present data in a meaningful manner. Consolidations enable users to create. The report execution process is a three-step process: 1. From the Home menu, point to Subscribe to, and select FTP. Ø Local Transaction options. The following window appears on completing the above step. Let me illustrate. 16. A custom group is used to group attribute elements and aggregate results in a report. 5. When the report is executed and the prompt resolution occurs, the display contains the. In this example, you need to break down the territories as follows: East = Mid-Atlantic, Northeast, Southeast. Online Analytical Processing (OLAP) is a multidimensional analysis of business data. Fact table levels: The context of your data. From the list of available objects, select the objects to be used as default values for the prompt and click on '>' to add them to the list of selected objects. Now using the mouse place the cursor on text box of 10000 which is next to 'Maximum number of monitoring objects displayed per page. Each text string entered in Report Pre Statement 1 through Report Pre Statement 4 is executed separately as a single statement. A custom group lets you group attribute elements from the same or different attributes to meet your reporting requirements. 9K views 4 years ago MicroStrategy In this video I will discuss. x, select 'Project Documentation' from the Tools menu to start the wizard. 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. 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. It is derived based on a count against the fact_object_component table. Otherwise, to define tooltips for a single series, select the name of the series. Both tools allow you to plot interactive charts, graphs, and dashboards for comprehensive analysis. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. 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. It uses the concept of Inmemory Business Intelligence. Where:The Profit metric is a simple sum of the Profit fact.