MS4BI® - Mandragore System 4gl Business Insights -

Business Intelligence Reinvented: Simple, Effective, Powerful, and Affordable.

  • Create Windows and Web applications with real-time data updates for always relevant and up-to-date information.
  • Boost your productivity with MS4Script: low code, maximum results, minimum effort.
  • Lightweight, intuitive, and fully responsive for an optimal user experience, from analysis to interaction.

Make your data speak and make decisions that matter. Turn your information into concrete and impactful results.

Try it now!
MS4BI_Team

MS4BI : DASHBOARD

      

Data visualisation

Creates a TABstrip type dashboard, including charts and reports

Syntax

   	
	
	  BEGIN_DASHBOARD  
		option :
		BEGIN
		type  : $TABSTRIP , 	  	title :   ""  
		END
		TabTitle Optinal.. 
		TabTitle : 'title 1   ',   Ms4Script_Import : ....... 
	  	TabTitle : 'title 2  ',    FormMS4 :  DrawGrid  .......    
						FormPlus : theme : "blueopal"	DrawPIE....... 
		TabTitle : "title 3   " ,  FormPlus : theme : "bootstrap" DrawRADAR, .......   
	 
			....      
	 END_DASHBOARD ;  	
	

Example 1

Dashboard Tabstrip

DASHBOARD : ANALYSIS BUSINESS 2011
  • Bar
  • Pie
  • Grid
  • My Business 2011
  • Aggregate
  • Design
2-BAR VERTICAL : Business 2011 by EMPLOYEE
MS4BI®
1-PIE Business 2011 by EMPLOYEE
3-GRID : BUSINESS EMPLOYEE 2011 $
EXCEL Informations and Consolidation :
REPORT EMPLOYEE orders BY SHIP COUNTRY

EXCEL Informations and Consolidation : REPORT EMPLOYEE orders BY SHIP COUNTRY
Generate by Mandragore Planete

Mandragore Planete - Trial Version : BUSINESS 2011 Report : Employee by Country, By Orders

07/07/2314:08:36
##Break Employee : 1 Davolio Total Price Units : 1691.40 Total Quantity : 1620.00 Total business : 38789.00total Orders: 26 Total country 14
##Break Employee : 2 Fuller Total Price Units : 822.20 Total Quantity : 1085.00 Total business : 22834.70total Orders: 16 Total country 9
##Break Employee : 3 Leverling Total Price Units : 812.60 Total Quantity : 940.00 Total business : 19231.80total Orders: 18 Total country 12
##Break Employee : 4 Peacock Total Price Units : 2340.40 Total Quantity : 2212.00 Total business : 53114.80total Orders: 31 Total country 14
##Break Employee : 5 Buchanan Total Price Units : 701.70 Total Quantity : 778.00 Total business : 21965.20total Orders: 11 Total country 8
##Break Employee : 6 Suyama Total Price Units : 778.30 Total Quantity : 963.00 Total business : 17731.10total Orders: 15 Total country 10
##Break Employee : 7 King Total Price Units : 631.10 Total Quantity : 455.00 Total business : 17864.80total Orders: 11 Total country 8
##Break Employee : 8 Callahan Total Price Units : 1352.30 Total Quantity : 923.00 Total business : 23161.40total Orders: 19 Total country 11
##Break Employee : 9 Dodsworth Total Price Units : 272.20 Total Quantity : 575.00 Total business : 11365.70total Orders: 5 Total country 5

TOTAL ORDERS: 152

TOTAL EMPLOYEE: 9

$TOTAL03: Business
226058.50$

$TOTAL01: Price Unit
9402.20$

$TOTAL02: qte
9551.00

Definition

Creates a non-tabstrip style dashboard, including charts and reports

Syntax

   	
	BEGIN_DASHBOARD  
		option :
		BEGIN
		type  :  $NOTABSTRIP  , 	  	title :   ""  
		END
		TabTitle : 'title 1   ',  Ms4Script_Import : ....... 
	  	TabTitle : 'title 2  ', FormMS4 :  DrawGrid  .......    
		 FormPlus : theme : "blueopal"	DrawPIE....... 
		TabTitle : "title 3   " ,   FormPlus : theme : "bootstrap" DrawRADAR, .......   
			....      
	END_DASHBOARD ;  	
	

