Automatic POV String Generation from Essbase Retrieves

By Harry Gates | Enterprise Connector, ExoInsight | 0 comment | 29 November, 2018 | 2

We are always looking for ways to make getting your Essbase data easier. We started off with only one data retrieval method – MDX queries. It soon became apparent that asking business users to write MDX queries was a non-starter. This lead us to develop our unique POV string functionality, which enables anyone to easily query Essbase data.

Hundreds of users are now happily writing POV strings manually to populate dashboards and reports. To make the POV string functionality even more accessible, we have created an easy way to generate it automatically from an existing Essbase Smart View retrieve. Click on the video below to see a demonstration.

Please contact us if you’re interested in ways to open up your Essbase data.

POVString

Introducing Microsoft Analysis Services Connectivity in ExoInsight

By Harry Gates | 0 comment

ExoInsight is our premier product for enabling access to Essbase for reporting tools (Power BI, Tableau, etc.) and other downstream applications (data staging, etc.). We started with Essbase, but at Casabase Software our slogan isRead more
ExoInsight – Working with Essbase Substitution Variables, Attribute Dimensions, and UDAs

By Carr Harriman | 0 comment

Substitution variables, attribute dimensions, and user-defined attributes (UDAs) are three very important aspects to any Essbase cube. Like most OLAP sources, Essbase provides value by allowing the user to query data across multiple dimensions andRead more
Tableau and Essbase – A Match Made Perfect By ExoInsight

By Carr Harriman | 0 comment

One of the main trends to come out of the Business Intelligence world in the past five years is the rise of self-service analytics. Reporting and visualization tools have matured both in terms of capabilityRead more
What Is Casabase Anyway And Why Should I Use It?

By Harry Gates | 0 comment

Casabase is a multidimensional engine that aggregates data instantly across multiple, sign-based hierarchies. You can view your data by any combination and at any level of Year, Month, Day, Product, Department, Entity, Location, Account, Scenario,Read more
ExoInsight Direct Query PowerBI.com To Essbase Demo Video

By Harry Gates | 0 comment

The video below shows that by using ExoInsight you can achieve DirectQuery from the Power BI service (PowerBI.com, for example) and pull in data directly from Oracle Essbase, immediately after the data was updated. Read more
Recreating Essbase Hierarchies In Power BI

By Harry Gates | 0 comment

Many of our clients have asked if it’s possible to present hierarchies in Power BI more like they appear in Essbase. They invariably want something like the above slicer and matrix. Power BI’s flexibility reallyRead more