ariel20029
Board Regular
- Joined
- Jun 20, 2013
- Messages
- 97
Hi all,
I am trying to write a case in OBIEE for the first time. It does not like what I am doing. Can you take a look? I am trying to write a case based on the customer name ( we have about 15 special names give or take) that need to be identified, the rest get assigned to a category called ROW. ( Rest of World)
We have some customers that are customer name specific as to what template to use .. For example: CAT Supply,LLC used the CAT template were CAT Solutions will use the ROW template- otherwise a contain the customer name would work.
Also ,What would the formula look like for a line that would say contain Rabbit anywhere in the customer name?
CASE 'ABC VSOE Extract'.'Customer'.'Template'
<colgroup><col span="8"></colgroup><tbody>
</tbody> I think its the CASE line that is the problem. The sample I looked at was over simplified.
thank you for your help and guidance.
Sharon
I am trying to write a case in OBIEE for the first time. It does not like what I am doing. Can you take a look? I am trying to write a case based on the customer name ( we have about 15 special names give or take) that need to be identified, the rest get assigned to a category called ROW. ( Rest of World)
We have some customers that are customer name specific as to what template to use .. For example: CAT Supply,LLC used the CAT template were CAT Solutions will use the ROW template- otherwise a contain the customer name would work.
Also ,What would the formula look like for a line that would say contain Rabbit anywhere in the customer name?
CASE 'ABC VSOE Extract'.'Customer'.'Template'
WHEN Customer 'CAT SUPPLY I, LLC' THEN 'CAT' | |||||||
WHEN Customer 'CAT DIVERSIFIED GROUP' THEN 'CAT' | |||||||
WHEN Customer 'CAT MOBILITY' THEN 'CAT' | |||||||
WHEN Customer 'CAT SERVICES, INC.' THEN 'CAT' | |||||||
WHEN Customer 'CAT GLOBAL PUBLIC SECTOR SOLUTIONS' THEN 'ROW' | |||||||
WHEN Customer 'CAT SOLUTIONS CENTER' THEN 'ROW' | |||||||
WHEN Customer 'CAT SOLUTIONS INC.' THEN 'ROW' | |||||||
WHEN Customer 'DOG BUSINESS PURCHASING' THEN 'ROW' | |||||||
WHEN Customer 'DOG BUSINESS PURCHASING LLC' THEN 'ROW' | |||||||
ELSE 'ROW' | |||||||
END |
<colgroup><col span="8"></colgroup><tbody>
</tbody>
thank you for your help and guidance.
Sharon