Flex OLAP Solution Available
A couple of months ago we developed a component to help one of our clients query and analyze a mondrian OLAP cube. As we researched the idea we realized that we would like to productize the component and provide it as a foundation for others.
Thankfully we were able to negotiate a win-win deal with the client so that our work is not owned by them and we can now offer the piece to others.
Essentially it is a Flex component, using the OLAPDatagrid and OLAP objects, whichinteracts with an XML/A OLAP data provider. It builds and executes MDX queries and displays the results. Kind of like some of the basic SQL tools. There are a tremendous amount of improvements that could be added but the fundamentals are complete and ready to be built on. I have provided is a Powerpoint showing the basic framework the component sits on and some images (obviously the UI can be skinned to your liking).
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.
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
If you are interested in leveraging this work contact us at www.SherlockInformatics.com or www.IgniteAnalytics.com.