Executive Dashboard

  • Language:
  • About This App

    Executive Dashboard

    This Executive dashboard provides a high-level, easy-to-understand view of key performance indicators (KPI) and business data. Since this dashboard is web-based, executives can use it to quickly analyze key metrics and business trends from any browser.

    Features

      Adding custom icons and graphs is an effective way to provide end-users with visual cues regarding important data. Comparing Year-To-Date sales trends is a useful business tool that helps decision makers better understand where they were, where they are, and what needs their attention. Best of all, creating this in m-Power is a snap! Built-in features, such as AJAX refresh, allow the end-user to interact with each piece of their dashboard independently. Ultimately, this means that your decision maker can customize their display so that relevant data is always at their fingertips. Selection dialogs allow users to easily filter their data in a convenient format. Best of all, when a user isn't fine tuning their data set criteria, the dialog is hidden, allowing for maximized screen usage. Creating dashboards in m-Power is a breeze. Built-in functionality allows developers to create their dashboard sections independently, then, when completed, simply add them onto a master grid!
  • Learn More

    Learn More

    This application was built with m-Power, an easy-to-use web application development platform. To learn more about m-Power, click one of the buttons below.

    The m-Power Test Drive lets you use m-Power via the web, guiding you through the creation of two web applications. To demonstrate m-Power's capabilities, we'll build you a free proof-of-concept application using your own data. Do you have any questions or would you like more information? Fill out this short form.






Today's Orders
    0 Items       Page 1 of 0        
StatementCallback; bad SQL grammar [SELECT COUNT(*) FROM CBB2E."ORDERHEAD" T01 left outer join CBB2E."ORDDETAIL" T02 ON T01."ORDNO"=T02."ORDNO" left outer join CBB2E."DMCMP100" T03 ON T01."CUSNO"=T03."CUSNO" left outer join CBB2E."REGION" T04 ON T03."REGON"=T04."REGON" WHERE (MRCAPPLLIB.MRC_GETNUMDATE(SHPDAT,'mmddyyyy','yyyymmdd')=20171120) ]; nested exception is java.sql.SQLException: [SQL0204] ORDERHEAD in CBB2E type *FILE not found.
Sort Ascending Sort Descending Order
Number
Sort Ascending Sort Descending Region Sort Ascending Sort Descending Customer
Name
Sort Ascending Sort Descending Product
Number
Sort Ascending Sort Descending Quantity
Ordered
Sort Ascending Sort Descending Price Sort Ascending Sort Descending Order
Amount
Category
   
Todays Orders: Selections
General
Rows per Page

Data Selections
Field Relationship Value
Order Number
Region
Customer Name
Product Number
Quantity Ordered
Price
Order Amount
Year To Date Sales

StatementCallback; bad SQL grammar [SELECT sum(T01."SHIPYR"), sum(T01."SHPQTY"), sum(T01."PRICE"), T01."CLASS", sum( (T01."PRICE"*T01."SHPQTY") ), max(T02."CDESC"), sum(T01."CUSNO"), sum(T03."REGON"), max(T04."REGDESC"), max( (T03."REGON" || ': ' || T04."REGDESC") ) FROM CBB2E."SALESHIST" T01 left outer join CBB2E."PCLASS" T02 ON T01."CLASS"=T02."CLASS" left outer join CBB2E."DMCMP100" T03 ON T01."CUSNO"=T03."CUSNO" left outer join CBB2E."REGION" T04 ON T03."REGON"=T04."REGON" GROUP BY T01."CLASS" ORDER BY T01."CLASS" DESC fetch first 10002 rows only]; nested exception is java.sql.SQLException: [SQL0204] SALESHIST in CBB2E type *FILE not found.

Sales by Product Class

