Dear Readers,
Another “reborn feature” : Metadata Explorer, available as an “early feature” in Vanilla 4, now fully functional, and integrated as a friendly user module. Using Metadata Explorer, any user can
- build his own request to extract data from the database (in fact, from the data he is allowed to access, as connection is through metadata only, and never direct access on database table)
- manipulate the dataset : add new column, create new calculated column, apply filter, aggregate information, drill between folders inside the metadata, etc …
- Save the dataview for later reuse (it will be available for edit/run from the portal), or save the dataset content as external file to be used by external packages like R or Weka (csv file, excel file, weka file)
- View the data using different integrated modules
- graphs perspective : we provide the basic graphs view, a graph is worth hundred reports
- generate a report on the data (switch to Vanilla Report keeping the current dataset),
- generate a cube on the data, to be view using Vanilla Analysis viewer
Enjoy this series of screenshots …
Now, using Vanilla Metadata Explorer, users can have access to their data, what ever the database is (relational database, Big Data database, NoSql database, etc …). Bi developer just need to design “best of the bread” Metadata, to allow users to access their business data.
Remember : Vanilla Metadata is an Open Source component, and provided as a full functional package (I mean : key features like security, multi join path definition, prebuilt queries, etc … all is available without any limitation), integrated as the Vanilla dataset provider with all the other Vanilla modules (Report, Dashboard, Cube, Kpi, Explorer, ETL …)
Have Fun !
Patrick
Filed under: FreeMetadata, Vanilla, Vanilla5 | Leave a comment »