Flex Olap Components

Flex Development

We have developed an useful OLAP analysis control using Flex and are making it available as a framework which we can customize for others.  Below is a Powerpoint slide which shows the high-level vision of the components.

If you want to download the code you can do so via our Source Forge project which we have named Grebulon.  The project is found here: Grebulon

The source code can be found downloaded via SVN or as a GNU archive here: OLAP Source Code

If you are interested in gaining assistance in integrating this code into your project we are willing to perform some intial consultation for free but consulting arangements are obviously preferred.  Plan for about 5-8 hours to get the XML/A Library code working in a new environment.

Some of the features that can be made available:

OLAP Pivot Component 

• Easy drag-and-drop functionality builds queries without any coding or need for MDX 
  
• Display multi-layered metadata structures in an intuitive tree hierarchy. 
  
• Analyze multiple cubes with a single control 
  
• Column sorting allows for one-click sorting and ordering. 
  
• Drill-down functionality enables user to reveal data at any level
  
• Provides the ability to flatten query data into flex compatible data structures (ArrayCollection) 
  
• Ability to view built MDX query educates users and facilitates collaboration
  
• Independence. Component only requires the Ignite Analytics XMLA/HTTP ActionScript library 
  
• Highly customizable appearance properties to meet aesthetic needs.
• Displays MDX "SQL" for retrieving the data from OLAP. 
  

OLAP Browser 

• Enables users to selectively query all available cubes
  
• Provides context of the measures, attributes, levels within a cube
  
• Displays hierarchical structure of a selected cube 

Data Export Component

• Easy one-click operation enables users to extract previously silod Flex data into familiar Excel component 
  
• Comma seperated, PDF and Excel output options greatly enhance information reuse 
  
• Independent.  Works with 1 & 2-dimensional data sources (ArrayCollection, Array, Ilist) 
  
• Uses Microsoft Office Web Component for easy Excel formatting and optimal copy-paste support 

XML/A ActionScript Library

• Connects to your Mondrian OLAP server via HTTP 
  
• Supports OLAP discovery calls to enable schema-driven applications 
  
• Supports Flex 2 OLAP Datastructures (IOLAP, IOLAPResult etc) 
  
• Accelerates development for Flex-OLAP stack applications by abstracting query and discovery operations 
  
• Full-featured logging helps isolate deployment problems and quickens issue resolution tasks 
  
• Provides the ability to flatten query data into flex compatible data structures (ArrayCollection) 
  
• Ability to view built MDX query educates users and facilitates collaboration 
  
• APIs enable developers to retrieve and store XML/A requests and responses 
  
• Asynchronous request queing enables server to process requests without risk to client becoming disconnected