Expertise Beyond the Numbers

Oracle Analytics Cloud Data Visualization Quick Tip: Excluding PBCS Dimension Names

Recently, we have been trying to build some dashboards leveraging a direct connection to a PBCS application in Oracle Analytics Cloud’s (OAC) Data Visualization. However, we have run into a snag where the dimension name is automatically being included in the data set being utilized for our visualizations. Luckily, we have found a quick solution to this issue which we have outlined below.

As you can see in this particular DV Project we are attempting to create an analysis on what Degrees generate the most Tuition Revenue. By default, the dimension name Degree is being included in the data set.

OAC Quick Tip - DV Project Name

Our first reaction was to create a filter to include every member under that dimension except for the dimension name itself.

OAC Quick Tip - Filter

After excluding the dimension name, which seemed like a sure way to get around the issue, all we are left with is a confusing query error that doesn’t really explain what we did wrong.

OAC Quick Tip - Query Error

The easiest way around this issue is to combine different properties of the dimension in your query. In this case we used the Degree Name for the visualization and then added the Degree Gen to create a filter.

OAC Quick Tip - Data Elements

By filtering on Gen 2 and 3 we are able to exclude the dimension name from the data set.

OAC Quick Tip - Exclude Dimension Name

Now as you can see below the visualization does not generate a query error and the Degree dimension name has been removed from the data set, resulting in the correct analysis.

OAC Quick Tip - Correct Dimension Analysis