asked
How to Create an OR Statement in a Cube?
Hi there, How can I represent an 'OR' statement in a cube using SSAS 2008? For example, I have 3 address postcode fields defined, say HOME_PCODE, OFFICE_PCODE, and HEAD_OFFICE_PCODE. If I create a cube and select that I want the result set to show HOME_PCODE like 'AB%' then OFFICE_PCODE like 'AB%' then HEAD_OFFICE_PCODE like 'AB%' I am getting the count results where all postcode fields must start with AB. What I want to see are the count results of if HOME_PCODE like 'AB%' OR OFFICE_PCODE like 'AB%' OR HEAD_OFFICE_PCODE like 'AB%'. Any advice? TIA
Does the "OR" help topic for MDX help you at all? [
http://msdn.microsoft.com/en-us/library/ms145546.aspx][1] [1]:
http://msdn.microsoft.com/en-us/library/ms145546.aspx
14 People are following this question.
