MS4BI HELP 2019

by MS4script
01-Introduction
Preface & Copyright
Getting started
Demos Simple
02- Declarations
Structure
Type
03- Instructions
Conditions if,do,while..
String functions Str..()
Get + Include functions Get, Include..
Date-Time Day, Time, Year.
Display
Call
Formulas Complex
04- Database
Connector Ado, Odbc, Dsn, SAP, Ms4
Connect DB Create, delete
Import DataSource Import, Consolidation
Administration Admin, User
05- Sql-Query
Sql
Query Form : BTS,SHOW
Grid option
06- Charts
Forms Show, Win, Image, Excel, Morris...
Pie Std, Donut, 3D...
Bar Std, Stack, Line, Area, Plot
Radar
QrCode, Gauge
Step, Stock...
,Google,Leaflet... GeoMap
,Gantt,Timeline,Org.
07- Dashboard
Form tab, no tab
Responsive UI
08- Report
Report Hierarchy
Report Design
09- Filters
Dialogue + Call
10- Menus
Menu Design
Menu Frameset
Menu Special
11-UI : Responsive
Tables Responsive,Frame,position
List Group
Text
Panel Header, body, Footer
Button Button, Progress Bar
Icon & Button
Collapse Group, Panel
Notifications
12- Encryption
Encrypt
Decrypt
13- Windows
Dialogue
Picture, Frame, Button..
MsgBox
Grid
14- Cloud.
Account Open
15- Css, html, Php, js.
Insert Native language Begin_sw..End_Sw
16-Install + tools.
Installation & Configuration This Menu
Generate Native... Php, Html, js..
Code Generator Ms4 Script
MarkDown Ms4 Script
Source Code Menu Help This Menu
written with ms4script
     

BASIC HELP : MS4BI by MS4script 2019 version 1

Chapter 4 : DATABASES & CONNECTORS

Definition

- connects databases with MS4DB, ADO, ODBC, SAPLOGON or DSN oracle data sources
- connectors are defined between open and closed brackets: {connector }

Syntax

 		 
			function{connector}(string ...DB Name or other depending on the function) ;
 	

Example 1 MS4 DB

 		   
    text : Lcurrentdb :="#DRIVERSYS+\MONDAYSOFTWARE\MS4BI\01-GETTING-STARTED-UNICODE\ms4bilangConso.db" ; 
 
   ConnectDB {Ms4DB} (Lcurrentdb); 
  FormShow : DrawGrid, title :"MS4 DB : ms4LangConsolidation China/Japan : Relation -> ?? = b.city  " 
  use   View  ("[ms4LangConsolidation]")  ;


	

Example 2 ADO DB

 
 ConnectDB{Ado:"xls"}( LFile1Excel);
     display "insert Table Japanese : CONSOLIDATION 1  ";
       Ms4_SQL{Ado:"xls"}(" SELECT  * into " + " %s " + "  from  [中国最大の都市のリスト$] ", Table1SheetJapanese) return x ;
 	 

Example 3 ODBC DB

 
 ConnectDB{xls}( LFile1Excel);
     display "insert Table Japanese : CONSOLIDATION 1  ";
       Ms4_SQL{ xls}(" SELECT  * into " + " %s " + "  from  [中国最大の都市のリスト$] ", Table1SheetJapanese) return x ;
 	 

Example 4 SAPLOGON

 
BEGIN ** Declare SAPLOGON
 	** Server/host ID system
		SetHost{SAPLOGON}("yourServer");
		SetSystemNumber{SAPLOGON}("02");
	** Mandant
		SetClient{SAPLOGON}("800");
	
		SetUID{SAPLOGON}("username"); 
		SetPWD{SAPLOGON}("password"); 
	** language
		setLang{SAPLOGON}("EN");
			ConnectDB{SAPLOGON} return MsgConnect ;
      		  if(MsgConnect > 0)
      		  then display "EXIT PGM" ; 
      		        Exit;
              End_if;
 END ;

