Skip to Content
0
Feb 08, 2019 at 11:44 AM

Hierarchy input parameter is not working

147 Views

Hi,

I have created one Label Hierarchy in a Calculation view of type Dimension. The hierarchy is working fine. It is used in 3 views. But in one view (Calculation view of type start join) I have used this hierarchy view and have an input parameter on Hierarchy.

When doing a data preview of this view, I am getting one error for the hierarchy input parameter.

"sql processing error: ERROR- Members Rowset failed to search Memebrs. Hierarchy create error for "_SYS_BIC.PACKAGESS/MYVIEW/hier/HIER" error: SQL : column store error:[34023] Instantiation failed."

hierarchy-error-1.png

Please let me know if anyone faced this issue and resolved it.

Regards,

Shawon

Attachments