Skip to main content

Videos

Click&DECiDE Video List

 

Click&DECiDE BAI Video

Quick presentation

This is a quick presentation of Click&DECiDE.

 

Best BI integration with INFOR M3

  1. Integration with INFOR MASHUP
  2. Direct acces to the AS400/iSeries
  3. Full support of M3MI interface
  4. Agile ETL functionality

Click&DECiDE with INFOR M3.

 

General tutorial

How to make a query, then use it in a PDF, Excel, Google chart dashboard etc....

 

Create a query on different sources and bufferise your query

In this example we make a query on 3 differents sources (AS400, M3MI, and Excel) then we bufferise our query.

 

SAP video presentation

  • Click&DECiDE connection to SAP
    1. Create a connection to SAP Server
    2. Configure SAP BW Cube Access
    3. Configure SAP SQ01 Queries Access
    4. Configure SAP BAPI/RFC Access
  • Build an Ad-hoc query in SAP with Click&DECiDE
    1. Select from SAP connection, a BW, SQ01 or BAP SOurce to create the query
    2. Create parameters custom questions for user selection
    3. Select fileds to be shown
    4. Adapt fields format to your need
    5. Change SAP Date/Time format to a TimeStamp format for a better usage
    6. Save your query for a usage in Report, Cube, Excel export...
  • Build a Cube from a SQ01 SAP query with Click&DECiDE
    1. Select a query prepared with Click&DECiDE
    2. Create the Cube structure
    3. Select the dimensions you want to show in the grid view
    4. Select the dimensions you want to show in the chart view
    5. Save the Cube to be directly accessible in the Web Portal
  • Customer Case : Sales Report on SAP ECC6 SQ01 Query (presentation in french)
    1. Customer technical specifications
    2. SQ01 request build
    3. Click&DECiDE fields and additional filter selection
    4. Sales Cube construction and visualisation on a dozen of views
    5. Excel Powerpivot construction and visualisation for managment

Click&DECiDE connection to SAPBuild an Ad-hoc query in SAPa with Click&DECiDEBuild a Cube from a SQ01 SAP query with Click&DECiDECustomer Case : Sales Report on SAP ECC6 SQ01 Query (presentation in french)