Applying filters to dimension sets might produce the error "Exception ORA-00907: Missing Right Parenthesis"


In SAS® Merchandise Financial Planning 6.8, when applying a filter to a new or existing dimension set, the following error message might occur:

Exception ORA-00907: Missing Right Parenthesis

Workaround

To circumvent this issue, manually select the members to include within the dimension set.

A fix for this issue is planned for a future software release.