Link in Drill Down
Link in Drill DownRelated InformationDrill ThroughBizview VersionFeature available from Bizview version -Bizview 8.5There are two ways to get a link in a drill down in an Analytics report:If the data includes "://", a link will be displayed (http://aftonbladet.se/ in the example below). Add a procedure in the table app.dataview_fields for the data view column that should return a link. Go to th...
Tab Settings
Tab SettingsRelated InformationRight PanelDashboard SettingsDasharea SettingsA dashboard can contain several different tabs, with different dashareas within each tab. This topic contains the following sections:Add TabsDelete TabsChange Tab OrderBelow is an example of a dashboard with tabs:You can change settings for a specific tab if you go to the right panel and choose desired tab in the drop ...
Drill Down in Chart
Drill Down in ChartBizview VersionFeature available from Bizview version -Bizview 8.5A new feature makes it possible to create drill downs in charts. To enable this feature, you, as a designer, need to add multiple arguments in Data Bindings.For example, if you want users to be able to drill down from Product Line to Product Group and Product, drag and drop those fields to Argument:When you lea...
Pie Chart
Pie ChartRelated InformationInserting a DashareaData BindingsField SortingsFiltersSelect the Insert tab in the ribbon and click on Pie Chart to insert a pie chart area into the dashboard.Below is an example of a pie chart:After inserting a pie chart dasharea, complete the following steps:Data Bindings: Connect the dasharea to data.Field Sortings: Sort the data the way you want (optional).Filter...
Linear Gauge
Linear GaugeRelated InformationInserting a DashareaData BindingsField SortingsFiltersSelect the Insert tab in the ribbon and click Linear Gauge to insert a linear gauge area into the dashboard.Below is an example of a linear gauge:After inserting a linear gauge dasharea, complete the following steps:Data Bindings: Connect the dasharea to data.Field Sortings: Sort the data the way you want (opti...
Circular Gauge
Circular GaugeRelated InformationInserting a DashareaData BindingsField SortingFiltersTo insert a circular gauge area into your dashboard, select the Insert tab on the ribbon and select Circular Gauge. Below are examples of circular gauges: After inserting a circular gauge dasharea, complete the following steps:Field Sortings: So...
Grid
GridRelated InformationInserting a DashareaData BindingsField SortingsFiltersSelect the Insert tab in the ribbon and click Grid to insert a grid area into the dashboard.Below is an example of a grid:After inserting a grid, complete the following steps:Data Bindings: Connect the dasharea to dataField Sortings: Sort the data the way you want (optional).Filters: Add filters to the data to display ...
Slicer
SlicerRelated InformationInserting a DashareaData BindingsField SortingsFiltersBizview VersionFeature available from Bizview version -Bizview 8.5To inset a slicer area into the dashboard, click on the Insert tab in the ribbon and click on Slicer.Below is an example of a slicer:After inserting a slicer, complete the following steps:Data Bindings: Connect the dasharea to data.Field Sortings: Sort...
Card
CardRelated InformationInserting a DashareaData BindingsField SortingFiltersBizview VersionFeature available from Bizview version -Bizview 8.5To insert a card area into the dashboard, select the Insert tab in the ribbon and select Card.Below is an example of a card:After inserting a card, complete the following steps:Data Bindings: Connect the dasharea to dataField Sortings: Sort the data the w...
Image
ImageRelated InformationInserting a DashareaSelect the Insert tab in the ribbon and click Image to insert an image area into the dashboard.Below is an example of an image:To change the appearance of the image, access General Settings in the right panel.Below is a list of the general settings for images:SettingDescriptionShow titleDisplays the title above the dasharea (ON/OFF).TitleThe title of ...
Text
TextRelated InformationInserting a DashareaSelect the Insert tab in the ribbon, and select Text to insert a text area into the dashboard.Text example:To view available settings, access General Settings in the right panel.Below is a list of General Settings:SettingDescriptionShow titleDisplays the title above the dasharea (ON/OFF).TitleThe title of the dasharea.BackgroundSelect a background colo...
IFrame
IFrameRelated InformationInserting a DashareaSelect the Insert tab in the ribbon and click IFrame to insert an IFrame into the dashboard.Below is an example of an IFrame:Note: You cannot navigate within the IFrame in dashboard edit mode. You must be in view mode to scroll and select links within the IFrame. To change the appearance of the IFrame, access General Settings in the right panel.Belo...
My Favourites
My FavouritesRelated InformationInserting a DashareaHomepage DashboardSelect the Insert tab in the ribbon and click on My Favourites to insert an area summarizing the user's favourite report, forms, gridforms, and analytic reports into the dashboard.Below is an example of My Favourites:The content in this dasharea is dynamic, depending on which reports, forms, gridforms, and analytic reports (i...
Not Yet Implemented Features
Not Yet Implemented FeaturesRelated InformationSum AllocationLimitations Copy/Paste Sum Values
EDITSUM Tag
EDITSUM TagRelated InformationSum AllocationLock CellsSave of LOCKED CELLSThe sum columns and rows that should be modifiable by end-users need to be tagged in the template. To do this, use the COLTYPE row and/or ROWTYPE column and add the tag EDITSUM. The rows/columns tagged with this ID (if these contain a sum, +, or subtotal formula) will be able to be modified by user and the value entered w...
Lock Cells
Lock CellsRelated InformationSum AllocationEDITSUM TagSave of LOCKED CELLSIf the end-user has the ability to lock cells within the allocation range, these need to be stated within a specific named range. All cells within named ranges starting with _ALLOC_ have the option to lock. Note: If cells within EXPAND rows should be able to lock, then the row above the EXPAND row in the template needs t...
Gridform Design
Gridform DesignThe Gridform Design lets you create a variety of useful and informative gridforms.
Additional Parameters
Additional ParametersAdditional parameters can be entered for columns in gridform design. There is no GUI for this, so to be able to change the settings, you need to export the template to Excel, and then import it into Bizview again.Ribbon ButtonDescriptiongroupIndexGroup the grid by specific columns. groupIndex=1 (the first column that you want to group), groupIndex=2 (if you want the grid to...
Dependent Lists
Dependent ListsIn the list that should be dependent on another, ensure that the SQL query returns a column named exactly as the column that the list is dependent on.In the example below, the UNIT listbox is dependent on the DIVISION column:In yellow, the SQL query for the UNIT column, in the Test SQL window you can see that the query returns a column named DIVISION, which corresponds to the col...
Ribbon - Objects
Ribbon - ObjectsRelated InformationRight PanelOpening an existing object, or creating a new object, displays the Objects Grid.The ribbon in the Objects tab contains the following options:Ribbon ButtonDescriptionSaveSaves the values you added, modified, or deleted in the grid to the database table. This button is visible when the gridform is changed in any way. Note: Always remember to save you...
Right Panel - Objects
Right Panel - ObjectsRelated InformationObjectsRibbonUpon opening an Object, a right panel displays:The panel consists of three tabs:Object SettingsShow/HideTree View
Show/Hide Objects
Show/Hide ObjectsUpon opening Objects and selecting the Show/Hide tab, some of the view tags are visible by default (marked with a check mark).Mark/unmark the different view tags to view the different show/hide options. Click any of the options in the list to view or hide columns. Or, select View all/Hide all to mark all the different options at the same time.Alter the size of the form and wha...
Object Overview
Object OverviewRelated InformationClient SetupRibbonRight PanelThe Object Overview grid is serves as a complete overview of all objects and linked object attributes, parent attributes, as well as parent objects.Note: You cannot edit items in this grid. To make edits, navigate to the specific object by clicking the hyperlink in the ID column.Any linked object attribute, parent attribute, or pare...
Ribbon - Object Overview
Ribbon - Object OverviewRelated InformationObject OverviewRight panelThe ribbon in the Object Overview tab contains the following options: Ribbon ButtonDescriptionRefreshRefreshes data in the grid.CloseCloses the object overview grid.FilterOpens a filter field the top of the grid. Here, you can select a value that you want to filter the rows by, or you can enter a value to filter on. In some co...
Right Panel
Right PanelRelated InformationObject OverviewRibbonWhen opening an Object Overview, a right panel displays:The right panel consists of two tabs:Object Tree HierarchiesShow/Hide
Object Tree Hierarchies
Object Tree HierarchiesRelated InformationRight PanelShow/HideIn Object Tree Hierarchies a tree view can be found, where all object tree hierarchies are visualized:
Ribbon - Spreadkeys
Ribbon - SpreadkeysRelated InformationSpreadkeysRight PanelThe Spreadkey ribbon contains the following options:Ribbon buttonDescriptionSaveSaves the values you added, modified, or deleted in the grid to the database table. This button is visible when the gridform is changed in any way. Note: Always remember to save your values before closing the grid or logging out. AddAdds a new row in the gr...
Appearance
AppearanceRelated InformationBrandingE-mailSystemOtherAdvancedThis topic describes how to change the appearance of your Bizview application in Application Settings as an Administrator.The system administrator can change a couple of settings in the Appearance dialog, described below:FieldDescriptionCultureDrop-down to choose desired culture.LanguageDrop-down to choose language.Show ID in MenuYES...
Branding
BrandingRelated InformationAppearanceE-mailSystemOtherAdvancedAs a System Administrator, you can customize the look and feel of your Bizview login page and application via the Branding page.Below is a list of customizable features: FieldDescriptionLogin Page - Text ColorSelect the color of your login page text.Login Page - Logotype ImageSelect logotype for the login page. In Silverlight Client,...
E-mail
E-mailRelated InformationAppearanceBrandingSystemOtherAdvancedE-mail includes settings regarding SMTP configuration, your outgoing E-mail information, and E-mail handling in Workflows.The following settings are available:FieldDescriptionCredentialsSelect Credentials to enter the address for the SMTP server and the login credentials to the SMTP mail server.Test E-mail settingsTests the credentia...