Transcript MAIA's 1KEY Agile - Complete BI Suite

Instructions to run this Demo
• Uncheck the Check Box – ‘Always Ask Before
Opening this type of file’
• Always OPEN & do not save the file
‘1KEYAgile.ppt’
• Click on the links wherever given to view the
demo
• Press back button of the browser to come
back to the PPT once the video is played
A Preview
1KEY Agile Architecture
1KEY Server Sizing
Agile is complete SOA and being SOA it’s processing is
distributed on these kinds of Service Servers:
1KEY Meta Server: - For storing 1KEY Repository
1KEY Web Reporting Server: - For 1KEYWeb
1KEY Scheduler Server: - For Scheduling
1KEY Web Service Server: - For 1KEY Cloud Services
1KEY OLAP Server (OLAPS): - For 1KEY OLAP DW
1KEY Meta Server (MS)
1KEY Meta Server is mainly responsible for:
1)Repository
2)User Maintenance
3)Request Posting to 1KEY Web Service
Server or 1KEYWeb Server
4)Controlling 1KEY Scheduler Server
1KEY Web Service Server (WSS)
1KEY Web Service Server is responsible for
following:
1)Fetching Required Data from Database
Servers
2)Sending Request to 1KEY Client in small data
packets
3)Storing and Retrieving metadata information
to and from 1KEY Meta Server
1KEY Scheduler Server (SS)
1KEY Scheduler is responsible for following:
1)Scheduling of different kind of reports
2)Scheduling data warehousing routines
1KEY Web Reporting Server (WRS)
1KEY Web Reporting Server is responsible for
following:
1)Executing 1KEYWebView
2)Executing 1KEYWebChart
3)Executing 1KEYWebCube
4)Publishing 1KEY Reports
5)KPI & Dashboards
6)Remote Reporting Access
OLAP Server (OLAPS)
OLAP Server is responsible for following:
1) OLAP Engine for creating cubes and reporting
models.
2)OLAP Reporting Engine for transforming these
cubes and reporting models to 1KEY’s reporting
model and generate reports.
1KEYWebView
1KEYWebChart
Report
Publisher
1KEYWebCube
KPI & Dashboards
Report
Remoteing
Service
OLAP
Reporting
Engine
OLAP
Engine
OLAPS
WRS
Report Scheduler
Data Handler
Data Scheduler
Metadata Handler
Request Handler
SS
WSS
Database
Server
MS
User Maintenance
Repository
Scheduling Processor
Request Handler
Business Intelligence Software Suite
•
•
•
•
•
•
•
•
View
Cube
Chart
Dashboard
KPI
Tree
Ticker
Reporter
•
•
•
•
•
•
•
Web View
Web Cube
Web Chart
Scheduler
File Reader
Query Builder
OLAP
• 1KEY Agile has sort, filter, group by drill down
drill through reports with cross tab
functionality very similar to spreadsheets
Click on the link to see the demo
•
•
•
•
•
•
View- Auto Format Grouping
View – Email & Export
View – Formula Column
View – Interval Grouping
View – Level wise Report
View – Style condition
• 1KEY Agile has the rapid in memory cube
which converts raw data for multi dimensional
analysis
Click on the link to see the demo
•
•
•
•
•
•
•
•
•
•
•
Cube – Add / Remove
Cube with Chart
Cube – create group style condition
Cube – Email Report
Cube – Export Report
Cube – Formula Column
Cube – Interval Grouping
Cube - Multiple Total
Cube – Summary Variation
Cube – Top Values
Cube – View options
• 1KEY Agile has charts and graphs with dial,
gauges, speedometers, heat maps and many
more data visualization methods
Click on the link to see the demo
•
•
•
•
•
•
•
•
•
•
•
Creating Chart
All Chart Features
Axis Chart
Change Chart Type
Maximize Chart
Chart Color Model
Chart – Drill Down
Chart - Label Rotation
Chart – Legend
Chart – Min Max Axis range
Pie Chart – specific property
• 1KEY Agile has dashboards where users can
define their own Dashboards using wizards
Click on the link to see the demo
•
•
•
•
•
•
•
•
•
Dashboard – all features
Dashboard – Cube Drag & Drop
Dashboard – Maximize Cube Report
Dashboard – Maximize Gauge
Dashboard – Max, Min
Dashboard – Parameterized working
Dashboard – Show/Hide parameters
Dashboard – Sorting & Paging
Dashboard - Turnover
• 1KEY Agile has KPI i.e. Key Performance
Indicators where users can define their own
KPIs using wizards
Click on the link to see the demo
•
•
•
•
•
•
•
•
•
KPI – Creating Report
KPI – Parameter
KPI – Drill Down
KPI – Filter Report
KPI – Summary
KPI – Top bottom
KPI – Email Report
KPI – Export Report
KPI – Paging / Sorting
Click on the link to see the demo
• 1KEY Agile has intuitive visual data
representation of OLAP and raw data in
hierarchical tree based drill down expandable
structure
Click on the link to see the demo
• Tree – Model Creation
• Tree – Model view
• Tree – model with chart
• 1KEY Agile has ticker reporting where on the
user’s desktop important data and alerts are
flashed continuously in ticker format at
scheduled intervals
Click on the link to see the demo
• Ticker – Model 1
• Ticker - Model2
• 1KEY Agile has static reporting designing
solution for compliance and pre printed forms,
vouchers printing and viewing
Click on the link to see the demo
•
•
•
•
Reporter–selection of multiple query
Reporter – Load Report
Reporter – Hyperlink
Reporter - Saving Report Layout
• 1KEY Agile has sort, filter, group by drill down
drill through reports with cross tab
functionality very similar to spreadsheets on
web version as well
Click on the link to see the demo
•
•
•
•
•
•
•
•
1KEYWEB – Login
WebView – Drill Down Card View
WebView – Auto Filter
WebView – Style Condition
Webview – Formula Column
Webview – Email Report
WebView – Export Report
WebView – Parameterised Report
• 1KEY Agile has the same rapid in memory
cube which converts raw data for multi
dimensional analysis with web version
Click on the link to see the demo
•
•
•
•
•
•
•
WebCube – Add remove fields
WebCube – Drag Drop fields
WebCube – Sort & filter
WebCube – Top Bottom values
WebCube – Add/remove formula
WebCube – Row Column Total / Grand Total
WebCube – Single Multiple Total
• 1KEY Agile has charts and graphs with dial,
gauges, speedometers, heat maps and many
more data visualization methods on web
version as well
Click on the link to see the demo
•
•
•
•
•
•
•
WebChart – Add/remove Formula column
WebChart – Change Measure fields
WebChart – Drill down
WebChart – Filter data
WebChart – Properties
WebChart – Types
WebChart – Top bottom values
Click on the logo to see the demo
• 1KEY Agile has scheduler which can push
report in email or particular locations with
variety of formats like PDF, TXT, XLS, HTML,
MHT and RTF
• 1KEY Agile has File Reader providing the
functionality of direct reporting from Text Files
and Excel Files in cube and view format
Click on the link to see the demo
• File Reader – Text View
• File Reader – Excel view
• 1KEY Agile has dynamic query engine with
expression builder and model creator
Click on the link to see the demo
•
•
•
•
•
•
Query Builder
Query Builder – Create Query
Query Builder – Condition
Query Builder – Aggregate Function
Query Builder – Parameter
Query Builder – Open Query
• 1KEY Agile has its own data ware housing and OLAP
engine. 1KEY is able to give performance on ever
growing databases sizes. It connects and
synchronizes with multiple raw databases and
creates OLAP database in user desired flavor
Click on the link to see the demo
•
•
•
•
•
OLAP – Dimension Creation
OLAP - Creating Model
OLAP – Create View Report
OLAP – View Report Export & Email
OLAP – Create Cube Report, Chart setting &
Style Condition
• OLAP – Cube Report with Single Total, Top
Values & Summary variation
Thank You!
Sanjay Mehta
CEO
[email protected]
Disclaimer:
This document is based on the architecture of Agile and will not be completely applicable for 1KEY 2.0.2 because 1KEY 2.0.2 works on client-server architecture and not uses
server to great extend. 1KEY 2.0.2 makes call to server only for the retrieving metadata or saving metadata.