Another note about BiGateWay

Dear Readers,

I received questions about how to use an Olap Structure as a Data Source in a BiGateWay transformation. So this Video, to provide more than simple screenshot this time. In this video, you can see how to define the Data Source (Olap), how to create a simple transformation that take some Olap member item and load them into a new Sql table (its so easy to do !) … and best of bread, how to deploy the transformation and run it from Vanilla portal.

You can access the video from here : BiGateWay Transformation using an Olap Data Source

Don’t confuse : it’s easy to do, but it requieres knowledge or assistance (about Olap & Etl in general, with a focus on Vanilla technologies & modules). Too many times over the past few weeks, I received mail from potential users asking for ponctual assistance … on the final step. Before running 100m in 10 to 12 seconds, people have to learn how to walk, no ?

Have Fun !

Patrick

Vanilla v4 (Post 9 on 10) – UnitedOlap

Dear Readers,

I have already posted some words about UnitedOlap, our new Olap Engine, that will be delivered with Vanilla version 4. UnitedOlap is a serious project, that started 1 year ago, and we will provide designers, admin & developers with all the features they need to manage a real Olap project.

Most important with UnitedOlap is we provide a bug free interface when it comes with complex calculation. I wont waste my time talking about bugs in old Open Source olap driver … they never fixed it (last calculation, “all” display not coherent with visual datagrid …).

Key features for United Olap are

Support for dynamic calculation in Olap Cubes
Vanilla UnitedOlap is the only platform with an olap component which use dynamic agregation depending on the level of dimension. For instance : you can define sum as the agregator for the country level and count agregator for the city level, or you can define your ‘last’ calculation strategy

Interface to Design a Dynamic agregation using FreeAnalysis Schema Designer



Support for non-Sql datasources

Vanilla UnitedOlap provides support for oda and sql datasource (pure jdbc or fremetadata datasource, with security)

Support for Snowflake schema with multiple column join strategy
Vanilla UnitedOlap support multiple column join strategy for Snowflake schema, as opposed to other old engine that has limitation to 1 column only … this allow UnitedOlap to connect to production database, not only to datamart.

Real Admin Interface with cache management & performance audit

Serious Administrator need tools to manage their Olap Platform, install and audit a cluster of Server, especially in the (R)Olap world. Hypervision provide tools to help you understand what request is time consuming, what is the cubes activity, …

Hypervision : Olap Audit

When it comes to keep promises … just put aside marketing noise … real platform dont need that kind of noise !

Have Fun !

Patrick

Vanilla v4 (Post 6 on 10) – Vanilla Apps

Dear Readers,

There is something certain with Vanilla Apps : it’s growing every week, in terms of new supported platform (application & database), new document (more dashboard, more report, more cube, more Kpi) and in terms of architecture, because we have migrate to UnitedOlap engine. What does it means ? …  simply we can now delivere cube ready to run on production database, breaking the limitation of our old olap driver that supported only 1-column join strategy (it was not usable with production database, where join strategy is multi-column with snowflake schemas) … package “ready to deploy” that provide Bi on production database !

But most important with Vanilla Apps is now the number of platforms covered, as we provide now 11 : Mantis, OpenBravo, Glpi, VTiger, SugarCrm, OrangeHrm, GoogleAnalytics, Nagios, Cocktail, DotProject and Vanilla (itself). I’m certain most of you have already deployed 2 or 3 of those applications and would like to deploy standard Bi documents (available on Tablets & Smartphone), as opposed to managing report & dashboard for each application.

Now, next step is to improve the way we delivere Vanilla Apps, because we understand it’s sometimes difficult to have access to information about new document, new update, or even new Apps. This will be one of the new features that will come with Vanilla v4 : tools & methods to deploy Vanilla Apps using Enterprise Services … just keep in touch, I will provide soon the first screen shot of this new feature.

Have Fun !

Patrick

UnitedOlap, Designer Explorer

Dear Readers,

First of all, I would like to thanks all the persons who contacted us to be part of the UnitedOlap test Team. It’s really a nice message sent to the UnitedOlap dev team to have experienced persons behind us to finalise some features and run tests on various databases.

I took time to answer to most of the mails (for those with clear mail address), to indicate that we forecast to add new testers with period 2 of the global test, which should start second half of july, once we will have collected & solved most of the identified bugs.

