question

David 2 1 avatar image
David 2 1 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
sql-server-2008ssascubeor
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

KenJ avatar image KenJ commented ·
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.