ra business intelligence 0.1
DESCRIPTION
Ra business intelligenceTRANSCRIPT
![Page 1: Ra business intelligence 0.1](https://reader033.vdocuments.us/reader033/viewer/2022052906/558d3a07d8b42a79688b4637/html5/thumbnails/1.jpg)
![Page 2: Ra business intelligence 0.1](https://reader033.vdocuments.us/reader033/viewer/2022052906/558d3a07d8b42a79688b4637/html5/thumbnails/2.jpg)
RaITS Business Inteligence Solutions
![Page 3: Ra business intelligence 0.1](https://reader033.vdocuments.us/reader033/viewer/2022052906/558d3a07d8b42a79688b4637/html5/thumbnails/3.jpg)
View data “dimensionally”• i.e. Sales by region, by channel, by
time period
Navigate and explore• Ad Hoc analysis• “Drill-down” from year to quarter• Pivot• Select specific members for
analysis
Interact with high performance• Technology optimized for rapid
interactive response
![Page 4: Ra business intelligence 0.1](https://reader033.vdocuments.us/reader033/viewer/2022052906/558d3a07d8b42a79688b4637/html5/thumbnails/4.jpg)
View On-Line Analytical Processing (OLAP) cubes• automated aggregation• speed-of-thought response times
Open Architecture• 100% Java• J2EE• Supports any JDBC data source• MDX and XML/A
Analysis Viewers• Enables ad-hoc, interactive data
exploration• Ability to slice-and-dice, drill-
down, and pivot • Provides insights into problems or
successes
![Page 5: Ra business intelligence 0.1](https://reader033.vdocuments.us/reader033/viewer/2022052906/558d3a07d8b42a79688b4637/html5/thumbnails/5.jpg)
RaITS Business Inteligence Solutions
![Page 6: Ra business intelligence 0.1](https://reader033.vdocuments.us/reader033/viewer/2022052906/558d3a07d8b42a79688b4637/html5/thumbnails/6.jpg)
User Interface
RDBMSRDBMSSchema XML FileSchema XML File MS SQL Server
OLAPMS SQL Server
OLAP
Schema LoaderSchema Loader
DimensionalModel
DimensionalModel
Star SchemaModel
Star SchemaModel
SQLModel
SQLModel
Session Manager & TransformerSession Manager & Transformer
MDX Result Set
J2EE / Struts
XML
JPivot
Mondrian
Java
OLAP API
![Page 7: Ra business intelligence 0.1](https://reader033.vdocuments.us/reader033/viewer/2022052906/558d3a07d8b42a79688b4637/html5/thumbnails/7.jpg)
Mondrian Provides– Dimensional view of data– MDX parsing– SQL generation– Caching– High-level calculations– Aggregate awareness– BI server is not required– XML will serve as BI server
![Page 8: Ra business intelligence 0.1](https://reader033.vdocuments.us/reader033/viewer/2022052906/558d3a07d8b42a79688b4637/html5/thumbnails/8.jpg)
Open Standards (Java, XML, MDX, XML/A, SQL)Cross Platform (Windows & Unix/Linux)J2EE ArchitectureServer ClusteringFault ToleranceData SourcesJDBCJNDI
Cube Schema
XML
Cube Schema
XML
Cube Schema
XML
J2EE Application Server
Mondrian
Web Server
JDBC
RDBMS
cube cube cube
File or RDBMS Repository
RDBMS
JDBC JDBC
JPivot servlet
JPivot servlet XML/A servlet
Microsoft Excel(via Spreadsheet
Services)
![Page 9: Ra business intelligence 0.1](https://reader033.vdocuments.us/reader033/viewer/2022052906/558d3a07d8b42a79688b4637/html5/thumbnails/9.jpg)
Set of Custom JSP Tag libraryRenders OLAP table and ChartingSupports OLAP Navigations like
Slice & DiceDrill DownRoll Up
![Page 10: Ra business intelligence 0.1](https://reader033.vdocuments.us/reader033/viewer/2022052906/558d3a07d8b42a79688b4637/html5/thumbnails/10.jpg)
RaITS Business Inteligence Solutions
![Page 11: Ra business intelligence 0.1](https://reader033.vdocuments.us/reader033/viewer/2022052906/558d3a07d8b42a79688b4637/html5/thumbnails/11.jpg)
• On Demand Reporting– Ability to design & generate reports on demand• Users will be able to design & generate reports
• Flexible Dashboards and Mashboards• Data Mining• Extensive Graphs and Charts • Data Integration• User Friendliness