I have a dimension DimDepartmentName
which has the following fields
ParentDepID - references back to DimDepartmentName.DepID - Will be blank if it is a parent. This field is set to ParentIsBlankSelfOrMissing in the cube.
I need retrieve the departmentname & depid only when it is a parent.
I am trying to write the mdx query based on the parent level but it does not work.
Any help is appreciated.
View Complete Post