BI-Creator - Versionsgeschichte

Schreur: /* Dialog Filter Area */

2020-10-27T12:04:22Z

‎Dialog Filter Area

2020-10-27T11:42:14Z

‎Dialog Filter Area

2020-10-27T11:38:28Z

‎Settings

2020-10-27T11:36:32Z

‎Settings

2020-10-27T08:10:54Z

‎Field Area

2020-10-27T08:10:09Z

‎Field Area

2020-10-26T15:30:31Z

‎Dynamic Filter area

2020-10-26T15:29:30Z

‎Dynamic Filter area

2020-10-26T15:28:49Z

‎Dynamic Filter area

2020-10-26T15:13:37Z

‎Dynamic Filter area

@@ Zeile 212: / Zeile 212: @@
 In the BI Form Dialog, the predefine can be used and the Data can be displayed in View (Preview as Grid or Pivot Grid).
-As an example, we create a Report based on our Data from the SELECT we used before.<syntaxhighlight lang="sql">
+As an example, we create a Report based on our Data from the SELECT we used before.
-SELECT * from B_PRODPLAN
+ <syntaxhighlight lang="sql">
-WHERE ARTNR = :ARTNR
+ SELECT * from B_PRODPLAN
-?AND FORM = :FORM
+ WHERE ARTNR = :ARTNR
-</syntaxhighlight>
+ ?AND FORM = :FORM
 [[File:Reporting Area.png|alt=Reporting Area|thumb|Reporting Area|none]]

@@ Zeile 218: / Zeile 218: @@
 </syntaxhighlight>
 [[File:Reporting Area.png|alt=Reporting Area|thumb|Reporting Area|none]]
 [https://wiki.cds.co.at/wikipat/index.php?title=CUSTOMER:PAT_Enterprise Overview Enterprise Client Menu]

@@ Zeile 199: / Zeile 199: @@
 '''Auto Refreshing:''' Is a simple extension that allows you to automatically update and reload a page at a certain interval. The interval is specified in seconds.
-'''Auto Refreshing Interval:''' Defines the interval time in minutes
+'''Auto Refreshing Interval:''' Defines the interval time in seconds,
 '''Enable Api:''' It allows data to be called up or viewed from different platforms

@@ Zeile 199: / Zeile 199: @@
 '''Auto Refreshing:''' Is a simple extension that allows you to automatically update and reload a page at a certain interval. The interval is specified in seconds.
-'''Auto Refreshing Interfall:''' Defines the interfall time in minutes
+'''Auto Refreshing Interval:''' Defines the interval time in minutes
 '''Enable Api:''' It allows data to be called up or viewed from different platforms

@@ Zeile 184: / Zeile 184: @@
 * '''Display Name:''' Name which is used in the Dialog and Report Area.
 * '''Display Type:''' Datatype of the field (e.g. .NET Field types)
 * '''Topsy Turvy:''' turn everything upside down (upside down).
- For example: select artnr, artkbz, fl_inaktiv from b_artikel (the InActive becomes an Active and is therefore easier to read)
+**For example: select artnr, artkbz, fl_inaktiv from b_artikel (the InActive becomes an Active and is therefore easier to read)
 <br clear=all>

@@ Zeile 176: / Zeile 176: @@
 === Field Area ===
 In the Field Area of the BI Creator, the fields which are defined in the SELECT statement can be renamed and  the type of the field can be changed. The columns which are included in the Field Area are:
 * '''POS:''' You have the possibility to change the order given by the system by drag and drop.
 * '''Database Name:''' Column name from the database and the SELECT
@@ Zeile 184: / Zeile 184: @@
 * '''Display Name:''' Name which is used in the Dialog and Report Area.
 * '''Display Type:''' Datatype of the field (e.g. .NET Field types)
-* '''Topsy Turvy:''' turn everything upside down (upside down). For example: select artnr, artkbz, fl_inaktiv from b_artikel (the InActive becomes an Active and is therefore easier to read)
+* '''Topsy Turvy:''' turn everything upside down (upside down).
 <br clear=all>

@@ Zeile 78: / Zeile 78: @@
 *'Lookup(Search)' -> optional search within the lookup,
 *'Multi-Select Lookup' -> CheckedComboBox multi-selection
-**=> must IN (:Company) or 'Fixed Value' -> There should be the possibility to take fix defined values, these are: Current Company ID, Current Main Location ID, Current Workstation
+ => must IN (:Company) or 'Fixed Value' -> There should be the possibility to take fix defined values, these are: Current Company ID, Current Main Location ID, Current Workstation
 '''5) Option:'''

@@ Zeile 81: / Zeile 81: @@
 '''5) Option:'''
-*For type 'Input', the option can be set as Default, Uppercase, Lowercase, and Numeric; *
+*For type 'Input', the option can be set as Default, Uppercase, Lowercase, and Numeric;
-for type 'Lookup', 'Lookup(Search)' or 'Multi-Select Lookup' this option will be taken from the model, stored procedure, hardcoded values or SQL.
+*for type 'Lookup', 'Lookup(Search)' or 'Multi-Select Lookup' this option will be taken from the model, stored procedure, hardcoded values or SQL.
 With the SQL filter you have the possibility to define a selection list by SQL query.

@@ Zeile 74: / Zeile 74: @@
 '''3) Display Text:''' The alias for the column to be used in the SQL statement.
-'''4) Type:''' The Type determines which control is used. The type can be selected from 'Input', 'Date', 'Lookup' ->  a field can be selected , 'Lookup(Search)' -> optional search within the lookup 'Multi-Select Lookup' -> CheckedComboBox multi-selection => must IN (:Company) or 'Fixed Value' -> There should be the possibility to take fix defined values, these are: Current Company ID, Current Main Location ID, Current Workstation
+'''4) Type:''' The Type determines which control is used. The type can be selected from:
-'''5) Option:''' For type 'Input', the option can be set as Default, Uppercase, Lowercase, and Numeric; for type 'Lookup', 'Lookup(Search)' or 'Multi-Select Lookup' this option will be taken from the model, stored procedure, hardcoded values or SQL. With the SQL filter you have the possibility to define a selection list by SQL query.
+'''5) Option:'''
 '''6) Type Detail:''' In case of 'Lookup', 'Lookup(Search)' and 'Multi-Select' the option can be chosen from 'Model', 'Stored Procedure' (a package including a function) or 'Hardcoded' (verbous free-text).

@@ Zeile 84: / Zeile 84: @@
 '''8) Mandatory:''' If you remove the "'''?'''" from the sql-statement, an optional entry becomes a mandatory
   '''?AND''' = :CompanyId => Optional
-  '''AND''' = :CompanyId => Mandatory)
+  '''AND''' = :CompanyId => Mandatory
 <br clear=all>