Example 2

Dashboard non-tabstrip

1-PIE Business 2011 by EMPLOYEE
2-BAR VERTICAL : Business 2011 by EMPLOYEE
Creates an RWD type dashboard including charts and reports (RWD : RESPONSIVE WEB DESIGN)

Syntax

   	
	
Use RESPONSIVE (RWD) instructions :
RWD_ROW,RWD_COL,<DIV... 	
SEE HELP UI
	

Example 3

  		   
<Rwd_Row    :  2 /* 2 : optional */
    <Rwd_Col :   lg:4 ,"text-left" :  
            <div $widget + $bg_primary + "no-padding" :
                <div  "class='p-m " :
                     <Text : ""     , "    Population by Province   " > ,
                     <Text :  ""     , "  China    " > ,
                >  /* end div */
                           DBconnect {Ms4DB} (Lcurrentdb) ,
                           FormMorris :  DrawPIE,   title :"" ,  
                           TYPE : $DONUT, FORMAT: "Th"  use View  ("[ms4TotalPopulByProvince]")   			   
            >  /* end div */
    >  /* end col lg:4 */
    <Rwd_Col :   lg:8 ,"text-left" : 
            <div $widget + $bg_info + "no-padding" :
                    <div  "class='p-m " :
                        <Text : ""     , "   Population by Province (TOP 15)     " >  
                        <Text :  ""    , "      (BAR )  " >  
                        <Text :  ""     , "   China    " >  
                     >  /* end div */
                        DBconnect{Ms4DB}(Lcurrentdb), 
                        Ms4_Query{ms4db}  option : into  $MS4DBTMP 
                       (" SELECT  *   from  [ms4TotalPopulByProvince]  order by "+
                        "TOTALThousandPopulationByProvince desc limit 15 " ) , ** TOP 15
                        DBconnect{Ms4DB}($MS4DBTMP),
                        FormMorris :	DrawBar ,  title :"" ,TYPE :  $BAR   , FORMAT :"Th"  
                        use   View  ($MS4VIEWDBTMP)  		 		>, /* end div */
        >  /* end col lg:8 */
>;  /* end Row */
	

Dashboard responsive

Widgets for example

Today’s income

$ 4,232

Today’s temperature

26'C

New messages

260

New albums

120

$ 140.000

Annual income

Income project Alpha

$ 210,660

Monthly income

Income project Beta

$ 50,992

Half-year revenue margin

Sales marketing
# Date Time Amount
fuller 10/21/2013 3:29 PM $321.33
leverling 10/21/2013 3:03 PM $724.17
Davolio 10/21/2013 3:00 PM $23.71
Peacock 10/21/2013 2:49 PM $8345.23
King 10/21/2013 2:23 PM $245.12
Callahan 10/21/2013 2:15 PM $5663.54
leverling 10/21/2013 2:13 PM $943.45

217

400

10

420

462

610

Alex Smith

Founder of Groupeq profile
100 Tweets | 350 Following | 610 Followers

Alex Smith

Lorem Ipsum is simply dummy text of the printing and typesetting industry.

456

Shield

Power

612

Thunder

amount

Janet Smith

  • Email:mike1234@mail.com
  • Address:Street 200, Avenue 10
  • Contact:(+999) 678 3462

47

Notifications

Error(s) detected’

520

Likes

xxxxx

Alarm

Do

something

TOP 5

Total messages Posts Comments
News Likes Notifications
Albums Groups Permissions
News Likes Notifications
Views Followers Charts
Memory 10/200 GB
Bandwidth 20 GB
Activity 73%


Mandragore Planete
15 rue des Halles
75001 PARIS FR
T: (+33) 1 76 46 09 83
New branches opening soon in Bordeaux FRANCE,
Montreal CANADA,
San Franscisco USA
Mediator
CMAP 39 av. Franklin D. Roosevelt
75008 PARIS FR
T: (+33) 1 44 95 11 47
consommation@cmap.fr