StatementCallback; bad SQL grammar [SELECT max(T01."SHIPYR"), T01."SHIPMONTH", sum(T01."SHPQTY"), sum(T01."PRICE"), max( (YEAR(CURRENT_DATE)-1) ), max( (YEAR(CURRENT_DATE)-2) ), sum( (MONTH(CURRENT_DATE)) ), sum( (T01."PRICE"*T01."SHPQTY") ), sum( ( CASE WHEN T01."SHIPYR" = (YEAR(CURRENT_DATE)-2) AND T01."SHIPMONTH" <= (MONTH(CURRENT_DATE)) THEN (T01."PRICE"*T01."SHPQTY") END) ), sum( ( CASE WHEN T01."SHIPYR" = (YEAR(CURRENT_DATE)-1) AND T01."SHIPMONTH" <= (MONTH(CURRENT_DATE)) THEN (T01."PRICE"*T01."SHPQTY") END) ), max(T01."CLASS"), sum(T01."CUSNO"), max(T02."CDESC"), max(T03."CNAME"), sum(T03."REGON"), max(T04."REGDESC"), max(T05."SHIPMONTHF"), sum( (YEAR(CURRENT_DATE)-3) ), sum( ( CASE WHEN T01."SHIPYR" = (YEAR(CURRENT_DATE)-3) AND T01."SHIPMONTH" <= (MONTH(CURRENT_DATE)) THEN (T01."PRICE"*T01."SHPQTY") END) ) FROM CBB2E."SALESHIST" T01 left outer join CBB2E."PCLASS" T02 ON T01."CLASS"=T02."CLASS" left outer join CBB2E."DMCMP100" T03 ON T01."CUSNO"=T03."CUSNO" left outer join CBB2E."REGION" T04 ON T03."REGON"=T04."REGON" left outer join CBB2E."MONTHTAB2" T05 ON T01."SHIPMONTH"=T05."SHIPMONTH" WHERE (T01."SHIPYR">= (YEAR(CURRENT_DATE)-3) AND T01."SHIPMONTH"<= (MONTH(CURRENT_DATE))) GROUP BY T01."SHIPMONTH" ORDER BY T01."SHIPMONTH" ASC fetch first 10002 rows only]; nested exception is java.sql.SQLException: [SQL0204] SALESHIST in CBB2E type *FILE not found.

 
Efficiency


StatementCallback; bad SQL grammar [SELECT sum(T01."SHIPYR"), sum(T01."SHPQTY"), sum(T01."PRICE"), T01."CLASS", sum( ( ((T01."PRICE"*T01."SHPQTY")) -T01."COST") ), sum( ( CASE WHEN T01."CLASS" = '100' THEN ( ((T01."PRICE"*T01."SHPQTY")) -T01."COST") END) ), sum( ( CASE WHEN T01."CLASS" = '200' THEN ( ((T01."PRICE"*T01."SHPQTY")) -T01."COST") END) ), sum( ( CASE WHEN T01."CLASS" = '300' THEN ( ((T01."PRICE"*T01."SHPQTY")) -T01."COST") END) ), sum(T01."COST"), sum(T01."SHIPMONTH"), max( ( CASE WHEN T01."SHIPMONTH" < 10 THEN '0' || T01."SHIPMONTH" || ' - ' || MONTHNAME(YEAR(CURRENT_DATE) || '-' || T01."SHIPMONTH" || '-01') ELSE T01."SHIPMONTH" || ' - ' || MONTHNAME(YEAR(CURRENT_DATE) || '-' || T01."SHIPMONTH" || '-01') END) ), sum( ((T01."PRICE"*T01."SHPQTY")) ), sum( (MONTH(CURRENT_DATE)) ) FROM CBB2E."SALESHIST" T01 WHERE (T01."SHIPMONTH"<= (MONTH(CURRENT_DATE))) GROUP BY T01."CLASS" ORDER BY T01."CLASS" ASC fetch first 10002 rows only]; nested exception is java.sql.SQLException: [SQL0204] SALESHIST in CBB2E type *FILE not found.