Posted by romka on 31 March, 2008 10:02

How to talk to MS Analysis Services from Flash to reach OLAP Cube? It was the first question.

Firstly, you need to know that Microsoft Analysis Services uses SOAP-based XML for Analysis protocol to exchange of data between clients and server. (You may also read more about XMLA on Wikipedia)

So in Flash application

1. generate XMLA request,
2. forward it to SOAP wrapper and
3. send SOAP request to the HTTP pump (http://your_host_name/msmdpump.dll),
4. HTTP pump forwards the request to the server.

Microsoft Analysis Services

1. sends the SOAP response back to the HTTP pump,
2. SOAP parser retrieve data from HTTP pump and
3. prepare data for our application.

There two types of XMLA request. The Discover method retrieve information about data structure on a server and the Execute method sends requests for retrieving or updating data. We discover data structure and choose desired dimensions for view, retrieve data from server and show in grid.

You can try demo in action - it is connected to the sample OLAP cube in MS Analysis Services. You can configure the dimensions structure and visualize the result.

  Posted by romka on 29 February, 2008 17:23

Today we have prepared a new demo of Pivot Table. We want to show you new feature of Pivot visualization. You can organize your own structures of Pivot dimensions and see data from different points of view by selecting.

There are five areas in options view: Filters, Columns, Rows, Values and All Fields. To change data structure drag field from one area and drop to another. When desired dimensions structure is ready - click "Apply Changes" button and see your new visualization of the same data. In this demo you can change only columns and rows. Filter area is still unused and Values show only sum of one dimension - work hours.

Video Demo (40 sec)

Try PIVOT TABLE in Action

  Posted by ira on 15 February, 2008 15:29

Client Side PDF Generation Using Flash, Flex and AIR

As far as I know, it is really complicated and challenging task to generate PDF on the server side. We have recently faced this challenge on the client side. Our products - LiveArt and Pivot Table have to incorporate the PDF generation functionality. We have conducted several researches and I am glad to announce that it is easy (hurray :)) to generate PDF using Flash, Flex and AIR. It has become possible thanks to AlivePDF library. This post helped us to find it.

How powerful client side PDF generation is? Powerful enough to meet our main need at the moment – generate PDF document as the exact copy of graphic and data visualization objects which users get when they use our Flash/Flex products, like LiveArt and Pivot Table. AlivePDF library allows inserting JPEG format images into PDF document. The addImage method uses DisplayObject object (its incoming argument) to take a snapshot of it in JPEG format and insert into the PDF document.

AlivePDF library allows us to easily do the following:

• Set layout, margins, get sizes;
• Add and compose pages;
• Use drawing primitives, manage color models;
• Set fonts and text properties;
• Add images in JPEG format;
• etc.

Of course, there is no limit to perfection. Our dream is to be able to convert Flash vector objects into similar vector objects in PDF. It seems that we need a number of steps undertaken to make it real. But we will strive and will succeed!

  Posted by ira on 12 February, 2008 18:04

Pivot Table live demo is now available. You can check it out and play with it to see how clear, easy-to-use, and quick Pivot Table is. It visualizes multidimensional data from various data sources (OLAP, XML, etc.) and provides a set of tools to manage these data.

Today we have released the following features and tools:


*Drill down on dimensions. Each dimension which has subdimensions can be collapsed or expanded. This feature works instantly without any delays!
* Full screen feature for wider view. Imagine your data on 21" (or even bigger) monitor with good screen resolution.
* Printing tool to get the needed data printed.
* Skin selection. There are 3 skins available at the moment. One can easily create new skin within about 10 minutes by simply editing CSS.

Drill down on dimensions


Skins, Full Screen and Printing


Our team keeps on working on Pivot Table. So, new features are coming soon, just sit back and wait for the new release.


See PIVOT TABLE in Action

  Posted by ira on 13 December, 2007 23:49

Styles for Pivot Table

Currently we are working on styles for the Pivot Table component. The most convenient way of defining styles from our point of view is to use CSS for this purpose. This comes of our Flex experience, being a classic decision for Flex components. External css file with set of styles will give the ability to customize the following properties of the Pivot Table:
In the nearest future we are going to make a live demo of the new Pivot Table version.

We would really like to know your opinions on which Pivot Table properties it might be useful to define as styles and customize externally. Every feedback is greatly appreciated!

  Posted by flexmonsterandrew on 05 December, 2007 14:19

Hurray! We are listed on Flex.org Components with Pivot Table component for data visualization :-)

Special thanks to Mike Potter who listed us and wrote in his blog Cool New Flex Components, we got really huge interest already and get inspired to build even more exciting AS3 and Flex components. We are now preparing our development Roadmap, expect to check it in the near future!

  Posted by flexmonsterandrew on 29 November, 2007 16:36

Welcome to Flexmonster blog regarding development of Action Script Pivot Table for OLAP data rich visualization. We will post news and ideas about our current achievements. You are welcome to participate! Thanks :)