#VISUAL BUSINESS INTELLIGENCE PLATFORM HOW TO#
#VISUAL BUSINESS INTELLIGENCE PLATFORM DRIVER#

For eg., if the user’s personal folder has subfolders, this object will give its actual folder path.īut for any other type of document (e.g. The object FolderPath only gives the folder path if the object is a folder. We get the following objects from Level 0. The BI Platform CMS system database universe consists of a single table called Properties along with four alias tables on the main table. We will first see how the universe is structured.

#VISUAL BUSINESS INTELLIGENCE PLATFORM HOW TO#

This blog will be a deep dive, about how the BI Platform CMS system database universe is structured and how to build your own queries on it to get the required information from the CMS in an effective and efficient manner.

We also leverage the powerful distribution capabilities of the BI platform.Īn earlier blog on our site, BI 4.2 SP3 New feature – CMS Database Data Access Driver, provided an initial look at the driver, how to set it up and execute the ready-to-use queries that are available in the BI Platform CMS system database universe.

We use familiar reporting interfaces like WebI that requires little user retraining.

It is also a hassle to export and distribute the results of the queries without SDKs/macros.

It is difficult for end users to learn how to query the CMS metadata virtual tables using SQL.

While the Query Builder is a powerful tool, it has a few disadvantages. We no longer need to create complicated queries in Query Builder to know more about the objects in the BI Platform – users, connections, custom access roles, reports, dashboards etc. With the new BO CMS Data Access Driver from SAP(available from BI 4.2 SP3), we can use the familiar BO reporting interfaces to connect to the CMS data through the customizable BI Platform CMS system database universe.

News – Check out our most recent news, key announcements & Press releases.

Innovation Lab – The Innovation Lab is built with an aim to create market-ready BI & Analytic solutions.

Careers – Explore intellectually rewarding careers in the field of Business Intelligence & Analytics.

About Visual BI – We make the best in BI possible through our passion and commitment to innovation.

Events – Check out events hosted and attended by Visual BI Solutions.

Webinars – Get latest updates on our webinar schedules & register to learn from our experts.

Videos – Handpicked video resources showcasing you the latest BI trends and technologies.

Case Studies – A growing collection of more than 50+ case studies exhibiting our customers’ success.

Blogs – Get your inside scoop into our take on the latest developments in BI & Analytics.

Data Science & ML – Unlock endless possibilities with an optimum mix of Data Science and Machine learning.

Modern BI & Analytics – Experience the power of data with modern visualization techniques.

Strategy & Architecture – Drive successful outcomes with the right data strategy and architecture.

Data Architecture & Engineering – Build a modern data foundation that supports your business.

To find resources around contributing along with a detailed guide on Interested in contributing? Check out our

Ask and answer questions on StackOverflow using the apache-superset tagĪnd please read our Slack Community Guidelines.

Installation and ConfigurationĮxtended documentation for Superset Get Involved Want to add support for your datastore or data engine? Read more here about the technical requirements. Here are some of the major database solutions that are supported:Ī more comprehensive list of supported databases along with the configuration instructions can be found

#VISUAL BUSINESS INTELLIGENCE PLATFORM DRIVER#

Superset can query data from any SQL-speaking datastore or data engine (Presto, Trino, Athena, and more) that has a Python DB-API driver and a SQLAlchemy dialect.

A cloud-native architecture designed from the ground up for scale.

Highly extensible security roles and authentication options.

Lightweight, configurable caching layer to help ease database load.

A wide array of beautiful visualizations to showcase your data, ranging from simple bar charts to geospatial visualizations.

Out of the box support for nearly any SQL database or data engine.

A lightweight semantic layer for quickly defining custom dimensions and metrics.

A powerful, web-based SQL Editor for advanced querying.

A no-code interface for building charts quickly.

Superset can replace or augment proprietary business intelligence tools for many teams. Superset is a modern data exploration and data visualization platform.

Organizations Using Superset Why Superset? A modern, enterprise-ready business intelligence web application.

Visual business intelligence platform