ASO Question

Summary

ASO Question

Content

Hello fellos,

In ASOSamp.Sample, I have added a another hierarchy under Geography dimension called "CA_View" and also added member "ALBANY - CA" as shared underneath.

when i run below MDX query, I am expecting a parent memebrs for "ALBANY - CA" as "CA" and "CA_View" however I am getting only "CA".

Can anyone help me here...

SELECT

{Oct} on COLUMNS,

{Parent ([Geography].[ALBANY - CA])}

ON ROWS

FROM

  [ASOSamp.Sample]

Thanks,