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: Instantiation failed."
Please let me know if anyone faced this issue and resolved it.