KB15856: How to change the metric formatting properties using the MicroStrategy Intelligence Server 9.x API

Follow the steps in the following Strategy Knowledge Base technical note to create a connection to the Strategy Intelligence Server 9.x and to understand the different parameter properties:
 
KB8824 (KB5600-72X-0912): How to programmatically modify the metric formatting properties in Strategy SDK 9.x
 
Create a metric with the following properties:
 

• Metric Category: Fixed
• Decimal Places: 0
• Thousand Separator: No
• Negative Numbers: -1234

Execute the following commands after having created an instance of the metric to be modified:
 
oMetric.GridFormat.Info.PropertySets("FormattingNumber")("Category").Value = 0
oMetric.GridFormat.Info.PropertySets("FormattingNumber")("DecimalPlaces").Value = 0
oMetric.GridFormat.Info.PropertySets("FormattingNumber")("ThousandSeparator").Value = 0 '-1 Checks the box
oMetric.GridFormat.Info.PropertySets("FormattingNumber")("NegativeNumbers").Value = 1
oMetric.GridFormat.Info.PropertySets("FormattingNumber").Info.Save
oMetric.Info.Save
The above code is mapped as follows:
 

1. oMetric.GridFormat.Info.PropertySets("FormattingNumber")("Category").Value = 0
2. As per the techical note above, category can take the following values:
    
   

   MongoDB 2.4 32-bit Simba MongoDB ODBC Driver 0.04.x SupportedOperating SystemDBMSRecommended ODBC DriverStatusWindows/Linux/Solaris/AIXVertica 7.132-Bit Vertica 7.1.x ODBC DriverCertified Get Started Prepare Data ⟩ Create Cards ⟩ Share Cards ⟩ Administer ⟩ Best Practices ⟩ Authentication ⟩ Authorization ⟩   Encryption ⟩ Web Security ⟩ 0Log all messages (Debug, Info, Warning, Error, Fatal).1Log Info, Warning, Error and Fatal messages.2Log Warning, Error and Fatal messages.3Log Error and Fatal messages4Log Fatal messages onlyany other valueLog as the default value 1Graph TypeSupported in Android?Supported in iOS? Vertical Area YesYes Horizontal Area YesYes Vertical Bar YesYes Horizontal Bar YesYes Vertical Line YesYes Horizontal Line YesYes Pie YesYes Scatter YesYes Polar NoYes Radar NoYes Bubble YesYes HiLo Stock NoYes Histogram NoYes 3D Risers NoYes 3D Floating NoYes 3D Connect Series NoYes 3D Surface NoYes Gauges YesYes Funnel YesYes Pareto YesYes Box Plot NoYes Gantt NoYesGraph Features   3D Scatter NoYes Graph as Selector YesYes Drilling NoiPhone Only Zooming on Graphs NoYes Tooltips  YesYes Graph Animations NoYes Report Graph Integration YesYes Document Graph Integration YesYes Fit to Width Rendering YesYesFixed0Currency1Date2Time3Percent4Fraction5Scientific6Special7Custom8General9	MongoDB 2.4 32-bit Simba MongoDB ODBC Driver 0.04.x SupportedOperating SystemDBMSRecommended ODBC DriverStatusWindows/Linux/Solaris/AIXVertica 7.132-Bit Vertica 7.1.x ODBC DriverCertified Get Started Prepare Data ⟩ Create Cards ⟩ Share Cards ⟩ Administer ⟩ Best Practices ⟩ Authentication ⟩ Authorization ⟩   Encryption ⟩ Web Security ⟩ 0Log all messages (Debug, Info, Warning, Error, Fatal).1Log Info, Warning, Error and Fatal messages.2Log Warning, Error and Fatal messages.3Log Error and Fatal messages4Log Fatal messages onlyany other valueLog as the default value 1Graph TypeSupported in Android?Supported in iOS? Vertical Area YesYes Horizontal Area YesYes Vertical Bar YesYes Horizontal Bar YesYes Vertical Line YesYes Horizontal Line YesYes Pie YesYes Scatter YesYes Polar NoYes Radar NoYes Bubble YesYes HiLo Stock NoYes Histogram NoYes 3D Risers NoYes 3D Floating NoYes 3D Connect Series NoYes 3D Surface NoYes Gauges YesYes Funnel YesYes Pareto YesYes Box Plot NoYes Gantt NoYesGraph Features   3D Scatter NoYes Graph as Selector YesYes Drilling NoiPhone Only Zooming on Graphs NoYes Tooltips  YesYes Graph Animations NoYes Report Graph Integration YesYes Document Graph Integration YesYes Fit to Width Rendering YesYesFixed0Currency1Date2Time3Percent4Fraction5Scientific6Special7Custom8General9
   MongoDB 2.4 32-bit Simba MongoDB ODBC Driver 0.04.x SupportedOperating SystemDBMSRecommended ODBC DriverStatusWindows/Linux/Solaris/AIXVertica 7.132-Bit Vertica 7.1.x ODBC DriverCertified Get Started Prepare Data ⟩ Create Cards ⟩ Share Cards ⟩ Administer ⟩ Best Practices ⟩ Authentication ⟩ Authorization ⟩   Encryption ⟩ Web Security ⟩ 0Log all messages (Debug, Info, Warning, Error, Fatal).1Log Info, Warning, Error and Fatal messages.2Log Warning, Error and Fatal messages.3Log Error and Fatal messages4Log Fatal messages onlyany other valueLog as the default value 1Graph TypeSupported in Android?Supported in iOS? Vertical Area YesYes Horizontal Area YesYes Vertical Bar YesYes Horizontal Bar YesYes Vertical Line YesYes Horizontal Line YesYes Pie YesYes Scatter YesYes Polar NoYes Radar NoYes Bubble YesYes HiLo Stock NoYes Histogram NoYes 3D Risers NoYes 3D Floating NoYes 3D Connect Series NoYes 3D Surface NoYes Gauges YesYes Funnel YesYes Pareto YesYes Box Plot NoYes Gantt NoYesGraph Features   3D Scatter NoYes Graph as Selector YesYes Drilling NoiPhone Only Zooming on Graphs NoYes Tooltips  YesYes Graph Animations NoYes Report Graph Integration YesYes Document Graph Integration YesYes Fit to Width Rendering YesYesFixed0Currency1Date2Time3Percent4Fraction5Scientific6Special7Custom8General9	MongoDB 2.4 32-bit Simba MongoDB ODBC Driver 0.04.x SupportedOperating SystemDBMSRecommended ODBC DriverStatusWindows/Linux/Solaris/AIXVertica 7.132-Bit Vertica 7.1.x ODBC DriverCertified Get Started Prepare Data ⟩ Create Cards ⟩ Share Cards ⟩ Administer ⟩ Best Practices ⟩ Authentication ⟩ Authorization ⟩   Encryption ⟩ Web Security ⟩ 0Log all messages (Debug, Info, Warning, Error, Fatal).1Log Info, Warning, Error and Fatal messages.2Log Warning, Error and Fatal messages.3Log Error and Fatal messages4Log Fatal messages onlyany other valueLog as the default value 1Graph TypeSupported in Android?Supported in iOS? Vertical Area YesYes Horizontal Area YesYes Vertical Bar YesYes Horizontal Bar YesYes Vertical Line YesYes Horizontal Line YesYes Pie YesYes Scatter YesYes Polar NoYes Radar NoYes Bubble YesYes HiLo Stock NoYes Histogram NoYes 3D Risers NoYes 3D Floating NoYes 3D Connect Series NoYes 3D Surface NoYes Gauges YesYes Funnel YesYes Pareto YesYes Box Plot NoYes Gantt NoYesGraph Features   3D Scatter NoYes Graph as Selector YesYes Drilling NoiPhone Only Zooming on Graphs NoYes Tooltips  YesYes Graph Animations NoYes Report Graph Integration YesYes Document Graph Integration YesYes Fit to Width Rendering YesYesFixed0Currency1Date2Time3Percent4Fraction5Scientific6Special7Custom8General9
   MongoDB 2.4 32-bit Simba MongoDB ODBC Driver 0.04.x SupportedOperating SystemDBMSRecommended ODBC DriverStatusWindows/Linux/Solaris/AIXVertica 7.132-Bit Vertica 7.1.x ODBC DriverCertified Get Started Prepare Data ⟩ Create Cards ⟩ Share Cards ⟩ Administer ⟩ Best Practices ⟩ Authentication ⟩ Authorization ⟩   Encryption ⟩ Web Security ⟩ 0Log all messages (Debug, Info, Warning, Error, Fatal).1Log Info, Warning, Error and Fatal messages.2Log Warning, Error and Fatal messages.3Log Error and Fatal messages4Log Fatal messages onlyany other valueLog as the default value 1Graph TypeSupported in Android?Supported in iOS? Vertical Area YesYes Horizontal Area YesYes Vertical Bar YesYes Horizontal Bar YesYes Vertical Line YesYes Horizontal Line YesYes Pie YesYes Scatter YesYes Polar NoYes Radar NoYes Bubble YesYes HiLo Stock NoYes Histogram NoYes 3D Risers NoYes 3D Floating NoYes 3D Connect Series NoYes 3D Surface NoYes Gauges YesYes Funnel YesYes Pareto YesYes Box Plot NoYes Gantt NoYesGraph Features   3D Scatter NoYes Graph as Selector YesYes Drilling NoiPhone Only Zooming on Graphs NoYes Tooltips  YesYes Graph Animations NoYes Report Graph Integration YesYes Document Graph Integration YesYes Fit to Width Rendering YesYesFixed0Currency1Date2Time3Percent4Fraction5Scientific6Special7Custom8General9	MongoDB 2.4 32-bit Simba MongoDB ODBC Driver 0.04.x SupportedOperating SystemDBMSRecommended ODBC DriverStatusWindows/Linux/Solaris/AIXVertica 7.132-Bit Vertica 7.1.x ODBC DriverCertified Get Started Prepare Data ⟩ Create Cards ⟩ Share Cards ⟩ Administer ⟩ Best Practices ⟩ Authentication ⟩ Authorization ⟩   Encryption ⟩ Web Security ⟩ 0Log all messages (Debug, Info, Warning, Error, Fatal).1Log Info, Warning, Error and Fatal messages.2Log Warning, Error and Fatal messages.3Log Error and Fatal messages4Log Fatal messages onlyany other valueLog as the default value 1Graph TypeSupported in Android?Supported in iOS? Vertical Area YesYes Horizontal Area YesYes Vertical Bar YesYes Horizontal Bar YesYes Vertical Line YesYes Horizontal Line YesYes Pie YesYes Scatter YesYes Polar NoYes Radar NoYes Bubble YesYes HiLo Stock NoYes Histogram NoYes 3D Risers NoYes 3D Floating NoYes 3D Connect Series NoYes 3D Surface NoYes Gauges YesYes Funnel YesYes Pareto YesYes Box Plot NoYes Gantt NoYesGraph Features   3D Scatter NoYes Graph as Selector YesYes Drilling NoiPhone Only Zooming on Graphs NoYes Tooltips  YesYes Graph Animations NoYes Report Graph Integration YesYes Document Graph Integration YesYes Fit to Width Rendering YesYesFixed0Currency1Date2Time3Percent4Fraction5Scientific6Special7Custom8General9
   MongoDB 2.4 32-bit Simba MongoDB ODBC Driver 0.04.x SupportedOperating SystemDBMSRecommended ODBC DriverStatusWindows/Linux/Solaris/AIXVertica 7.132-Bit Vertica 7.1.x ODBC DriverCertified Get Started Prepare Data ⟩ Create Cards ⟩ Share Cards ⟩ Administer ⟩ Best Practices ⟩ Authentication ⟩ Authorization ⟩   Encryption ⟩ Web Security ⟩ 0Log all messages (Debug, Info, Warning, Error, Fatal).1Log Info, Warning, Error and Fatal messages.2Log Warning, Error and Fatal messages.3Log Error and Fatal messages4Log Fatal messages onlyany other valueLog as the default value 1Graph TypeSupported in Android?Supported in iOS? Vertical Area YesYes Horizontal Area YesYes Vertical Bar YesYes Horizontal Bar YesYes Vertical Line YesYes Horizontal Line YesYes Pie YesYes Scatter YesYes Polar NoYes Radar NoYes Bubble YesYes HiLo Stock NoYes Histogram NoYes 3D Risers NoYes 3D Floating NoYes 3D Connect Series NoYes 3D Surface NoYes Gauges YesYes Funnel YesYes Pareto YesYes Box Plot NoYes Gantt NoYesGraph Features   3D Scatter NoYes Graph as Selector YesYes Drilling NoiPhone Only Zooming on Graphs NoYes Tooltips  YesYes Graph Animations NoYes Report Graph Integration YesYes Document Graph Integration YesYes Fit to Width Rendering YesYesFixed0Currency1Date2Time3Percent4Fraction5Scientific6Special7Custom8General9	MongoDB 2.4 32-bit Simba MongoDB ODBC Driver 0.04.x SupportedOperating SystemDBMSRecommended ODBC DriverStatusWindows/Linux/Solaris/AIXVertica 7.132-Bit Vertica 7.1.x ODBC DriverCertified Get Started Prepare Data ⟩ Create Cards ⟩ Share Cards ⟩ Administer ⟩ Best Practices ⟩ Authentication ⟩ Authorization ⟩   Encryption ⟩ Web Security ⟩ 0Log all messages (Debug, Info, Warning, Error, Fatal).1Log Info, Warning, Error and Fatal messages.2Log Warning, Error and Fatal messages.3Log Error and Fatal messages4Log Fatal messages onlyany other valueLog as the default value 1Graph TypeSupported in Android?Supported in iOS? Vertical Area YesYes Horizontal Area YesYes Vertical Bar YesYes Horizontal Bar YesYes Vertical Line YesYes Horizontal Line YesYes Pie YesYes Scatter YesYes Polar NoYes Radar NoYes Bubble YesYes HiLo Stock NoYes Histogram NoYes 3D Risers NoYes 3D Floating NoYes 3D Connect Series NoYes 3D Surface NoYes Gauges YesYes Funnel YesYes Pareto YesYes Box Plot NoYes Gantt NoYesGraph Features   3D Scatter NoYes Graph as Selector YesYes Drilling NoiPhone Only Zooming on Graphs NoYes Tooltips  YesYes Graph Animations NoYes Report Graph Integration YesYes Document Graph Integration YesYes Fit to Width Rendering YesYesFixed0Currency1Date2Time3Percent4Fraction5Scientific6Special7Custom8General9
   MongoDB 2.4 32-bit Simba MongoDB ODBC Driver 0.04.x SupportedOperating SystemDBMSRecommended ODBC DriverStatusWindows/Linux/Solaris/AIXVertica 7.132-Bit Vertica 7.1.x ODBC DriverCertified Get Started Prepare Data ⟩ Create Cards ⟩ Share Cards ⟩ Administer ⟩ Best Practices ⟩ Authentication ⟩ Authorization ⟩   Encryption ⟩ Web Security ⟩ 0Log all messages (Debug, Info, Warning, Error, Fatal).1Log Info, Warning, Error and Fatal messages.2Log Warning, Error and Fatal messages.3Log Error and Fatal messages4Log Fatal messages onlyany other valueLog as the default value 1Graph TypeSupported in Android?Supported in iOS? Vertical Area YesYes Horizontal Area YesYes Vertical Bar YesYes Horizontal Bar YesYes Vertical Line YesYes Horizontal Line YesYes Pie YesYes Scatter YesYes Polar NoYes Radar NoYes Bubble YesYes HiLo Stock NoYes Histogram NoYes 3D Risers NoYes 3D Floating NoYes 3D Connect Series NoYes 3D Surface NoYes Gauges YesYes Funnel YesYes Pareto YesYes Box Plot NoYes Gantt NoYesGraph Features   3D Scatter NoYes Graph as Selector YesYes Drilling NoiPhone Only Zooming on Graphs NoYes Tooltips  YesYes Graph Animations NoYes Report Graph Integration YesYes Document Graph Integration YesYes Fit to Width Rendering YesYesFixed0Currency1Date2Time3Percent4Fraction5Scientific6Special7Custom8General9	MongoDB 2.4 32-bit Simba MongoDB ODBC Driver 0.04.x SupportedOperating SystemDBMSRecommended ODBC DriverStatusWindows/Linux/Solaris/AIXVertica 7.132-Bit Vertica 7.1.x ODBC DriverCertified Get Started Prepare Data ⟩ Create Cards ⟩ Share Cards ⟩ Administer ⟩ Best Practices ⟩ Authentication ⟩ Authorization ⟩   Encryption ⟩ Web Security ⟩ 0Log all messages (Debug, Info, Warning, Error, Fatal).1Log Info, Warning, Error and Fatal messages.2Log Warning, Error and Fatal messages.3Log Error and Fatal messages4Log Fatal messages onlyany other valueLog as the default value 1Graph TypeSupported in Android?Supported in iOS? Vertical Area YesYes Horizontal Area YesYes Vertical Bar YesYes Horizontal Bar YesYes Vertical Line YesYes Horizontal Line YesYes Pie YesYes Scatter YesYes Polar NoYes Radar NoYes Bubble YesYes HiLo Stock NoYes Histogram NoYes 3D Risers NoYes 3D Floating NoYes 3D Connect Series NoYes 3D Surface NoYes Gauges YesYes Funnel YesYes Pareto YesYes Box Plot NoYes Gantt NoYesGraph Features   3D Scatter NoYes Graph as Selector YesYes Drilling NoiPhone Only Zooming on Graphs NoYes Tooltips  YesYes Graph Animations NoYes Report Graph Integration YesYes Document Graph Integration YesYes Fit to Width Rendering YesYesFixed0Currency1Date2Time3Percent4Fraction5Scientific6Special7Custom8General9
   MongoDB 2.4 32-bit Simba MongoDB ODBC Driver 0.04.x SupportedOperating SystemDBMSRecommended ODBC DriverStatusWindows/Linux/Solaris/AIXVertica 7.132-Bit Vertica 7.1.x ODBC DriverCertified Get Started Prepare Data ⟩ Create Cards ⟩ Share Cards ⟩ Administer ⟩ Best Practices ⟩ Authentication ⟩ Authorization ⟩   Encryption ⟩ Web Security ⟩ 0Log all messages (Debug, Info, Warning, Error, Fatal).1Log Info, Warning, Error and Fatal messages.2Log Warning, Error and Fatal messages.3Log Error and Fatal messages4Log Fatal messages onlyany other valueLog as the default value 1Graph TypeSupported in Android?Supported in iOS? Vertical Area YesYes Horizontal Area YesYes Vertical Bar YesYes Horizontal Bar YesYes Vertical Line YesYes Horizontal Line YesYes Pie YesYes Scatter YesYes Polar NoYes Radar NoYes Bubble YesYes HiLo Stock NoYes Histogram NoYes 3D Risers NoYes 3D Floating NoYes 3D Connect Series NoYes 3D Surface NoYes Gauges YesYes Funnel YesYes Pareto YesYes Box Plot NoYes Gantt NoYesGraph Features   3D Scatter NoYes Graph as Selector YesYes Drilling NoiPhone Only Zooming on Graphs NoYes Tooltips  YesYes Graph Animations NoYes Report Graph Integration YesYes Document Graph Integration YesYes Fit to Width Rendering YesYesFixed0Currency1Date2Time3Percent4Fraction5Scientific6Special7Custom8General9	MongoDB 2.4 32-bit Simba MongoDB ODBC Driver 0.04.x SupportedOperating SystemDBMSRecommended ODBC DriverStatusWindows/Linux/Solaris/AIXVertica 7.132-Bit Vertica 7.1.x ODBC DriverCertified Get Started Prepare Data ⟩ Create Cards ⟩ Share Cards ⟩ Administer ⟩ Best Practices ⟩ Authentication ⟩ Authorization ⟩   Encryption ⟩ Web Security ⟩ 0Log all messages (Debug, Info, Warning, Error, Fatal).1Log Info, Warning, Error and Fatal messages.2Log Warning, Error and Fatal messages.3Log Error and Fatal messages4Log Fatal messages onlyany other valueLog as the default value 1Graph TypeSupported in Android?Supported in iOS? Vertical Area YesYes Horizontal Area YesYes Vertical Bar YesYes Horizontal Bar YesYes Vertical Line YesYes Horizontal Line YesYes Pie YesYes Scatter YesYes Polar NoYes Radar NoYes Bubble YesYes HiLo Stock NoYes Histogram NoYes 3D Risers NoYes 3D Floating NoYes 3D Connect Series NoYes 3D Surface NoYes Gauges YesYes Funnel YesYes Pareto YesYes Box Plot NoYes Gantt NoYesGraph Features   3D Scatter NoYes Graph as Selector YesYes Drilling NoiPhone Only Zooming on Graphs NoYes Tooltips  YesYes Graph Animations NoYes Report Graph Integration YesYes Document Graph Integration YesYes Fit to Width Rendering YesYesFixed0Currency1Date2Time3Percent4Fraction5Scientific6Special7Custom8General9
   MongoDB 2.4 32-bit Simba MongoDB ODBC Driver 0.04.x SupportedOperating SystemDBMSRecommended ODBC DriverStatusWindows/Linux/Solaris/AIXVertica 7.132-Bit Vertica 7.1.x ODBC DriverCertified Get Started Prepare Data ⟩ Create Cards ⟩ Share Cards ⟩ Administer ⟩ Best Practices ⟩ Authentication ⟩ Authorization ⟩   Encryption ⟩ Web Security ⟩ 0Log all messages (Debug, Info, Warning, Error, Fatal).1Log Info, Warning, Error and Fatal messages.2Log Warning, Error and Fatal messages.3Log Error and Fatal messages4Log Fatal messages onlyany other valueLog as the default value 1Graph TypeSupported in Android?Supported in iOS? Vertical Area YesYes Horizontal Area YesYes Vertical Bar YesYes Horizontal Bar YesYes Vertical Line YesYes Horizontal Line YesYes Pie YesYes Scatter YesYes Polar NoYes Radar NoYes Bubble YesYes HiLo Stock NoYes Histogram NoYes 3D Risers NoYes 3D Floating NoYes 3D Connect Series NoYes 3D Surface NoYes Gauges YesYes Funnel YesYes Pareto YesYes Box Plot NoYes Gantt NoYesGraph Features   3D Scatter NoYes Graph as Selector YesYes Drilling NoiPhone Only Zooming on Graphs NoYes Tooltips  YesYes Graph Animations NoYes Report Graph Integration YesYes Document Graph Integration YesYes Fit to Width Rendering YesYesFixed0Currency1Date2Time3Percent4Fraction5Scientific6Special7Custom8General9	MongoDB 2.4 32-bit Simba MongoDB ODBC Driver 0.04.x SupportedOperating SystemDBMSRecommended ODBC DriverStatusWindows/Linux/Solaris/AIXVertica 7.132-Bit Vertica 7.1.x ODBC DriverCertified Get Started Prepare Data ⟩ Create Cards ⟩ Share Cards ⟩ Administer ⟩ Best Practices ⟩ Authentication ⟩ Authorization ⟩   Encryption ⟩ Web Security ⟩ 0Log all messages (Debug, Info, Warning, Error, Fatal).1Log Info, Warning, Error and Fatal messages.2Log Warning, Error and Fatal messages.3Log Error and Fatal messages4Log Fatal messages onlyany other valueLog as the default value 1Graph TypeSupported in Android?Supported in iOS? Vertical Area YesYes Horizontal Area YesYes Vertical Bar YesYes Horizontal Bar YesYes Vertical Line YesYes Horizontal Line YesYes Pie YesYes Scatter YesYes Polar NoYes Radar NoYes Bubble YesYes HiLo Stock NoYes Histogram NoYes 3D Risers NoYes 3D Floating NoYes 3D Connect Series NoYes 3D Surface NoYes Gauges YesYes Funnel YesYes Pareto YesYes Box Plot NoYes Gantt NoYesGraph Features   3D Scatter NoYes Graph as Selector YesYes Drilling NoiPhone Only Zooming on Graphs NoYes Tooltips  YesYes Graph Animations NoYes Report Graph Integration YesYes Document Graph Integration YesYes Fit to Width Rendering YesYesFixed0Currency1Date2Time3Percent4Fraction5Scientific6Special7Custom8General9
   MongoDB 2.4 32-bit Simba MongoDB ODBC Driver 0.04.x SupportedOperating SystemDBMSRecommended ODBC DriverStatusWindows/Linux/Solaris/AIXVertica 7.132-Bit Vertica 7.1.x ODBC DriverCertified Get Started Prepare Data ⟩ Create Cards ⟩ Share Cards ⟩ Administer ⟩ Best Practices ⟩ Authentication ⟩ Authorization ⟩   Encryption ⟩ Web Security ⟩ 0Log all messages (Debug, Info, Warning, Error, Fatal).1Log Info, Warning, Error and Fatal messages.2Log Warning, Error and Fatal messages.3Log Error and Fatal messages4Log Fatal messages onlyany other valueLog as the default value 1Graph TypeSupported in Android?Supported in iOS? Vertical Area YesYes Horizontal Area YesYes Vertical Bar YesYes Horizontal Bar YesYes Vertical Line YesYes Horizontal Line YesYes Pie YesYes Scatter YesYes Polar NoYes Radar NoYes Bubble YesYes HiLo Stock NoYes Histogram NoYes 3D Risers NoYes 3D Floating NoYes 3D Connect Series NoYes 3D Surface NoYes Gauges YesYes Funnel YesYes Pareto YesYes Box Plot NoYes Gantt NoYesGraph Features   3D Scatter NoYes Graph as Selector YesYes Drilling NoiPhone Only Zooming on Graphs NoYes Tooltips  YesYes Graph Animations NoYes Report Graph Integration YesYes Document Graph Integration YesYes Fit to Width Rendering YesYesFixed0Currency1Date2Time3Percent4Fraction5Scientific6Special7Custom8General9	MongoDB 2.4 32-bit Simba MongoDB ODBC Driver 0.04.x SupportedOperating SystemDBMSRecommended ODBC DriverStatusWindows/Linux/Solaris/AIXVertica 7.132-Bit Vertica 7.1.x ODBC DriverCertified Get Started Prepare Data ⟩ Create Cards ⟩ Share Cards ⟩ Administer ⟩ Best Practices ⟩ Authentication ⟩ Authorization ⟩   Encryption ⟩ Web Security ⟩ 0Log all messages (Debug, Info, Warning, Error, Fatal).1Log Info, Warning, Error and Fatal messages.2Log Warning, Error and Fatal messages.3Log Error and Fatal messages4Log Fatal messages onlyany other valueLog as the default value 1Graph TypeSupported in Android?Supported in iOS? Vertical Area YesYes Horizontal Area YesYes Vertical Bar YesYes Horizontal Bar YesYes Vertical Line YesYes Horizontal Line YesYes Pie YesYes Scatter YesYes Polar NoYes Radar NoYes Bubble YesYes HiLo Stock NoYes Histogram NoYes 3D Risers NoYes 3D Floating NoYes 3D Connect Series NoYes 3D Surface NoYes Gauges YesYes Funnel YesYes Pareto YesYes Box Plot NoYes Gantt NoYesGraph Features   3D Scatter NoYes Graph as Selector YesYes Drilling NoiPhone Only Zooming on Graphs NoYes Tooltips  YesYes Graph Animations NoYes Report Graph Integration YesYes Document Graph Integration YesYes Fit to Width Rendering YesYesFixed0Currency1Date2Time3Percent4Fraction5Scientific6Special7Custom8General9
   MongoDB 2.4 32-bit Simba MongoDB ODBC Driver 0.04.x SupportedOperating SystemDBMSRecommended ODBC DriverStatusWindows/Linux/Solaris/AIXVertica 7.132-Bit Vertica 7.1.x ODBC DriverCertified Get Started Prepare Data ⟩ Create Cards ⟩ Share Cards ⟩ Administer ⟩ Best Practices ⟩ Authentication ⟩ Authorization ⟩   Encryption ⟩ Web Security ⟩ 0Log all messages (Debug, Info, Warning, Error, Fatal).1Log Info, Warning, Error and Fatal messages.2Log Warning, Error and Fatal messages.3Log Error and Fatal messages4Log Fatal messages onlyany other valueLog as the default value 1Graph TypeSupported in Android?Supported in iOS? Vertical Area YesYes Horizontal Area YesYes Vertical Bar YesYes Horizontal Bar YesYes Vertical Line YesYes Horizontal Line YesYes Pie YesYes Scatter YesYes Polar NoYes Radar NoYes Bubble YesYes HiLo Stock NoYes Histogram NoYes 3D Risers NoYes 3D Floating NoYes 3D Connect Series NoYes 3D Surface NoYes Gauges YesYes Funnel YesYes Pareto YesYes Box Plot NoYes Gantt NoYesGraph Features   3D Scatter NoYes Graph as Selector YesYes Drilling NoiPhone Only Zooming on Graphs NoYes Tooltips  YesYes Graph Animations NoYes Report Graph Integration YesYes Document Graph Integration YesYes Fit to Width Rendering YesYesFixed0Currency1Date2Time3Percent4Fraction5Scientific6Special7Custom8General9	MongoDB 2.4 32-bit Simba MongoDB ODBC Driver 0.04.x SupportedOperating SystemDBMSRecommended ODBC DriverStatusWindows/Linux/Solaris/AIXVertica 7.132-Bit Vertica 7.1.x ODBC DriverCertified Get Started Prepare Data ⟩ Create Cards ⟩ Share Cards ⟩ Administer ⟩ Best Practices ⟩ Authentication ⟩ Authorization ⟩   Encryption ⟩ Web Security ⟩ 0Log all messages (Debug, Info, Warning, Error, Fatal).1Log Info, Warning, Error and Fatal messages.2Log Warning, Error and Fatal messages.3Log Error and Fatal messages4Log Fatal messages onlyany other valueLog as the default value 1Graph TypeSupported in Android?Supported in iOS? Vertical Area YesYes Horizontal Area YesYes Vertical Bar YesYes Horizontal Bar YesYes Vertical Line YesYes Horizontal Line YesYes Pie YesYes Scatter YesYes Polar NoYes Radar NoYes Bubble YesYes HiLo Stock NoYes Histogram NoYes 3D Risers NoYes 3D Floating NoYes 3D Connect Series NoYes 3D Surface NoYes Gauges YesYes Funnel YesYes Pareto YesYes Box Plot NoYes Gantt NoYesGraph Features   3D Scatter NoYes Graph as Selector YesYes Drilling NoiPhone Only Zooming on Graphs NoYes Tooltips  YesYes Graph Animations NoYes Report Graph Integration YesYes Document Graph Integration YesYes Fit to Width Rendering YesYesFixed0Currency1Date2Time3Percent4Fraction5Scientific6Special7Custom8General9
   MongoDB 2.4 32-bit Simba MongoDB ODBC Driver 0.04.x SupportedOperating SystemDBMSRecommended ODBC DriverStatusWindows/Linux/Solaris/AIXVertica 7.132-Bit Vertica 7.1.x ODBC DriverCertified Get Started Prepare Data ⟩ Create Cards ⟩ Share Cards ⟩ Administer ⟩ Best Practices ⟩ Authentication ⟩ Authorization ⟩   Encryption ⟩ Web Security ⟩ 0Log all messages (Debug, Info, Warning, Error, Fatal).1Log Info, Warning, Error and Fatal messages.2Log Warning, Error and Fatal messages.3Log Error and Fatal messages4Log Fatal messages onlyany other valueLog as the default value 1Graph TypeSupported in Android?Supported in iOS? Vertical Area YesYes Horizontal Area YesYes Vertical Bar YesYes Horizontal Bar YesYes Vertical Line YesYes Horizontal Line YesYes Pie YesYes Scatter YesYes Polar NoYes Radar NoYes Bubble YesYes HiLo Stock NoYes Histogram NoYes 3D Risers NoYes 3D Floating NoYes 3D Connect Series NoYes 3D Surface NoYes Gauges YesYes Funnel YesYes Pareto YesYes Box Plot NoYes Gantt NoYesGraph Features   3D Scatter NoYes Graph as Selector YesYes Drilling NoiPhone Only Zooming on Graphs NoYes Tooltips  YesYes Graph Animations NoYes Report Graph Integration YesYes Document Graph Integration YesYes Fit to Width Rendering YesYesFixed0Currency1Date2Time3Percent4Fraction5Scientific6Special7Custom8General9	MongoDB 2.4 32-bit Simba MongoDB ODBC Driver 0.04.x SupportedOperating SystemDBMSRecommended ODBC DriverStatusWindows/Linux/Solaris/AIXVertica 7.132-Bit Vertica 7.1.x ODBC DriverCertified Get Started Prepare Data ⟩ Create Cards ⟩ Share Cards ⟩ Administer ⟩ Best Practices ⟩ Authentication ⟩ Authorization ⟩   Encryption ⟩ Web Security ⟩ 0Log all messages (Debug, Info, Warning, Error, Fatal).1Log Info, Warning, Error and Fatal messages.2Log Warning, Error and Fatal messages.3Log Error and Fatal messages4Log Fatal messages onlyany other valueLog as the default value 1Graph TypeSupported in Android?Supported in iOS? Vertical Area YesYes Horizontal Area YesYes Vertical Bar YesYes Horizontal Bar YesYes Vertical Line YesYes Horizontal Line YesYes Pie YesYes Scatter YesYes Polar NoYes Radar NoYes Bubble YesYes HiLo Stock NoYes Histogram NoYes 3D Risers NoYes 3D Floating NoYes 3D Connect Series NoYes 3D Surface NoYes Gauges YesYes Funnel YesYes Pareto YesYes Box Plot NoYes Gantt NoYesGraph Features   3D Scatter NoYes Graph as Selector YesYes Drilling NoiPhone Only Zooming on Graphs NoYes Tooltips  YesYes Graph Animations NoYes Report Graph Integration YesYes Document Graph Integration YesYes Fit to Width Rendering YesYesFixed0Currency1Date2Time3Percent4Fraction5Scientific6Special7Custom8General9

   
   
3. oMetric.GridFormat.Info.PropertySets("FormattingNumber")("DecimalPlaces").Value = 0
    
   
4. oMetric.GridFormat.Info.PropertySets("FormattingNumber")("ThousandSeparator").Value = 0 '-1 Checks the box
    
   
5. oMetric.GridFormat.Info.PropertySets("FormattingNumber")("NegativeNumbers").Value = 1
    
   
6. Where the values 1,2,3,4 represent -1234,1234,(1234),(1234)

WARNING MESSAGES:
Customization Code Warning:
This customization is provided as a convenience to Strategy users and is only directly applicable to the version stated. While this code may apply to other releases directly, Strategy Technical Support makes no guarantees that the code provided will apply to any future or previous builds. In the event of a code change in future builds, Strategy may not be able to provide additional code on this matter even though this customization is provided at this time for this specific build