Skip to main content

MITS Web Markup Language for Dashboards and Scorecards

White Cup
Updated

MITS Web Markup Language (MWML) is the language used to define the data components in dashboards. If you are familiar with HTML or XML, the syntax of MWML will be easy to interpret.

While White Cup BI does have the visual dashboard editor, there may be times MWML is needed to preform advanced tasks when creating or modifying a dashboard or scorecard.

Tags

MWML tag statements are enclosed by {} characters. The tag statement structure is as follows:

{TAG OPTION ATTRIBUTE=’VALUE’}

Tag Component

Description

TAG

Tag type, e.g. (Cell, Grid, Chart, etc.)

OPTION

Base option; these are options that do not require a value

ATTRIBUTE

Attributes are options that require a value

Note: The ‘=’ of an attribute cannot be surrounded by spaces.

 

Attributes

There are two key attributes used to structure an MWML statement of a dashboard object.

  • FLASH - Identifies what data is shown in the dashboard component
  • HREF - Identifies where the hyperlink for the dashboard component points 

The syntax for the MITS Query Language, used to generate the FLASH statements can be found in the article, MITS Query Language (MQL) for White Cup BI.

For explanations of other attributes, see the Dashboard Component Types at the end of this article.

 

FLASH
The FLASH attribute defines what data will be pulled into the dashboard component.

 Example:

FLASH=\FLASH SALES PROFIT.Y\


Breakdown:

(FLASH=)1(\)2(FLASH)3 (SALES)4 (PROFIT.Y)5(\)6

  1. Begins the FLASH statement
  2. Starts enclosing the value
  3. Identifies that a flash screen report is being described
  4. Identifies the hypercube
  5. Identifies the column(s) of data being pulled in
  6. Finishes enclosing the value

 

HREF
The HREF attribute defines to what report the dashboard component hyperlink will point.

Example:

HREF=\FLASH SALES PC SALES.Y COST.Y PROFIT.Y HEADING "Product Categories - YTD Sales"\


Breakdown:

(HREF=)1(\)2(FLASH)3 (SALES)4 (PC)5 (SALES.Y COST.Y PROFIT.Y)6 (HEADING "Product Categories - YTD Sales")7(\)8

  1. Begins the HREF statement
  2. Starts enclosing the value
  3. Identifies that a flash screen report is being described
  4. Identifies the hypercube
  5. Identifies the initial drill-down path for the report
  6. Identifies the column(s) of data being pulled in
  7. Describes the heading to use for the report
  8. Finishes enclosing the value

 

Examples

Below are 2 examples of MWML statements that define data components within a full-screen dashboard. Note that MWML statements are enclosed by {} characters.

 

Example 1 (Cell Type) 

{CELL FLASH=\FLASH SALES SALES.Y\

HREF=\FLASH SALES PC SALES.Y COST.Y PROFIT.Y UNITS.Y GP.PCT.Y HEADING "Product Categories – YTD Sales"\ TEXT.BEFORE="Sales : "TEXT.AFTER=""}

 

Example 2 (Stoplight Type)

{STOPLIGHT FLASH=\FLASH SALES TREND_PROFIT.M-13_PROFIT.M-1\

HREF=\FLASH SALES PC TREND_PROFIT.M-13_PROFIT.M-1 PROFIT.M-1 PROFIT.M-13 HEADING "Product Categories –Profit Trends"\ TEXT.AFTER="Year over Year Monthly Profit Trend : " STOPLIGHT.BOUNDARIES=\-10|0\ STOPLIGHT.IMAGES=\redlight.png|yellowlight.png|greenlight.png\}

 

Related articles

Comments

0 comments

Article is closed for comments.