@CalcMgrDBSelect to return members for FIX statement
I am trying to determine what this function returns. I am not finding much documentation on the @CalcMbrDBSelect function, but I thought it would return a list from the select. For example
Fix(@REMOVE(@children("XXXX"),@LIST(@CalcMgrDBExist("62s045678GtTC7zGrDGeiB", "XLcZtWGGLd5555509pX4SKfk2qHCXcWCaNtfmYfABOcx7x/NzidAQe1qZfK3mBpR", "H/kEEOQQAycdrMHuLdZ55555LFrXv+uWzrsiYS97K85alW3FA26WYsIFU3gEBxip", "jdbc:sqlserver://Server name:1433;databaseName=Corp", "SELECT DISTINCT a.OBJECT_NAME AS E1 FROM HSP_COLUMN_DETAIL INNER JOIN HSP_COLUMN_DETAIL_ITEM ON HSP_COLUMN_DETAIL.DETAIL_ID = HSP_COLUMN_DETAIL_ITEM.DETAIL_ID INNER JOIN HSP_OBJECT AS s ON HSP_COLUMN_DETAIL.DIM1 = s.OBJECT_ID INNER JOIN HSP_OBJECT AS a ON HSP_COLUMN_DETAIL.DIM2 = a.OBJECT_ID INNER JOIN HSP_OBJECT AS v ON HSP_COLUMN_DETAIL.DIM5 = v.OBJECT_ID INNER JOIN HSP_OBJECT AS y ON HSP_COLUMN_DETAIL.DIM6 = y.OBJECT_ID WHERE s.OBJECT_NAME = 'Budget' AND y.OBJECT_NAME = 'FY20' AND v.OBJECT_NAME = 'Final'" , "")))))