Thứ Hai, ngày 05 tháng 1 năm 2015

Migrating HSQLDB to MySQL

HSQLDB migration to MySQL is not out of the box supported by mysql. The MySQL Workbench can only handle with dumps made by other mysql server. HSQLDB Transfer Tool is no longer bundled with the standard hsqldb jar file in the 1.8.x or later releases. After downloading and building with
ant hsqldbutil
you get in lib an additional hsqldbutil jar. With the hsqldb.jar, the hsqldbutil.jar and and mysql connector jar in my classpath i tried the Database Manager (From Tools menu choose transfer) from hsql with no luck. The MySQL Migration Toolkit has reached the EOL phase but works perfect for me. After downloading add the hsqldb jar to the lib folder C:\Program Files (x86)\MySQL\MySQL Tools for 5.0\java\lib. I update as well the mysql connector to the latest one.
  1. Start your hsqldb server from command line
    1. java -cp hsqldb-1.8.0.10.jar org.hsqldb.Server -database \
  2. Start MySQL Migration Toolkit
  3. Choose direct migration
  4. Choose as Source a generic jdbc
  5. Enter “org.hsqldb.jdbcDriver” as classname
  6. Enter “jdbc:hsqldb:hsql://localhost” as connection string
  7. Enter “sa” as username and leave password empty
  8. click next
  9. Configure your mysql connection
  10. click next
  11. choose public as schema
  12. click next several time till screen “object creation options”
  13. choose “create script file..” instead of “create objects online”
  14. click next several time till screen “data mapping options”
  15. choose “create script file..” instead of “transfer data online”
  16. click next several time till screen “Summary”
  17. click finish
With the sql you can use tools like phpmyadmin or the mysql workbench to import your data into the mysql server.

Thứ Năm, ngày 01 tháng 1 năm 2015

10+ Free Open Source BPM Platforms

10+ Free Open Source BPM Platforms

