We have a dimension called Organization - as of this year this Organization now has multiple organizations in it. The problem - that Essbase requires unique names - So Organization for TOTE is TOTE Organization and Organization for CompanyB is CompanyB Organization.
The problem - we cannot see/use "Organization" when in Query Design - but we CAN if we use it in AdHoc?
Is this a problem with how the organization alias is applied? Does smart view 220.127.116.11.103 have a problem with alias's?
Organization is the dim, but TOTE Org... or CompanyB Org are the alias's.