My Oracle Support Banner

Planning Cloud: Smart View Error while doing Ad-hoc Analysis - The dimension [XYZ] is invalid (Doc ID 2782518.1)

Last updated on JUNE 17, 2021

Applies to:

Oracle Planning and Budgeting Cloud Service - Version N/A and later
Information in this document applies to any platform.


Error message saying Invalid Dimension in Smartview while connecting for an Ad-hoc analysis.

"The dimension [XYZ] is invalid."

However user is not facing the same issue when using an old existing ad-hoc sheet with members which was connected initially.

Also, if you notice the connected ad-hoc sheet, the dimension name for which it is throwing the error message is also displayed in brackets [], i.e. [xyz] in the POV. And when you try to select a member combination for the issue dimension XYZ, the dimension itself is not displayed in the member selector.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.