Analytics Resources: Insights, Best Practices,

Case Studies and More

close
23 Oct 2017

SQL Server in Linux

Microsoft SQL Server now supports Linux. Since it has just come out of...

29 Apr 2017
Business Intelligence | 3 min read

Automatically Purge ODI Operator logs for BI Apps

For one of my projects we ran into an issue with constantly running ou...

20 Apr 2017

Dimension Specific Aggregation in Power BI

When dealing with facts and measures in any BI tool, you can set the a...

11 Apr 2017

Filtering in Power BI

You are now able to pass filters to a PowerBI report using the URL. Th...

01 Mar 2017
BICS | 2 min read

Implementing Navigate in Union reports for BICS

As we all know Navigate does not work in OBIEE when we are in a Union ...

12 Nov 2016
Big Data Hadoop | 19 min read

HIVE-TEZ Query Optimization

Following up on my earlier post on some of the configuration and optim...

12 Nov 2016
Big Data Hadoop | 8 min read

HIVE-TEZ SQL Query Optimization Best Practices

Introduction Whie working on my current project for a large bank on a ...

03 May 2016

Effective Procurement and Spend Analytics

The potential to use Procurement & Spend data to be more strategic...

12 Mar 2016
Hyperion Cloud Analytics | 2 min read

Learn how to supercharge your sales

An accurate sales forecast is critical to achieving revenue and profit...

05 Mar 2016
OBIEE 12c Cloud Analytics | 1 min read

Join us at the Modern Finance Experience

Join us on Wednesday 23-Mar at the Marina Bay Sands for the Modern Fin...

03 Mar 2016
OBIEE 12c | 6 min read

OBIEE 12c Baseline Validation Tool

In the real world, the migration between two OBIEE environments is rea...

14 Feb 2016
OBIEE 12c | 2 min read

Steps to upgrade usage tracking when upgrading from OBIEE 11.1.7.1 to OBIEE 11.1.1.9

Recently usage tracking stopped working for one of my clients after up...

11 Feb 2016
Informatica | 2 min read

ETL Assurance Dashboards for Informatica

Informatica Power Center 9.1 metadata can be exposed to OBIEE reports ...

03 Feb 2016

Geospatial Analytics in OBIEE - Part V - Working with Mapviewer API

Oracle Fusion Middleware MapViewer is a development toolkit for incorp...

03 Feb 2016

Geospatial Analytics in OBIEE - Part IV - Working with custom POI layers

I think it is quite safe to say that I do not need to explain the virt...

20 Oct 2015
OBIEE 12c Cloud Analytics | 8 min read

How to Load On-Premise data to Oracle BICS using Data Sync

Moving to the cloud in some ways makes things more complicated for ana...

09 Aug 2015
Hyperion | 2 min read

All about Essbase Data Cache

If you have already been a Hyperion Planning consultant long enough, y...

By Huy Van
09 Aug 2015
Oracle BI Applications | 5 min read

How to add new fact tables in Oracle BI Apps 11.1.1.8.1

It is often seen that certain key business requirements are not covere...

11 Apr 2015
| 4 min read

How to pass pass custom parameters when Navigating in OBIEE

One of the most frequent challenges run into when designing reports is...

11 Mar 2015
Hyperion | 2 min read

How to capitalize interest payments in Hyperion Planning / Essbase

You may meet a requirement like this: In calculation interest payment ...

By Huy Van