The NEXT thing to try!!

Icon

Random rants and tips about NETCF, WinCE, Emacs, Powershell etc.

Adobe flex offers an in-memory OLAP Cube

With the announcement of beta 2 release of flex 3, Adobe provides support for multidimensional analysis of data. The new OLAP APIs and OLAPDataGrid, Flex 3 is offering it is now possible to do multidimensional analysis of your data and display it in a cross tab fashion in OLAPDataGrid.

The idea here is to have an in-memory representation of an OLAP Cube which can be queried using OLAP query APIs. The query APIs look similar to the well know MDX query language but query support is through APIs rather than a query language like MDX. The query result can also be shown using an OLAPDataGrid control. OLAPDataGrid control itself is highly customizable and one can use custom styles, formatters and renderers to suite your needs.

What about remote olap servers like Microsoft Analysis services, mondrian? Ahh, good question!!!the OLAP API’s are very generic and one can get the functionality by implementing the interfaces provided. If that sound like too much to do, believe me its not. I will be posting a sample very soon for interfacing with Microsoft Analysis services.

If you are finding this interesting and want to find out how to achive this, read the write up here. There is also a captivate video which demonstrates how to create your first cube.

So my suggestion is do give it a try!!

Flex 3 beta 2 can be download from the following link

Advertisements

Filed under: flex, OLAP

9 Responses

  1. Djam says:

    That’s really great news (at least for the one who sends a bunch of arrays to the client-side to make Flash datagrid become a bit more functional, like the Pivot table in MS Excel). A huge step towards making developer’s life that work on RIA for business analytics.

    Go Adobe, Google Spreadsheets needs a competitor 🙂

  2. Erki Esken says:

    Please post MS Analysis Services integration example soon. This is the most exciting part of cube support in Flex 3 for me.

  3. I was not able to find from where I can download it, even I followed links to adobe page. Would you know how can I enroll into beta program and download it? I am also interested how it will behave with Microsoft SQL Server Analysis Services.

  4. SG says:

    Hey Nisheet,

    Do you know what are Flex Cubes? If you know, can you let me know about that?

  5. Jesse Couch says:

    Yes, olap cubes are powerful.

  6. Jesse Couch says:

    I have used the flex olap classes with Microsoft Analysis services to create powerful business solutions.

  7. shyam says:

    Nice Article.. but one question from me does the new component from flex eliminates use of mondrian ?

  8. rei says:

    olapdatagrid cannot export the results weeeeeezz

  9. We are a group of volunteers and starting a new scheme in our community.
    Your site offered us with helpful info to work on.
    You have performed an impressive activity and our whole neighborhood will be thankful to you.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: