Custom groups are used to apply different filters to different rows of a report. Consolidations, custom groups, and derived elements. A microstrategy object created in microstrategy desktop that represents a connection to the warehouse. Bhasker v microstrategy consultant amerisourcebergen. A user group or group for short is a collection of users. With consolidations, user can group attribute elements to define virtual attributes that enable users to analyze data at levels. The fact that you can add together attribute elements in groups means that you can aggregate data on a report at a level other than one of the.
Groups provide a convenient way to manage a large number of users. Extensive experience in building filters, consolidations, transformations and custom groups, attributes, hierarchy, metrics, schema objects and prompts to generated reports meeting the business. The sql for a report with a custom group is likely to be very complex. Create a virtual attribute to allow reporting on an attribute that does not. A database instance specifies warehouse connection information, such as the data warehouse dsn, login id and password, and other data warehouse specific information. The majority of this course is handson using microstrategy developer and microstrategy web, in. Microstrategy custom groups online training video by microrooster duration. Consolidations are groupings of attribute elements while custom groups are based on filter criteria. Extensively created filters, facts, consolidations, transformations and custom groups using microstrategy desktop to generate reports for the business analysis. In this video i will discuss when you should use a consolidation versus a custom group and why. Custom groups and sql in microstrategy tutorial 20 april. Custom groups in microstrategy tutorial 27 april 2020. Metrics are similar to formulas in spreadsheet software.
The majority of this course is handson using microstrategy developer and microstrategy web, in a cloud environment. Custom groups are used to apply different filters to different. Created customized templates to facilitate the end users to create customized reports by choosing filters, metrics and report attributes. The companys software does analytics on a wide range of data, including sales figures, payroll data, and inventory to help inform the business decisions of business users. With consolidations, user can group attribute elements to define virtual attributes that enable users to analyze data at levels that are not inherently available in the business model. Microstrategy consolidations online training video by. Comparison between consolidations and custom groups. Created microstrategy objects metrics, filters, prompts, templates, consolidations, transformations, and custom groups using microstrategy desktop. Each element contains its own set of filtering or banding qualifications. Consolidation and view evaluation order example in this demonstrates the interaction of a consolidation, subtotals, and the view definition with the evaluation order. The output level of a custom group in this example, store is based on the filtering conditions of the element. Understanding the parts of a document microstrategy. A custom group is a set of special filters that can be placed on a template.
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. Microstrategy advanced interview questions tekslate. Microstrategy olap services online analytical processing olap is a. Microstrategy custom groups online training video by microrooster. Consolidations are groupings of attribute elements while custom groups are based on. What are the differences between consolidations and custom groups in microstrategy 9. Database server software running on a particular machine. Consolidations and custom groups are two special reporting features that enable user to surpass basic reporting functionality. 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. Custom groups can use multiple attributes or even metrics, and do dynamic filters and comparisons without the need for explicit definitions. Consolidations are used to group the attributes without disturbing the schema and it can group attributes based on the elements. Microstrategy reporting suite tutorial custom groups. Each element in the custom group can have a different output level.
Custom groups provide a method to group attribute elements from the same or different attributes to meet your reporting requirements. Worked extensively on complex reporting needs which involved creating like consolidations. Consolidations are used to specify the data that you want to view in your report. Instead of assigning privileges, such as the ability to create reports, to hundreds of users individually, you may assign privileges to a group. A custom group can do everything a consolidation can do, but a consolidation is faster when it can be used. Develop advanced metrics, filters, custom groups, and consolidations for analytical reports. Thanks naren disclaimer this email message and any attachments is confidential and intended only for the use of an individual or entity named.
What are the differences between consolidations and custom. With custom groups, users can create reports that qualify on a rowbyrow basis. Evaluation order in microstrategy tutorial 23 april 2020. Custom group and consolidation comparison in microstrategy.
Microstrategy is a business intelligence software, which offers a wide range of data analytics capabilities. Each of the individual minireports that make up the entire custom group report will have at least one, perhaps more sql passes of its own. Looking for microstrategy interview questions with answers. A consolidation allows you to group together various elements of the region attribute into various territories and place them on your template. This technical note outlines the differences between consolidations and custom groups in microstrategy 9. Custom groups are a type of virtual attributes useful in clubbing many attributes together and presenting them as a single attribute. Multisource option does not with consolidation in reports. With each release of microstrategy, they add more and more improvements to the sql it writes. Microstrategy narrowcast server is a software product which. Used passthrough functions applysimple and applycomp in attributes and filters definitions. Custom group and consolidation comparison microstrategy.
The information in a dataset can include microstrategy objects such as attributes, custom groups, consolidations, and metrics. Adding consolidations and custom groups 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. Microstrategy lets you create consolidations and groupings at run time with the ability to. Consolidations in microstrategy tutorial 22 march 2020. You can also regard custom groups as many different reports just stacked up together.
In the above example of the seasons consolidation, the four different season consolidation elements are made up by adding together the respective months of year that belong to the different seasons. For example, if we want to analyze the sales result for every 4 months instead of every quarter, then we have to create a complex formula. Microstrategy consultant resume profile,ny hire it. How can we use consolidations in microstrategy report. 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. Consolidations are groupings of attribute elements while custom. Develop advanced report objects metrics, filters, derived attributes, custom groups, and consolidations to create complex analytical reports. In contrast, consolidations require that you know exactly which attribute elements to select when creating the consolidation. The essential distinction is that consolidations work with attributes and custom groups use filters. Consolidations are used to create virtual attributes to allow reporting on attributes that.
Heres how custom groups is used in microstrategy developer jobs. Both consolidations and custom groups provide flexibility in reports, but the objects differ in their structure and use. A custom group is made up of an ordered collection of elements called custom group elements. A demo video describing how to create and use microstrategy consolidations, how microstrategy sql. Microstrategy develops and provides business intelligence, cloudbased, and mobile software, services. A user group or group for short is a collection of users andor subgroups. For example, if we want to analyze the sales result for every 4 months instead of every quarter, then we have to create a complex formula to choose these months and apply them in calculations. Microstrategy desktop is a windows clientserver software application that provides integrated monitoring. Evaluation order in, custom groups and consolidations, discusses multiple consolidations on a single report. Microstrategy custom groups online training video by. A custom group element can also use combinations of any of the components listed above.
541 1116 909 1508 1407 1017 1078 1328 662 64 223 417 955 627 1253 614 922 273 605 562 1006 98 1334 415 86 343 269 467 1146 191 932 557 878 112 1476 416 892 1452 1464 943 909 180 1113 962 1068 1383 249