During the test period, development of new features such as new integrated explorer to browse more objects while developing the schema. I will go short on the competition, because there is nothing in Open Source (Designer + EXplorer of Cubes), leading to painfull cycle of development/tests.

So, thans to Eclipse PlugIn technology, we have added 2 explorers in our FreeAnalysis Schema Designer, one basic, to test direct Mdx statment, and another one with more interactivity, which purpose is to take place of FreeAnalysis Java, our java cube package.

Interface to select dimensions & measures

2 interestings features : you can select your profile/group to browse the dataset and you can limit the number of rows used from the fact tables (during the develpment/test, to reduce time to build the grid)

Results in a grid on large dataset

Revival of the Java package …. !!!

We finally make it … still under development, but already usable, promising and soon flashy !

… dont miss a chance to be part of the next generation of Open Source Olap Engine, join us and be involved in the Roadmap !

Have Fun !

Patrick

UnitedOlap and Manual Dimensions

Dear Readers,

Another crazy feature is available in UnitedOlap, using our UnitedOlap Designer : you can easilly create a dimension level by your own (we call it MANUAL DIMENSION) and assign your child member to “virtual father node”. It’s so usefull when you miss a new level to group your data.

Just  let me give you a simple example. Suppose you have a list of countries but not the “continent” information in your database. Which means by default you can’t view the data per continent without any heavy operation such as adding a new table in your database, or a new column in your dimension table, along with building an interface to enter the codification.

With UnitedOlap, simply create MANUALLY a new dimension level (“continent” in our example) and assign each country to its continent. In 10 minutes, you can view your data using a “continent” dimension, without any new tables in your database (or SpreadSheet, / csv datafile) … all is under control by the Olap Designer …

… soon available in preview, this summer, along with documentation (Pdf, Video) …

Have Fun !

Patrick

FreeAnalysis Schema Designer for UnitedOlap (part 5)

Dear Readers,

Last day of the week … last post to discovere UnitedOlap & FreeAnalysis Schema Designer features. Below, some screenshots about Maps/Cube integration, already available with Vanilla 3.4 … still available with UnitedOlap ! All is Metadata secured … beauty of the Vanilla platform !

Maps definition using Norparena

Dimension parameter in FreeAnalysis Schema Designer

Level parameter in  FreeAnalysis Schema Designer

Result in FreeAnalysis Web

Let’s be clear and direct : all the subjects covered this weeks are not available in marketing based old Olap bundle (coming from Us or Italy, just bundle) … and will never be available. I regularly read some bad comment about our French based Vanilla project … don’t forget the 2008 Us financial crash … some analysts are just marketing company (like the “.G” and its funny leasy analyst … thanks again for not endorsing our marketing … we saved valuable money and invested it in our platform …).

Have Fun !

Patrick

FreeAnalysis Schema Designer for UnitedOlap (part 4)

Dear Readers,

Security is a tricky subject, especially when some leasy editors only bundle different products without merging repositories and authentification services. Did you ever tried to secure a Mondrian schema manually and deploy it under JPivot (oups : dont forget to let the hierarchy without name …) … ok, it’s possible .. but it doesn’t compare with what is available in commercial products.

Inside Vanilla platform, we had to enhance FreeAnalysis Schema Designer to provide access to authentification database and create secured views, leading to declare security signon in both : FreeMetadata and FreeAnalysis. It’s running well, but we wanted to enhance the process.

UnitedOlap is able to use Oda dataset, so we can use the FreeMetadata oda secured data source and keep all the security declaration in FreeMetadata (subject to merge FreeMetadata and FreeAnalysis Schema Designer is out of scope of this post). Just look how it works :

1) Supposed in FreeMetadata you secure your fact table on order status, for a specific group of users (Status “Resolved”)

2) Using FreeAnalysis Schema Designer, just declare a FreeMetadata Oda datasource, and select your datasets

3) Design your cube with a dimension that has a secured item (very simple design for this example) :

4) Result in FreeAnalysis Web, with 2 different groups

System (no security)

Designer (Security set with Status = Resolved)

You can see above : No filter in the “Filter” box … security is automatically set from the datasource, using user’s connexion. And for this user, a bonus : the Tomcat Log, where you can see the filter in the where clause … very clean and efficient

Have Fun !

Patrick