Vanilla v3 (post 5 on 10) – PatchWork of crazy features

Dear Readers,

Getting to the 5th of my summer post about Vanilla v3, I would like to make this post easy to read, with simple images showing some crazy features of Vanilla v3 Designers. Just think how those features can be usefull if you had it in your commercial (open source or not) bi platform …

FreeAnalysis v3- Last function

When dealing with stock management or last sales records, we provide a built-in function in FreeAnalysis Schema Designer to indicate that measure is semi-additive / non cumulative. You have to indicate the dimension that manage “time” for this measure

Fasdv3_Last_function

Result in FreeAnalysis Web – no not to pay for a usable Web Olap interface, FreeAnalysis Web has all you need to play with your cubes :

FreeAnalysisWeb_Last

FreeDashboard v3  – Performance Dashboard

Using our FreeDashboard Designer, it’s so easy to built a multi-tabulation Performance Dashboard with a common filter interface and each tabulation using those filter’s values. This dual secured panel Dashboard (based on FreeMetadata document) is 5 minutes development using a wysiwyg Studio … just forget about javascript framework and enjoy developing & maintaining your Dashboards !

Panel 1- order by country

FreeDashboard_PerformanceDashboard

Panel 2- order by year

BiGateWay v3 – Kml datasource, Dimension aware filter

Wow ! … it’s now so easy to manipulate Kml document (Input and output) to create on fly kml datafiles for GoogleMap visual representation.

BiGateWay is now abble to use Olap cubes & Olap dimension as data entry, and apply filter on your datastream using any kind of dimension/hierarchy/level data validation, with built-in manegement of records that don’t match the filter criterias

BiGateWay_Filter_Dimension

International Character set support

Something available by default in Vanilla is international character support, such as Chineese or Arabic characters. Always good to remind you with this feature, because … well … just test your own Bi Platform, you may be surprised !

Chineese Dashboard

I hope you like this selection of features …

Have Fun !

Patrick

Advertisements

Vanilla v3 (post 4 on 10) – Vanilla Apps

Dear Readers,

Along with the launch of Vanilla v3, we are launching a complementary line of products, under the umbrella “Vanilla Apps”

 

Vanilla Apps

Vanilla Apps

 

Vanilla Apps are running on top of Vanilla Platform, either using some Vanilla Core component or drivers, or beeing abble to publish their result into a Vanilla repository.
Vanilla Apps are promoted and reselled independantly of Vanilla Core Bi components, and represent a good way for editors to use Vanilla like a set of background services

First set of Vanilla Apps products are :
– Vanilla Reader : a simple GSpreadSheet / GTable reader, that you can use to work on your Google Spreadsheet or tables in disconnected mode, that leverage our GSpreadsheet and GTable oda drivers. Any Vanilla reader definition can be automatically turned into a BiGateWay transformation, for example to automate GSpreadsheet data replication into a database.

 

Vanilla Reader

Vanilla Reader

 

– Vanilla Disco : a complete Vanilla Olap/Dashboard/Report viewer to manipulate Vanilla Bi documents in disconnected mode (ie : without beeing connected to a Vanilla server). Advanced functions such as delta load of cube datas are provided by default

 

Vanilla Disco Olap Interface

Vanilla Disco Olap Interface

 

– Vanilla Migration Toolkit : an out-of-the-box product to automate BO’s universe or Cognos catalog migration into Vanilla FreeMetadata document

– Vanilla for Jda/Mms : a ready to run package to leverage Jda/Mms database

 

Vanilla for Jda Mms - Chineese Olap View

Vanilla for Jda Mms - Chineese Olap View

 

Vanilla Apps are more than simple PlugIn : they can work outside of Vanilla Platform. Some of those Vanilla Apps will be available for free (such as VanillaReader) as opposed to others (such as VanillaDisconnected) that will be available for supported customers only,

… more Vanilla Apps to come in 2010 … while some projects have invested in sales executive, we are following our own way to offer more realiable features and products to comunity and customers …

Have Fun !
Patrick

Vanilla v3 (post 3 on 10) – FreeDashBoard v3

Dear Readers,

FreeDashboard is the only “metadata secured” Open Source Dashboard platform, and version 3 provides now 2 new big features :
– forms management : you can use FreeDasboard to design wysiwyg forms that you deploy from portal or within workflow. Forms are usefull to manage user input (data for dynamic Etl process) or for process validation.
FreeDashboard/Forms provides also an easy method to manage row dataset. No need to use an external Form Designer like before, which means you can use Vanilla resources (such as Metadata secured prompts) to create your Forms.

Fdv3 Forms

Fdv3 Forms

– performance dashboard : multi tabulation Dashboard layout, to provide developer with an easy way to build interactive performance Dashboard.

We have also added new components, such as timer (to setup an auto-refresh feature on Dashboard, very usefull for “live Dashboard”)
and enhance/facilitate the way to embed Reports (FwReport, Birt & IReport), FreeMetrics/Kpi or FreeAnalysis Olap view in Dashboards (Dashboard remains the “interactive glue” with all the others Bi document published on a Vanilla portal)

Fdv3 Forms with Kpi

Fdv3 Forms with Kpi

Have Fun !
Patrick

Vanilla v3 (post 2 on 10) – Ecm

Dear Readers,

What a tremendeous new feature in Vanilla v3 : we now provide users with a complete document management platform, based on standard Lucene search engine and Vanilla Architecture

Vanilla Ecm itself could compete with other standalone Ecm platform, but as for our BiGateWay Etl component, we’d rather promote Vanilla as the “all in One” Bpi Platform.

Vanilla Ecm provides users with global document management features (multi classification / version management / powerfull search engine) and is working with our report engine, to provide automatic indexation of generated reports. Thus, you have now a search interface to browse any generated document with a complex keyword sentence.

Just imagine how this can be usefull to look for reports that contains a specific product code, or all reports dealing with a specific customer.  With a simple search interface, you have an immediate access to the global list of reports (either loaded manually or generated by Vanilla engine) that complies with your search !

Vanilla Search Interface

Vanilla Search Interface

It’s definitly a feature I was expected to have for a long time. What about you ? Do you think a document management and search engine is a must in any “Bi” Platform ?

Have Fun !
Patrick

Vanilla v3 (post 1 on 10) – MultiThread

Dear Readers,

First post of the Vanilla v3 serie, and subject is awesome :Vanilla v3 is now abble to run most of Bi Requests in a pool of threads. Looking around, in commercial Bi and old fashion Open Source Bi platforms, I don’t see a lot of features like this.

It’s like turning a cafeteria into a restaurant, with as many servers as your restaurant manager can offered (limitation is number of cpu and memory resources for every server), and also beeing abble to send your customers in another restaurant if you can’t add space anymore in yours.

More impressionnant : you can dedicate some process to run on an external “process server”, which can be usefull to run Etl transformation on the database server, or a set of reports on a dedicated server.

To manage Vanilla multithread properties, we provideadministrators with an easy to use interface,were you can setup properties for the first 3 servers available : report server, etl server and metadata server (I will come back later on interest of metada server). From this interface, you can setup the number of thread, location of files, …

Vanilla v3 admin console

When process are running (in batch, by groups of reports using a task manager), you can manage any running process (view detail) and follow the global consumption of your server resources. Easy to use, and so usefull !

Memory consumption

Have Fun !

Patrick