amplixbi documentation

Welcome! This is the documentation for amplixbi 3.7.4.

System Architecture and Installation:

System Requirements

Metadatabase configuration

Optional R Statistics Analysis Installation

Meta database table information

Server Load Testing with Apache Jmeter

Installation Steps

Configuration Property file

Server directory structures

Metadata analysis examples

Docker image installation

System Administration Guide:

System Management Modules

Content version management and recovery

User and Role management

Data Analysis:

Data analysis development processes

Database Connection

Business Object :

Table Registration

Inline View SQL

Relational Table Relation Diagrams:

Automatic Joining

Example relational diagram..

Create Relationship Diagram..

How to simplify model

Analysis Metrics:

Micro Chart Dimension

Custom Dimension

Formula Measure

User Defined Grouping Dimension

Advanced Topics on Analysis:

Grid Styles	Ranges and Highlight Options
Code Mapping	Global variables for analysis

Creating Report

Result formula on Reports

Formatting and Styles on result grids

Pivot table with variations

Layouting Sheets in Report

Prompt vs. Data Filtering

Interactive dashboard building

Drill Filtering to Detail reports

Reporting for Business

Drill data through reports

Reporting with Formulas

Layouting Filter Prompt

Result Filtering with Page Filter Widget

Configuring Sheet to Sheet filtering

Chart Visualization:

Chart Drill Down

Data Visualization Charts:

Training and Tutorials:

Sales status using Inline SQL

Custom Chart API Developer Guide:

Advanced Statistical Analysis:

Scheduling Report as background process:

Export with Template:

Export with Office Templates

Export with Jasper Report

Data Mashing:

Python Integrated Environment :

Install Jupyer Notebook

Scripting Jupyter Report

Create Jupyer Report

Oracle JD Edwards Data Integration:

Single Sign On (SSO) Module Development Guide:

SSO System flow

SSO Implementation (Java Class Development)

SSO Server Settings

SSO step by step implementation guide