The Function RSibling(YZ) Used in Form Layout Rows Returns 'YZ' Member Name When 'YZ' Member is the Last Member in the Hierarchy (Doc ID 2898603.1)

Last updated on OCTOBER 07, 2022

Applies to:

Symptoms

Function RSibling() When used with the last member in the hierarchy

For Example:

Dimension : Alpha 

                     |_ABC

                     |_DEF

                     |_GHI

                     |_JKL

                     |_MNO

                     |_PQR

                     |_STU

                     |_VWX

                     |_YZ

RSibling(YZ) used on the row selection in a form  gives the following error :

"You are trying to open the form, but cannot because all of the required dimensions are not present. Possible causes may be that you do not have access to at least one member of a required dimension, or the member selection resulted in no members present. You might be missing the dimension Date or its members. Contact your administrator"

This is expected error message as there are no Right siblings for member "YZ" in the above hierarchy example 

However this works if we enable Suppress missing data on the Rows:

RSibling(YZ) along with Suppress missing data option turned on on the rows will return YZ member 

As per the RSibling function definition this should return null and give us the same error as above when we try to access /open the web form

• When we uncheck the Grid Properties: Suppress missing data - Rows.

Opening The Form the error will say: " You are trying to open the form, but cannot because all of the required dimensions are not present. Possible causes may be that you do not have access to at least one member of a required dimension, or the member selection resulted in no members present. You might be missing the dimension Date or its members. Contact your administrator "

• When we check the Grid Properties: Suppress missing data - Rows

 Because YZ had data => The Form opens up and data displayed.

• Note: In the environment, if YZ member has no data, the message will say: There are no valid rows of data for this form.

Changes

Cause

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