Business Object - Combined Query
5 stars based on
Before you create a report, you need to gather information from your user community, your project designer, your database administrator, and your MicroStrategy software.
Some best practices are described here. Ask yourself who the audience is for the report you plan to create. Questions you should have answers to include:. Your universe of users may include different security requirements. For example, you may need a why combined query in business objects report for a group of users, but that group includes both external and internal users, and you want to restrict some data from external view. Object-level security is performed using ACLs, or access control lists.
Security filters and ACLs are generally implemented by your system administrator, but one or both may be under the control of your project designer. If you need an introduction to or refresher on data sources, review Understanding your data sources. Make sure the data your organization stores can support the information your users want to analyze why combined query in business objects a reporting environment.
Questions you should ask include:. If the numbers you see in the report do not come close to what you expected to see, it is worthwhile to spend some time with your database administrator to address the reliability of the data stored in your data source.
In this way, you can choose objects to use on reports with full knowledge of the data source tables that data is coming from when the report is executed. For details why combined query in business objects general project design and data modeling, see the Project Design Guide.
Quick reports can be useful to test out a basic report design concept for a more complex report, as described in Locate or why combined query in business objects time-savers. Before you spend time creating, formatting, and fine-tuning a complex report, you can create a basic report quickly and ask users to provide feedback on its general usefulness in answering their business queries.
Once you feel confident that your basic report design includes the appropriate objects, you can move on to create any additional objects necessary and to create the more complex, final report. While Report Builder itself provides limited access to certain objects and functionality during report creation, when you are finished with Report Builder, it opens your new report in Design Mode if you have design privileges.
In Design Mode you can add, edit, or remove objects freely, and you can provide additional functionality for users who will later execute the report to perform data analysis. To create a report quickly using Report Builder, see Creating a report for analysis.
To create objects, see Creating and saving objects. To create a report from scratch, see Creating a grid report. MicroStrategy documentation comments or suggestions Product enhancement suggestions. Thresholds Formatting null values and blank cells Renaming row and column headers Hiding and re-displaying a metric column Resizing a column or row: Column handles and Fixed Column Width mode Formatting groups of report rows or columns: Banding Keeping row and column names visible: Locking headers Formatting report borders Formatting a combined grid and graph report Formatting a graph report Viewing a graph report Understanding a graph report Choosing a graph style Changing the color scheme of a graph Defining a graph color for metrics Formatting conditional data on a graph: Thresholds Undoing and redoing graph formatting Moving and resizing graph objects Formatting numeric data in a report Preset formatting: Report limits Calculating data Determining how metric data is combined: Personal answers Saving reports with prompts Building a Quick Query for Analysis Creating a report by combining a template and a filter: Report Wizard Quick report creation: Building a new report Creating a report for analysis Building Query Objects and Queries, for Designers Before you begin Report designer role Developing a business query and report design: Creating shortcuts to objects Providing business context to a report: Attributes Calculating data on a report: Metrics Why combined query in business objects and working with metrics: The Function Editor Providing business context: Calculating metric levels Components of a metric Metrics made up of metrics: Filters Creating or editing filters: The Filter Editor Types of filters Filtering data based on business attributes: Attribute qualifications Filtering data based on attribute relationships or metrics: Set qualifications Filtering data based on existing filters or report results: Prompts Components of a prompt Creating a prompt Why combined query in business objects of prompts Filtering data on an attribute, attribute form, attribute element, or metric Filtering data based on metrics, attributes, or other objects: Object prompts Filtering data based on a single value or string: Adding attributes to a report Reports: Adding metrics to a report Reports: Adding a filter to a report Reports: Adding prompts to a report, metric, or filter Saving a report Example for creating a new report Adding features for users Formatting for easier data analysis Letting users choose their own report filter Adding usability to a Report Services document Confirming your choice of graph style Enabling drilling and customizing drill maps Including totals and subtotals Including sorted data Hierarchical display why combined query in business objects grouped attribute elements Grouping data by page: Adding objects to the page-by why combined query in business objects in a report Adding consolidations and custom groups Specifying maximum and minimum values: Do objects exist in the MicroStrategy metadata which match what users want to see on reports?
If not, you or another report designer can create them.