Videos

Click&DECiDE Video List

• Click&DECiDE BAI Video
  1. Global video presentation
  2. SAP video presentation
  3. AS/400,iSeries video presentation
  4. Click&DECiDE BAI video tutorials
     • Working with Administration Manager
     • Working with Queries
     • Working with Reports
     • Working with Excel
     • Working with QlikView
• Click&DECiDE NSI Video

Start the video and play it in full screen in 720HD format using the control on the bottom right of your screen: 

Click&DECiDE BAI Video

Global video presentation

• Click&DECiDE : the Business Intelligence Data Hub (part 1)
  1. Create a Query with filters and user selection
  2. Create a Report with break and graph
  3. Create a Cube with grid and graph
• Click&DECiDE : the Business Intelligence Data Hub (part 2)
  1. Access the report through the webportal
  2. Schedule the Report
  3. Access the Cube through the webportal
  4. Get the data an Excel
  5. Link the data inside Qlikview
  6. Create a Excel Power Pivot

Click&DECiDE : the Business Intelligence Data Hub (part 1)

Click&DECiDE : the Business Intelligence Data Hub (part 2)

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 SAP

Build an Ad-hoc query in SAP with Click&DECiDE

Build a Cube from a SQ01 SAP query with Click&DECiDE

Customer Case : Sales Report on SAP ECC6 SQ01 Query (presentation in french)

AS/400,iSeries video presentation

The video will be available soon - stay tune !

Click&DECiDE BAI video tutorials

Working with Administration Manager

• Click&DECiDE connection to SAP
  1. Creating a New Data Source
  2. Configuring a SAP Data Source
• Setting Up Data Distribution by Area
  1. Changing Web portal Authentication mode
  2. Create user Groups
  3. Modify user Properties
  4. Create Web Portal menu
  5. Set Distribution Parameter in the Query

Click&DECiDE connection to SAP

Setting Up Data Distribution by Area

Working with Queries

• Click&DECiDE - Beginning to Work with the Queries
  1. Create a Query and Select the Tables from your Database
  2. Join the Fields
  3. Select the Fields from the Tables
  4. Change the Format of the Date and Numeric Fields
  5. Set Criteria
• Click&DECiDE - Working with Query Parameters (1)
  1. Set the Automatic Parameter with List of Values
  2. Updating a Parameter with Input List Method
  3. Updating a Parameter with Input Query List Method
• Click&DECiDE - Working with Query Parameters (2)
  1. Updating a Parameter using a Formula
  2. Using Dynamic Top with Parameters
  3. Updating parameter using query
• Click&DECiDE - apply the aggregate functions and create a formula
  1. Using aggregate functions
  2. Working with Virtual and Calculation Fields

Click&DECiDE - Beginning to Work with the Queries

Click&DECiDE - Working with Query Parameters (1)

Click&DECiDE - Working with Query Parameters (2)

Click&DECiDE - apply the aggregate functions and create a formula

Working with Reports

• Click&DECiDE – Create a Report
  1. Create a report
  2. Arrange the General Blocks and Fields
  3. Format the Text and Background
  4. Create a Static text
  5. Insert a Graph

Click&DECiDE – Create a Report

Working with Excel and QlikView

• Click&DECiDE Integration with QlikView and Microsoft Excel
  1. Export Data in QlikView
  2. Export Data in Power Pivot from Microsoft Excel

Click&DECiDE Integration with QlikView and Microsoft Excel

Click&DECiDE NSI Video

• Click&DECiDE NSI for Proxy
• Click&DECiDE NSI for Qosmos

Click&DECiDE NSI for Proxy

Click&DECiDE NSI for for Qosmos