This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
app:app_how_to_dash [2019/05/08 00:04] dtucker |
app:app_how_to_dash [2019/07/25 22:22] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ====== APP - Using Dashboards ====== | + | ====== |
| - | + | ||
| - | **Using APP Dashboards** | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | {{: | + | |
| - | + | ||
| - | {{: | + | |
| - | + | ||
| - | {{: | + | |
| - | + | ||
| - | {{: | + | |
| - | + | ||
| - | {{: | + | |
| - | + | ||
| - | {{: | + | |
| - | + | ||
| - | {{: | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | **How To Set Up Dashboards in APP** | + | |
| - | + | ||
| TWBS Advanced Productivity Pack (APP) provides tools to create charts from SAP Business One data and present them as either a stand-alone Chart or as an element of a Dashboard. | TWBS Advanced Productivity Pack (APP) provides tools to create charts from SAP Business One data and present them as either a stand-alone Chart or as an element of a Dashboard. | ||
| - | [[# | + | ===== How To Create an APP Dashboard |
| - | + | ||
| - | + | ||
| - | + | ||
| - | [[# | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | [[# | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | [[# | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | [[# | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | [[# | + | |
| - | + | ||
| - | {{: | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | **How To Create an APP Dashboard** | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | Click the SAP menu option titled **Dashboard Setup** under the **Administration** -**Setup** -**TWBS APP** menus to load the Dashboards setup screen. | + | |
| - | {{:app/image763.jpeg?723x59}} | + | * Click the SAP menu option titled <color # |
| - | **Note -** The form will open in Add mode. The user can click the New icon ({{: | + | <WRAP center round info> |
| + | The form will open in Add mode. The user can click the New icon {{: | ||
| + | </ | ||
| {{: | {{: | ||
| - | Enter the **Dashboard Name** for the new Dashboard. This will be the name for the dashboard that is displayed to the user. | + | * Enter the <color #00a2e8>**Dashboard Name**</ |
| + | * Select users from the **User Defaults** drop down list. See the **How To Set Up User Defaults for an APP Dashboard** section for more information about this feature. | ||
| + | * Select the option for the desired orientation of the dashboard... | ||
| + | * <color # | ||
| + | * <color # | ||
| + | * <color # | ||
| + | * Click the <color # | ||
| + | * The dashboard layout form is will launch based on the orientation option previously selected. | ||
| - | | + | <WRAP center round info> |
| - | + | A new dashboard will always show four chart windows. Click the **X** to remove an unwanted window. The image below is an example of one of these chart windows. | |
| - | Select the option for the desired orientation of the dashboard... | + | </ |
| - | + | ||
| - | + | ||
| - | + | ||
| - | {{: | + | |
| - | + | ||
| - | {{: | + | |
| - | + | ||
| - | {{: | + | |
| - | + | ||
| - | Click the **Create** button to move to the dashboard layout. | + | |
| - | + | ||
| - | The dashboard layout form is will launch based on the orientation option previously selected. | + | |
| - | + | ||
| - | {{: | + | |
| {{: | {{: | ||
| - | For each chart window, you must specify the following information... | + | * For each chart window, you must specify the following information... |
| - | + | | |
| - | {{: | + | |
| - | + | | |
| - | Chart | + | * <color #00a2e8>**Unique ID**</ |
| - | + | * **<color #00a2e8>Chart ID</ | |
| - | + | * **<color #00a2e8>User Query</ | |
| - | + | | |
| - | Grid | + | |
| - | + | | |
| - | + | | |
| - | + | * **<color #00a2e8>Condition Filter</ | |
| - | {{:app/image6.jpeg? | + | |
| - | + | * **<color #00a2e8>Load Behavior</ | |
| - | {{: | + | |
| - | + | | |
| - | {{: | + | |
| - | + | | |
| - | {{: | + | |
| - | + | ||
| - | **Standalone** - Chart/grid data independent from other chart | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | windows. | + | |
| - | + | ||
| - | **Linked** - Chart/grid data linked to another chart window. | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | **Link To (for Linked option)** - Select the chart window to | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | link to. | + | |
| - | + | ||
| - | **Condition Filter (for Linked option)** - Select the chart | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | window condition filter. | + | |
| - | + | ||
| - | **Default Filter (for Linked option)** - Select the chart | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | window default filter. | + | |
| - | + | ||
| - | **Load Behavior (for Linked option)** - Select the chart window data load behavior. | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | **Show on Load** - The data for the chart window will only display once on load. | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | **Show on Linked** - The data for the chart window will be refreshed on the change of the linked value from another chart window. | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | The Dashboard can be resized by grabbing and dragging the corners or sides of the form. | + | |
| - | + | ||
| - | The Dashboard windows can be resized by grabbing and dragging the divider between the windows. | + | |
| {{: | {{: | ||
| - | Click the **Save** button to save the Dashboard layout; click the **Cancel** button to exit the Dashboard layout form; click the **Preview** button to see how the Dashboard will appear when in use. | + | * Click the <color #22b14c>**Save**</ |
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | **How To Edit an APP Dashboard** | + | |
| - | + | ||
| - | Click the SAP menu option titled **Dashboard Setup** under the **Administration** -**Setup** -**TWBS APP** menus to load the Dashboards setup screen. | + | {{: |
| + | ===== How To Edit an APP Dashboard ===== | ||
| - | Click the Folder icon ({{: | + | * Click the SAP menu option titled <color # |
| + | * Click the Folder icon {{: | ||
| + | * | ||
| {{: | {{: | ||
| - | Click the **Update** button to make changes to display the Dashboard windows layout. | + | * Click the <color #22b14c>**Update**</ |
| - | + | | |
| - | The windows layout is automatically displayed with four windows, even if the original layout had fewer. Remove any unwanted windows. | + | |
| - | + | ||
| - | Modify the Dashboard information as needed. | + | |
| {{: | {{: | ||
| - | Click the **Save** button. | + | * Click the <color #22b14c>**Save**</ |
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | **How To Delete an APP Dashboard** | + | |
| - | + | ||
| - | Click the SAP menu option titled **Dashboard Setup** under the **Administration** -**Setup** -**TWBS APP** menus to load the Dashboards setup screen. | + | {{: |
| + | ===== How To Delete an APP Dashboard===== | ||
| - | Click the Folder icon ({{: | + | * Click the SAP menu option titled <color # |
| + | * Click the Folder icon {{: | ||
| + | * | ||
| {{: | {{: | ||
| - | Click the Delete icon ({{: | + | * Click the <color # |
| + | * Click the <color # | ||
| - | | + | <WRAP center round important> |
| + | Once a Dashboard' | ||
| + | </ | ||
| - | {{:app/image306.jpeg?723x52}} | + | {{:app/image44.jpeg?786}} |
| - | **Warning** - Once a Dashboard's information has been removed from the system, it **cannot** be recovered and must be recreated manually. | + | ===== How To Set Up User Defaults for an APP Dashboard |
| - | + | | |
| - | + | | |
| - | + | * | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | **How To Set Up User Defaults for an APP Dashboard** | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | Click the SAP menu option titled **Dashboard Setup** under the **Administration** | + | |
| - | + | ||
| - | Click the Folder icon ({{: | + | |
| {{: | {{: | ||
| - | Click the **User Defaults** drop down menu to display the available users. | + | * Click the <color #00a2e8>**User Defaults**</ |
| - | + | | |
| - | Select the users that you want to assign this Dashboard as the default that will display at time of login to SAP® Business One. | + | |
| - | + | | |
| - | Click the **Update** button to make changes to display the Dashboard windows layout. | + | |
| - | + | ||
| - | The windows layout is automatically displayed with four windows, even if the original layout had fewer. Remove any unwanted windows. | + | |
| - | + | ||
| - | Modify the Dashboard information as needed. | + | |
| {{: | {{: | ||
| - | Click the **Save** button. | + | * Click the <color #22b14c>**Save**</ |
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | **Query Tips and Tricks for APP Dashboards** | + | |
| + | {{: | ||
| + | ===== Query Tips and Tricks for APP Dashboards ===== | ||
| - | **SAP® Business One Link To Document Arrows** | + | ==== SAP® Business One Link To Document Arrows |
| One of the integration features of SAP® Business One custom queries is the ability to include a "Link To" golden arrow in the results set that allows the user to drill back to the referenced marketing document. In order to accomplish this, there are several key pieces of information that are **required** in the query to accomplish this link... | One of the integration features of SAP® Business One custom queries is the ability to include a "Link To" golden arrow in the results set that allows the user to drill back to the referenced marketing document. In order to accomplish this, there are several key pieces of information that are **required** in the query to accomplish this link... | ||
| - | | + | * |
| + | * Object Type (ObjType) value usually | ||
| - | Object Type (ObjType) value usually from the document table. | + | <WRAP center round tip> |
| + | The **SAP® Document | ||
| + | </ | ||
| - | {{: | + | <WRAP center round important> |
| + | The Production Order database table (OWOR) does not have a specific ObjType field that contains the value for the Production Order document header record. | ||
| + | </ | ||
| - | **Tip** - The [[# | + | ==== Dates ==== |
| - | + | ||
| - | **[[# | + | |
| - | + | ||
| - | {{: | + | |
| - | + | ||
| - | **Warning** - The Production Order database table (OWOR) does not have a specific ObjType field that contains the value for the Production Order document header record. | + | |
| - | + | ||
| - | **Dates** | + | |
| Assume that the current date is May 15, 2010 for the following examples. | Assume that the current date is May 15, 2010 for the following examples. | ||
| - | | + | * |
| - | {{: | + | <WRAP center round info> |
| + | Parenthesis () are required since this is a SQL function. | ||
| + | </ | ||
| - | **Note** - Parenthesis | + | |
| + | * <color # | ||
| + | * <color # | ||
| + | * <color # | ||
| + | * <color # | ||
| + | * <color # | ||
| + | * Filtering by Date - The SQL <color # | ||
| + | * Records where the order date is in the current week | ||
| + | * <color # | ||
| + | * Records where the order date is in the prior week | ||
| + | * <color # | ||
| + | * Records where the order date is in the current quarter | ||
| + | * <color # | ||
| - | | + | ==== Numbers ==== |
| - | **Select datepart(//year//, | + | The user interface for SAP® Business One displays decimal numeric values based on the <color #22b14c>**Display**< |
| - | {{: | + | the **<color # |
| - | + | ||
| - | **Select datepart(// | + | |
| - | + | ||
| - | {{:app/image6.jpeg?10x10}} | + | |
| - | + | ||
| - | **Select datepart(// | + | |
| - | + | ||
| - | {{:app/image6.jpeg?10x10}} | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | **Select datepart(// | + | |
| - | + | ||
| - | {{: | + | |
| - | + | ||
| - | **Select datepart(// | + | |
| - | + | ||
| - | {{: | + | |
| - | + | ||
| - | | + | |
| - | + | ||
| - | {{: | + | |
| - | + | ||
| - | **Select t0.docnum, t0.docdate from ORDR where datepart(year, | + | |
| - | + | ||
| - | {{: | + | |
| - | + | ||
| - | **Select t0.docnum, t0.docdate from ORDR where datepart(year, | + | |
| - | + | ||
| - | {{: | + | |
| - | + | ||
| - | **Select t0.docnum, t0.docdate from ORDR where datepart(year, | + | |
| - | + | ||
| - | **Numbers** | + | |
| - | + | ||
| - | The user interface for SAP® Business One displays decimal numeric values based on the **Display** tab setup which can be accessed the SAP menu option for **Display** under the **Administration** -**System Initialization** -**General Settings** | + | |
| However, decimal values are stored in the database to six-decimal precision. This means that a decimal value such as US Dollars that is displayed in SAP® Business One as 100.00 will be retrieved and displayed in the APP Charts as 100.000000. The number of decimals can be controlled by the SQL statement in the query. Combinations of **cast** and **round** can be used to arrive at a reasonable display value. | However, decimal values are stored in the database to six-decimal precision. This means that a decimal value such as US Dollars that is displayed in SAP® Business One as 100.00 will be retrieved and displayed in the APP Charts as 100.000000. The number of decimals can be controlled by the SQL statement in the query. Combinations of **cast** and **round** can be used to arrive at a reasonable display value. | ||
| - | Display the database value 100.000000 for the column DocTotal with 2 decimals (100.00) | + | * Display the database value 100.000000 for the column DocTotal with 2 decimals (100.00) |
| - | + | * <color #ff7f27>**Select cast(t0.DocTotal as decimal(16, | |
| - | **Select cast(t0.DocTotal as decimal(16, | + | |
| - | + | * <color #ff7f27>**Select round(t0.DocTotal, | |
| - | Display the database value 55.900000 for the column DocTotal rounded to a whole number (56.000000) | + | |
| - | + | * <color #ff7f27>**Select cast(round(t0.DocTotal, | |
| - | **Select round(t0.DocTotal, | + | |
| - | + | ||
| - | Display the database value 55.900000 for the column DocTotal rounded to a whole number (56.000000) and without decimals | + | |
| - | + | ||
| - | **Select cast(round(t0.DocTotal, | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | **How To Use APP Dashboards** | + | |
| + | {{: | ||
| + | ===== How To Use APP Dashboards ===== | ||
| Once an APP Dashboard has been created it is available for viewing via the right-click menu from the SAP® Business One form that it has been linked to. | Once an APP Dashboard has been created it is available for viewing via the right-click menu from the SAP® Business One form that it has been linked to. | ||
| Line 363: | Line 171: | ||
| {{: | {{: | ||
| - | When more than one dashboard is linked to the screen, the titles of those dashboards will display in a **Dashboards** sub-menu off the regular right-click menu below any reports or charts... | + | When more than one dashboard is linked to the screen, the titles of those dashboards will display in a <color #22b14c>**Dashboards**</ |
| {{: | {{: | ||
| Line 369: | Line 177: | ||
| A specific chart from a dashboard can be accessed by double-clicking on the chart window. This opens the standard APP Chart window for additional use. | A specific chart from a dashboard can be accessed by double-clicking on the chart window. This opens the standard APP Chart window for additional use. | ||
| + | {{: | ||