MDX Query Issue

Apr 25, 2017 7:00AM

Summary

MDX Query Issue

Hello fellows,

I am trying to write an MDX query to pull my cost centers which start with "R" which exists most of them in Level 3 and some of them in Level 2.

My query is able to pull either from Level 2 or Level 3. However, I am also getting other "Cost centers" which are not required.

Can you suggest me how to write a query to pull my cost center which starts with "R" from level 2 and Level 3 without getting other Cost centers?

SELECT {} ON COLUMNS,

Descendants(Costcenter, CostCenter.Levels(3)) ON ROWS

FROM [AppName.Main]

Thanks,