BEGIN  **
  	display "IMPORTANT Create   MS4 CUBE  for   Input DATA :  CHART : PIE, BAR, DASHBOARD, REPORTING ..",LEnvDemoSAPT001DB ;
  			 Ms4_Query  {SAPLOGON}  IMPORT  : New Ms4Db  
             BEGIN  
        		 	  ConnectDB {Ms4DB} (LEnvDemoSAPT001DB)   , 
		    		  Create:table("SapT000T001Conso") 
             END 
			  (" SELECT * from t000,t001 where   t001.mandt = t000.mandt ") return (msgsql)  ;

Example 5 DSN ORACLE

 
BEGIN  Declare  DSN
 	SetDsnName{DsnOdbc}("DSNyourName");
	** Name DB
	ConnectDB{DsnOdbc}("DEV");
	
	SetUID{DsnOdbc}("YourDBName"); 
	SetPWD{DsnOdbc}("yourPasswordDBName");  
END;

BEGIN  ** SQL
 
	** SQL
	 Ms4_Query: Win{DsnOdbc}(" SELECT * from t001 where rownum < 50 ") return (msgsql)  ; ** LIMIT not exist SQL oracle

ADO prerequisites

- You must have OFFICE 97 (32 bits)
- or you must install AccessDatabaseEngine-EN-2007-32bit.exe
as specified when installing MS4BI
- or run AccessDatabaseEngine-EN-2007-32bit.exe voir : driver\MondaySoftware\DataEngineInstall
IMPORTANT: if you have a later OFFICE version than 97, installation of dataAccessDatabaseEngine-EN-2007-32bit
will have no negative impact on your current OFFICE configuration

SAPLOGON prerequisites

You must have a user logon and password that is recognised by your SAP system.
The SAP system must be accessible via a SAPLOGON installed on your PC
IMPORTANT: you must install an abap BAPI on your SAP system : this is only available with an ENTERPRISE MS4BI Licence. .

DSN ORACLE prerequisite

- You must have a user logon and password that is recognised by your CENTRAL database to install the DSN via ODBC
- You must install Oracle Client on your computer ( see win32_11gR2_client on the Oracle website, it's the Oracle version of our tests )

Remarks

DRIVER :
MS4
ODBC
ADO :string : the ADO connectors must be present in the directory :

driver:\MondaySoftware\MS4BI\zDriversADO

See also

Examples of ADO connections to: Access, BDF, Excel, TXT, CSV

driver:\MondaySoftware\MS4BI\zConnectors-ADO

See also

Examples of ODBC connections to: Access, BDF, Excel, TXT, CSV, DBASe, FOXPRO

driver:\MondaySoftware\MS4BI\zConnectors-ODBC

See also

Examples of SAPLOGON and DSN connections:

driver::\MondaySoftware\MS4BI\03-DEMO-DESKTOP-BI-SAP

See also

ALL Examples Imports/connections :

driver::\MondaySoftware\MS4BI\zConnectorsx-Import\Examples

See also

IMPORT NEW DB, DBEXIST, DBCREATE, DBCONNECT, DBDELETE,DBCLOSE, TABLEEXIST,VIEWEXIST, MS4_SQL, EXPORT_TABLE, EXPORT_SCHEMA, DESTROYENVSQL



Interested in our project? contact@monday-software.com
The Monday Software team


Copyright 2019 by Monday Software

the official sites :
www.monday-software.com
www.ms4bi.com
demos.ms4bi.com
getms4bi.com
getms4bifree.com
cloud.ms4bi.com
cloud.testing.ms4bi.com
www.ms4script.com

Our purpose : Keep it simple !


written with ms4script
  • MS4BI v.00.0005.02.2019
  • MS4BIRE v.00.0005.02.2019
  • MS4SCRIPT v.00.0005.02.2019
  • help 02/2019

MS4BI in 5 minutes