Filter a cube view based on the dimension element
Posted: Wed Sep 06, 2017 12:30 am
Here are the cube's dimensions:
Year
Version
Department
Month (with an input element)
Items (1 to 20)
Measures
Measure dimension has the following elements:
Employee ID
New Employee
Start Date
End Date
Salary
New Employee element is a flag with Yes/No picklist that is loaded into the input field of Month dimension.
Now the issue. When I create a cube view, I have all the measures displayed. The view will be for input month, one year and one version with departments and items as row dimensions and measures as column dimensions. How do I filter this view to see only new employees? In other words, is there a way to filter a view based on the "Yes" value in the New Employee measure?
Year
Version
Department
Month (with an input element)
Items (1 to 20)
Measures
Measure dimension has the following elements:
Employee ID
New Employee
Start Date
End Date
Salary
New Employee element is a flag with Yes/No picklist that is loaded into the input field of Month dimension.
Now the issue. When I create a cube view, I have all the measures displayed. The view will be for input month, one year and one version with departments and items as row dimensions and measures as column dimensions. How do I filter this view to see only new employees? In other words, is there a way to filter a view based on the "Yes" value in the New Employee measure?