Attribute qualifiers enable you to specify conditions that attribute elements must satisfy to be included in the filter definition. For example, you can create a qualification on the attribute Month so that the result set returns only months beginning with the letter “J.”
Attribute element list qualification
Attribute element list qualifications allow you to qualify on a list of attribute elements. For example, in a report, you can use an attribute element list qualification on the attribute Customer, to return data only for those customers that you specify in your list.
Attribute element list qualification example
This example refers to filters and reports saved in the MicroStrategy Tutorial.The directory path within Desktop is Public Objects Reports Technical Reports Reports by Feature Advanced Reporting Examples.You can follow the steps to interact with the filters and reports, or you can view the samples without creating your own. Remember to save any objects that you create under a different name, so that you do not overwrite the samples in the MicroStrategy Tutorial.
A report includes the revenue, cost, and profit for all employees. However, certain months are not representative of the normal business cycle, so they should be excluded from the report calculations. To do that, create a filter that excludes the months of April, May, and December. This filter is saved as Month in the Supporting Objects subdirectory. For step-by-step directions on creating a filter, see the online help.
Open the Basic Report. Note that Leanne Sawyer’scontribution to revenue is $316,786. Now switch to Design View and add the Month filter. When you re-execute the report, it looks like the following.
If you do not want to create it yourself, this report is saved as Filter - Month Filter in the Tutorial.
Notice that the metrics have different values than in the Basic Report. Sawyer’s contribution to revenue is now $198,976. In the Basic Report, all data for all months was retrieved from the data warehouse. The Revenue metric was calculated using all months. In this filtered report, April, May, and December amounts are not retrieved from the data warehouse, so the metric cannot include them in its calculations.
Attribute form qualification
Attribute form qualifications allow you to qualify on an attribute form. For example, to return data only for those customers whose last names start with the letter H, you can use an attribute form qualification for the form Customer Last Name in a report.
Attribute form qualification example
This example refers to filters and reports saved in the MicroStrategy Tutorial. The directory path within Desktop is Public Objects Reports Technical ReportsReports by Feature Advanced Reporting Examples. You can follow the steps to interact with the filters and reports, or you can view the samples without creating your own. Remember to save any objects you create under a different name, so that you do not overwrite the samples in the MicroStrategy Tutorial.
A report includes the revenue, cost, and profit for all employees. You want to view the data of only those employees whose last name begins with the alphabet ‘B’. To do this, create a filter that qualifies on the Last Name of the attribute Employee. Choose the Operator as Begins With and Value as B. Save this filter. For step-by-step directions on creating a filter, see the online help.
Open the Basic Report. Now switch to Design View and add this filter. When you re-execute the report, it looks like the following.
Notice that the report displays the revenue of only those employees whose last name begins with the alphabet ‘B’.
When you qualify on a date attribute form with the date data type, you can select dynamic dates, which are fixed offsets of the current date. They can be either a fixed set of dates or different date ranges that change through time. For example, a dynamic date can be used in a report that examines sales in the previous two months. This would be represented as "today" with an offset of two months. You can express Dynamic date qualifications in several ways, as shown in the following examples:
While evaluating a dynamic date such as “first of this month minus seven days,” the order in which these two parts are calculated is significant. The addition or subtraction of days, weeks, months, or years is always done first, before “first of this month,” “this week,” “this year,” and so on is calculated.For example:
You can import filter elements into the Filter Editor from sources other than MicroStrategy, if you choose the attribute qualifying operator as In list or Not in list. To import elements into a filter, the elements should be stored in an Excel file or a text file.
The import filter elements option adds more flexibility to the Filter Editor by allowing lists of data from pre-existing files to be imported into the filter definition. Existing filter definitions can also be exported to a file.
You can use a prompt to allow you to select the file to import when you run the report.
Importing elements from a text file or a Microsoft Excel file can be quicker and more efficient than selecting each individual element to be included in the filter. For example,you have an Excel spreadsheet that lists the products on sale this month. You need to review last week's revenue for just these items. Rather than selecting them in the Filter Editor,you can simply import the file. Likewise, you can export existing filter definitions to a file.
The following rules apply to the formatting of files:
Excel-Data can be stored in rows, columns, or both.
Text-Data in a text file must be one of the following:
Attribute-to-attribute qualifications allow you to create reports that compare two attributes through attribute forms. For example, using attribute-to-attribute qualifications, by comparing order date with ship date, you can create a report that displays the orders that were shipped within a week of their order date.
Attribute-to-attribute qualification example
This example refers to information found in the MicroStrategy Tutorial.
An attribute-to-attribute qualification can be used to create areport that lists orders that were shipped more than 27 days after the order date. Start a new report with Order, Day, Ship Date, Revenue, Cost, and Profit. To limit the amount of data considered for the report, add a filter for December 2003. Finally, create the attribute-to-attribute qualification as outlined below.
To create an attribute-to-attribute qualification
This adds 27 days to the Day attribute, which is the order date. The Ship Date is compared to this value.
Execute the report, which displays as shown below.
This report is saved as Attribute to Attribute Comparison.
The first order, Order 39025, was ordered on 12/31/2002 and shipped on 1/28/2003. That is a difference of 28 days.
Attribute Qualification Prompt
An attribute qualification prompt allows you to qualify on the values of attribute elements, attribute forms, or operators when you run a report. You can create the following types of attribute qualification prompts:
Microstrategy Related Interview Questions
|Informatica Interview Questions||IBM Cognos Interview Questions|
|Teradata Interview Questions||Adv Java Interview Questions|
|Cloud Computing Interview Questions||SQL Database Interview Questions|
|OBIEE Interview Questions||Qlik View Interview Questions|
|Tableau Interview Questions||Talend Interview Questions|
|IBM Cognos TM1 Interview Questions||Data modeling Interview Questions|
|Cognos ReportNet (CRN) Interview Questions||Qlik Sense Interview Questions|
Introduction To Advanced Reporting
Creating Freeform Sql Reports
Creating Olap Cube Reports
Data Mining Services
Custom Groups And Consolidations
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.