link (http://butleranalytics.com/10-free-open-source-bpm-platforms/)
People have always created and modified business processes, but until business process management (BPM) tools became available it was often an informal and fairly ad-hoc procedure. There is nothing particularly complex about BPM, despite the unnecessarily elaborate terminology. In essence it provides a language for people to design, analyse, build, modify and discuss business processes. And it also creates a bridge between the process and systems used to implement it – assuming technology is a factor, as it nearly always is.
The business process management cycle starts with analysis and design – as do all creative projects. A diagramming notation is used to show the activities, routing and messages involved in a process – usually based on the BPMN (Business Process Model and Notation) standard. Business Process Management Systems (BPMS) provide a framework for these activities and a variety of tools to help in the design, implementation and monitoring of business processes. During the design and analysis phase a BPMS usually allows a design to be simulated, so that any undesirable side effects can be detected.
If a business process is to be more than just a diagram it needs to be plugged in to the operational systems. To this end BPMS offer connectors to various applications and support for methods such as Service Oriented Architectures (SOA), where existing systems can be made to behave as a set of services which a business process uses. Obviously this can become fairly technical – but no more than any other system implementation.
Finally we are ready to put the business processes into production where process instances (individual transactions and workflows) are handled. An essential part of this is the creation of a log of all process activities – invaluable material for the next phase.
Evaluating the performance of processes is a major benefit of a BPMS. The logs created during process execution can be interrogated to identify bottlenecks, loopholes, inefficiencies and any other form of poor performance. To this end process mining is a relatively new addition to many BPMS, where logs are interrogated for patterns of behaviour which are sub-optimal.
Of course this is just a brief over-view, and depending on the size of the organisation the whole process can become quite involved with thousands of processes having to be orchestrated. Even so these basic principles still apply.
Activiti is a light-weight workflow and Business Process Management (BPM) Platform targeted at business people, developers and system admins. Its core is a super-fast and rock-solid BPMN 2 process engine for Java. It’s open-source and distributed under the Apache license. Activiti runs in any Java application, on a server, on a cluster or in the cloud. It integrates perfectly with Spring, it is extremely lightweight and based on simple concepts.
Activiti supports all aspects of Business Process Management (BPM) in the full context of software development. This includes non technical aspects like analysis, modeling and optimizing business processes as well as technical aspects of creating software support for business processes. Activiti recognizes that BPM as a management discipline is a completely different aspect then BPM as software engineering.
Activiti’s primary purpose and focus is to implement the general purpose process language BPMN 2.0. And there is no single process language that can cover all the use cases well. In many cases a custom dedicated process language makes sense. So at the core, Activiti has the Process Virtual Machine architecture. That means that any custom process language can be build on top of it.
Bonita BPM improves business operations by connecting people, processes, and information systems into easily managed applications. Use Bonita Studio to map the organization, define the data structure, build the user interface, and create actionable reports. Bonita Portal creates a central location to perform tasks, monitor case completion, search for information, and collaborate with peers.
Camunda is an open source platform for workflow and business process automation. It executes BPMN 2.0, is very light-weight and scales very well. Camunda is written in Java and a perfect match for Java EE and Spring while providing a powerful REST API and script language support. You can use camunda BPM for system integration workflows as well as for human workflow and case management.
You can add camunda to your Java application as a library. You can also use it as a container service in Tomcat, JBoss etc., so it can be used by multiple applications which can be redeployed without shutting down the process engine. Some of the biggest companies in the world and most trusted public institutions rely on camunda.
Intalio bpms provides a comprehensive enterprise-class platform to design, deploy, and manage the most complex business processes; over 1000 organizations world-wide in all industries rely on the technology to manage their mission-critical business processes. Intalio bpms features an intuitive and powerful visual designer and a reliable high-performance process execution server. It also includes enterprise-level capabilities such as business activity and metrics monitoring, business rules and decision management, document management, mobility support, and system integration tools and portals.
jBPM is a flexible Business Process Management (BPM) Suite. It makes the bridge between business analysts and developers. Traditional BPM engines have a focus that is limited to non-technical people only. jBPM has a dual focus: it offers process management features in a way that both business users and developers like it. The core of jBPM is a light-weight, extensible workflow engine written in pure Java that allows you to execute business processes using the latest BPMN 2.0 specification. It can run in any Java environment, embedded in your application or as a service.
jSonic BPM suite enables enterprise owners to align business processes with the dynamic market conditions, statutory compliances and, customer and partner requirements. It is a comprehensive solution that improves the bottom line of organization by increasing process efficiency, optimizing resource utilization and automating human workflow system.
jSonic BPM suite, the Open Source BPM Software offers an all-encompassing solution covering process designing, modeling, executing, automating and monitoring as per the business needs and wants. The major components of the suite include Process Management, Workflow Management and the Interface Designer.
Orchestra is a complete solution to handle long-running, service oriented processes. It provides out of the box orchestration functionalities to handle complex business processes. It is based on the OASIS standard BPEL (Business Process Execution Language). Orchestra’s objectives:
  • Improvement and control of processes
  • Services interaction
  • Productivity and agility of the company
Orchestra is fully Open Source and is downloadable under the LGPL License.
ProcessMaker is a cost effective and easy to use open source business process management (BPM) or workflow software application. Workflow software such as ProcessMaker can assist organizations of any size with designing, automating and deploying business processes or workflows of various kinds.
ProcessMaker workflow software features an extensive toolbox which provides the ability to easily create digital forms and map out fully functioning workflows. The software is completely web based and accessed via any web browser, making it simple to manage and coordinate workflows throughout an entire organization – including user groups and departments. ProcessMaker workflow software can also interact with other applications and systems such as ERP, business intelligence, CRM and document management.
Red Hat JBoss BPM Suite is the JBoss platform for Business Process Management (BPM). It enables enterprise business and IT users to document, simulate, manage, automate and monitor business processes and policies. It is designed to empower business and IT users to collaborate more effectively, so business applications can be changed more easily and quickly. Create, test, deploy and monitor BPMN2-based business processes to optimize enterprise workflows and automate critical processes. Includes all the business rules and event processing capabilities of Red Hat JBoss BRMS. Easily create real-time dashboards to monitor key performance indicators for running processes and activities.
Talend’s BPM products enable managers, business analysts, developers and end users to model current processes, collaborate on improvements, and rapidly create and optimize process-driven solutions in minutes. Talend combines three solutions in one: an innovative process modeler, a powerful BPM and workflow engine, and a breakthrough user interface for the creation of forms. You can create human interactive or process-based applications, and automate and optimize business processes in a single day.

How to design and develop an interactive Cockpit or Dashboard in SpagoBI?

How to design and develop an interactive Cockpit or Dashboard in SpagoBI?

To design and develop interactive cockpit in SpagoBI, we would need the following:
  1. A document of Type “Document Composite” and Engine “Document Composition Engine”.Notes: Make sure the engine has been configured in “Resources->Engines Management page. It can be configured while installing SpagoBI 3.4 (latest version) from windows installer.
  2. The XML file to design/develop the view and navigation of our cockpit. This is an xml template that we can write only by hand now but in future it will be written by wizard.
Interactive Cockpit Template Detail
This tag defines a template that will be used for rendering documents. It’s a standard template and must not be changed.
This tag defines the size of the video/view, we can have size in percentage mode as well (the alternative is pixel). When not defined the default values are 1024 x 768.
There is a block for every document that we would like to view/present in our cockpit/dashboard. We can add as many document tags as we need depending upon our views requirements. There is no limit and so we can create a composite document with 2,3,4,6, … sub-documents and everyone can shows different layout. The only limit is our common sense, because see too many documents can create confusion rather than help the data analysis.
sbi_obj_label defiines the label  by which the document is saved into SapgoBI.

SpagoBIMobileEngine: Bringing Business Intelligence to mobile devices

SpagoBIMobileEngine: Bringing Business Intelligence to mobile devices

It is not surprising for Business owners to think of taking business decisions right from their gadgets with which they spend most of their time these days. Be it I-Pads, Tablets or the Smart phones, they are all part of our life now. What if those BI Reports you see in your browsers are made available on your I-Pad!…. I know you must be thinking there are many such applications, but what about an Open Source application which has provision for rich controls.
   
In this Blog, lets have a look at SpagoBIMobileEngine, one of the latest offerings of the new version of SpagoBI 3.4.
Now we can display our BI reports on mobile devices. This new component allows us to deploy the analysis available in SpagoBI suite onto mobile devices, such as smartphones and tablets, using original types of reports, graphs and interactive cockpits.
We have following three features added by SpagoBI for mobile so far:
  1. Mobile Table: gives a tabular layout to data loaded from the associated dataset
  2. Mobile Chart: displays Sencha-Touch charts over dataset data
  3. Mobile Cockpit: composes charts and reports in a single layout, within the possibility for each document to interact with the others, passing them parameters
Here is our first experience in creating different kind of reports provided by SpagoBIMobileEngine.
Develop Mobile Table
Please follow the steps below to develop mobile table:
  1. Create an analytical document with the following required information:
    1. Label: the label of the document
    2. Name: Name of the document.
    3. Type: Mobile Report
    4. Engine: Mobile Report Engine
    5. Data Source: your data source, e.g. foodmart.
    6. Dataset: locate the dataset for which you would like to develop table.Notes: Make sure the engine has been configured. This is configured by default with version 3.4.
  2. Locate and upload the document template (.xml) file.
Details on the document template
This is the start of the table chart template.
          </p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 30px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> This tag is used to show title on the chart, we can change the style tag to change the visibility of the title on page.</p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 30px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> <columns></p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 30px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> This is start of the table column tag. We can have more than one columns depending upon our requirements.</p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 30px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> <column header=”Product Category” value=”ProdCategory” style=”font-weight: bold; text-align: center;” /></p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 30px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> Column header is the header of column and value is the dataset field name.</p> <p style="margin-bottom: 10px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;">           Use the following tag in case you would like to link this chart to another document (cross navigation).</p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 30px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> <drill document=”Mobile_Chart_LC1″></p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 60px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> <PARAM  name=”ProdCategory” type=”SERIE”/></p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 30px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> </DRILL></p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 30px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> Here the document references the target document label and for each parameter, it is necessary to define the name (url) of the target parameter and the type of it.</p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 30px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> The type can assume next values:</p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 30px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> CATEGORY: pass the category’s value selected.</p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 30px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> SERIE: pass the serie’s value selected.</p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 30px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> ABSOLUTE: pass the constant defined into the value property.</p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 30px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> RELATIVE: pass the value of the parameter presents in the request with the name defined in the same property.</p> <p style="margin-bottom: 10px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;">      3. Save and execute the document.</p> <p style="margin-bottom: 10px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> <strong style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline;">Develop Mobile Chart</strong></p> <p style="margin-bottom: 10px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> Please follow the steps below to develop mobile table:</p> <ol style="margin: 0px 0px 10px 3em; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline; list-style-position: initial; list-style-image: initial;"> <li style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline;">Create an analytical document with the following required information:<ol style="margin: 0px 0px 0px 1.5em; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline; list-style-position: initial; list-style-image: initial;"> <li style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline;">Label: the label of the document.</li> <li style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline;">Name: Name of the document.</li> <li style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline;">Type: Mobile Chart</li> <li style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline;">Engine: Mobile Chart Engine</li> <li style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline;">Data Source: your data source, e.g. foodmart.</li> <li style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline;">Dataset: locate the dataset for which you would like to develop table.Notes: Make sure the engine has been configured. This is configured by default with version 3.4.</li> </ol> </li> <li style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline;">Locate and upload the document template (.xml) file.</li> </ol> <p style="margin-bottom: 10px; padding: 0px 0px 0px 30px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> <strong style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline;">Details on the document template</strong></p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 30px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> <strong style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> </strong><strong style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline;">Bar Chart</strong></p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 30px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> <CHART_WIDGET  width=’320′ height=’480′></p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 30px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> The width and height of the chart, we can have this value either in pixel or, percentage.</p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 30px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> <title value=’Sales and Costs’>
Title of the bar chart document.
This is for legend where we set the position of the legend, one can comment this line in case they do not want to have legend on the page.
Display the value of the numeric control as we move the slider or needle.
This is animate configuration tag, which shows motion effect.
Other easing values, but I have no idea if SpagoBI supports all of these:
bounceIn, bounceOut, bounceInOut, elasticIn, elasticOut, elasticInOut, linear, quadIn, quadOut, quadInOut, cubicIn, cubicOut, cubicInOut, easeIn, easeOut, easeInOut, quartIn, quartOut, quartInOut, quintIn, quintOut, quintInOut, sineIn, sineOut, sineInOut, expoIn, expoOut, expoInOut, circIn, circOut and circInOut
SALES
COSTS
X
Configure series and axes to set/display fields on X and Y axis.
Interaction configuration, The PanZoom interaction allows the user to navigate the data for one or more chart axes by panning and/or zooming.
Pie Chart
Set the width and height of the pie chart.
The title of the document.
Legend configuration.
Configure interactions, type=rotate will rotate the chart with touch.
true
Set animation as true.
Configure series to set/display fields in pie chart.
End of the widget.
Line Chart

Set the width and height of the pie chart.
Set the title of the document.
Configure legend position.
Animate configuration same as above.
value1
value2
month
Configure series and axes to set/display fields on X and Y axis.
Interaction configuration, The PanZoom interaction allows the user to navigate the data for one or more chart axes by panning and/or zooming.
      3. Save and execute the document.
Develop Mobile Cockpit
Please follow the steps below to develop mobile table:
  1. Create an analytical document with the following required information:
    1. Label: the label of the document.
    2. Name: Name of the document.
    3. Type: Mobile Cockpit
    4. Engine: Mobile Cockpit EngineNotes: Make sure the engine has been configured. This is configured by default with version 3.4.
  2. Locate and upload the document template (.xml) file.
Details on the document template

</span></p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 30px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> Configure the title of the document.</p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 30px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> <documents></p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 30px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> This is the start of the document tag. There is a block for every document that we would like to view/present in our cockpit/dashboard. We can add as many document tags as we need depending upon our views requirements. There is no limit and so we can create a composite document with 2,3,4,6, … sub-documents and everyone can shows different layout. The only limit is our common sense, because see too many documents can create confusion rather than help the data analysis.</p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 30px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> <document label=”Mobile_Chart_Pie3″ width=”45%” height=”100%”></p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 30px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> Label defines the label  by which the document is saved into SapgoBI.</p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 30px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> </DOCUMENT></p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 30px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> <document label=”Mobile_Table2″ width=”45%” height=”100%”></p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 60px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> <in_parameters></p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 90px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> <parameter urlName=”ProdCatType” defaultValue=”CATALOG_CATEGORY”/></p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 90px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> <parameter urlName=”ProdCategory” defaultValue=”CPUps”/></p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 60px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> </IN_PARAMETERS></p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 30px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> </DOCUMENT></p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 30px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> This is the configuration of the input parameters, urlName is the <em style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline;">label</em> by which the parameter is saved into SpagoBI (the url in detail document section) and defaultValue is a value that the engine pass to the document if is not found explicitly in the url.</p> <p style="margin-bottom: 10px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;">       3. Save and execute the document to show the composed view.</p> <p style="margin-bottom: 10px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> <strong style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline;">Others clarifications:</strong></p> <p style="margin-bottom: 10px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> In case the documents have cross navigation defined separately, the composed document will be shown as interactive, we do not need to define it in Cockpit. This should be defined in separate document with the following tags:</p> <p style="margin-bottom: 10px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> <drill document=”Mobile_Chart_LC1″></p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 30px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> <PARAM  name=”ProdCategory” type=”SERIE”/></p> <p style="margin-bottom: 10px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> </DRILL></p> <p style="margin-bottom: 10px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> Here the document references the target document label and for each parameter, it is necessary to define the name (url) of the target parameter and the type of it.<br style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-size: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px !important; box-sizing: border-box;">The type can assume next values:</p> <p style="margin-bottom: 10px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> CATEGORY: pass the category’s value selected.</p> <p style="margin-bottom: 10px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> SERIE: pass the serie’s value selected.</p> <p style="margin-bottom: 10px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> ABSOLUTE: pass the constant defined into the value property.</p> <p style="margin-bottom: 10px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> RELATIVE: pass the value of the parameter presents in the request with the name defined in the same property.</p> <p style="margin-bottom: 10px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> <strong style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline;">Attachments  & References</strong></p> <ol style="margin: 0px 0px 10px 3em; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline; list-style-position: initial; list-style-image: initial;"> <li style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline;">SpagoBIMobile uses Sencha touch chart for rendering the charts, so please refer document on Sencha website i.e.<a href="http://www.sencha.com/products/touch/charts" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline; text-decoration: none; color: rgb(244, 71, 58);">http://www.sencha.com/products/touch/charts</a> for details.</li> <li style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline;">SpagoBI Wiki, <a href="http://www.spagoworld.org/xwiki/bin/view/SpagoBI/MobileBI" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline; text-decoration: none; color: rgb(244, 71, 58);">http://www.spagoworld.org/xwiki/bin/view/SpagoBI/MobileBI</a></li> <li style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline;">Enclosed please find sample document template for Mobile Table, Bar chart, Pie Chart, Line Chart and Cockpit at <a href="http://paxcel.net/blog/wp-content/uploads/2012/06/SpagoBI.rar" target="_blank" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline; text-decoration: none; color: rgb(244, 71, 58);">http://paxcel.net/blog/wp-content/uploads/2012/06/SpagoBI.rar</a></li> </ol> </div> <footer class="entry-meta" style="margin: 25px 0px 0px; padding: 0px; border: 0px; font-family: Oxygen, sans-serif; font-size: 12px; font-weight: bold; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline; color: rgb(96, 96, 96); background-color: rgb(255, 255, 255);">This entry was posted in <a href="http://paxcel.net/blog/category/bi/" rel="category tag" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline; text-decoration: none; color: rgb(244, 71, 58);">BI</a>, <a href="http://paxcel.net/blog/category/paxcellabs/" rel="category tag" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline; text-decoration: none; color: rgb(244, 71, 58);">Paxcel Labs</a> and tagged <a href="http://paxcel.net/blog/tag/develop-bar-chart-in-spagobi/" rel="tag" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline; text-decoration: none; color: rgb(244, 71, 58);">Develop bar chart in SpagoBI</a>, <a href="http://paxcel.net/blog/tag/develop-business-intelligence-report-in-spagobi-for-mobile-devices/" rel="tag" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline; text-decoration: none; color: rgb(244, 71, 58);">develop business intelligence report in SpagoBI for mobile devices</a>, <a href="http://paxcel.net/blog/tag/develop-line-chart-in-spagobi/" rel="tag" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline; text-decoration: none; color: rgb(244, 71, 58);">Develop Line Chart in SpagoBI</a>, <a href="http://paxcel.net/blog/tag/develop-mobile-charts-in-spagobi/" rel="tag" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline; text-decoration: none; color: rgb(244, 71, 58);">Develop mobile charts in SpagoBI</a>, <a href="http://paxcel.net/blog/tag/develop-mobile-interactive-cockpits-in-spagobi/" rel="tag" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline; text-decoration: none; color: rgb(244, 71, 58);">Develop mobile interactive cockpits in SpagoBI</a>,<a href="http://paxcel.net/blog/tag/develop-mobile-tables-in-spagobi/" rel="tag" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline; text-decoration: none; color: rgb(244, 71, 58);">Develop mobile tables in SpagoBI</a>, <a href="http://paxcel.net/blog/tag/develop-pie-chart-in-spagobi/" rel="tag" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline; text-decoration: none; color: rgb(244, 71, 58);">Develop Pie Chart in SpagoBI</a>, <a href="http://paxcel.net/blog/tag/spagobi-mobile/" rel="tag" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline; text-decoration: none; color: rgb(244, 71, 58);">SpagoBI Mobile</a>, <a href="http://paxcel.net/blog/tag/spagobi-on-ipad/" rel="tag" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline; text-decoration: none; color: rgb(244, 71, 58);">SpagoBI on IPAD</a>, <a href="http://paxcel.net/blog/tag/spagobi-on-iphone/" rel="tag" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline; text-decoration: none; color: rgb(244, 71, 58);">SpagoBI on IPhone</a>, <a href="http://paxcel.net/blog/tag/spagobi-on-mobile-devices/" rel="tag" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline; text-decoration: none; color: rgb(244, 71, 58);">SpagoBI on Mobile devices</a>, <a href="http://paxcel.net/blog/tag/spagobimobileengine/" rel="tag" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline; text-decoration: none; color: rgb(244, 71, 58);">SpagoBIMobileEngine</a>. Bookmark the <a href="http://paxcel.net/blog/spagobimobileengine-bringing-business-intelligence-to-mobile-devices/" title="Permalink to SpagoBIMobileEngine: Bringing Business Intelligence to mobile devices" rel="bookmark" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline; text-decoration: none; color: rgb(244, 71, 58);">permalink</a>.</footer></div>