You can format metrics to control how they are displayed on reports, that is, to specify the format for a particular metric, regardless of the report the metric is on. This formatting, which can be applied to headers and data values, is performed in the Metric Editor or through a find and replace operation. Metric level formatting is overwritten by axis and all metrics formatting, which occurs on the report level. Those formatting layers must be set to default to allow the metric level formatting to display.
The following tables contain format-related specifics for
Report-formatting options described in this section are available in the Metric Editor, the Report Editor/Viewer, and the Find and Replace dialog box. To access these options in the Metric Editor, select Tools, then Formatting. In the Report Editor/Viewer, it is available from the Format menu. To open the Find and Replace dialog box, log in to a project with administrative or desktop designer privileges and select Tools, then Find and Replace...
You can use this information to determine how the built-in formats will display data or to create custom number formatting if the built-in styles do not meet your needs.
Number display codes
Formatting codes are used to select formats for data values of metrics in a grid report. The table that follows shows format codes for the various types of available value displays, specifying differences between positive, negative, and decimal values.
Symbols and their functions
The following table shows the symbols used for display formatting and the function associated with each.
Available colors for metric formatting include
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.