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'
[TABLE="width: 512"]
<colgroup><col span="8"></colgroup><tbody>[TR]
[TD="colspan: 6"]WHEN Customer 'CAT SUPPLY I, LLC' THEN 'CAT'[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 6"]WHEN Customer 'CAT DIVERSIFIED GROUP' THEN 'CAT'[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 6"]WHEN Customer 'CAT MOBILITY' THEN 'CAT'[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 6"]WHEN Customer 'CAT SERVICES, INC.' THEN 'CAT'[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 8"]WHEN Customer 'CAT GLOBAL PUBLIC SECTOR SOLUTIONS' THEN 'ROW'[/TD]
[/TR]
[TR]
[TD="colspan: 8"]WHEN Customer 'CAT SOLUTIONS CENTER' THEN 'ROW'[/TD]
[/TR]
[TR]
[TD="colspan: 8"]WHEN Customer 'CAT SOLUTIONS INC.' THEN 'ROW'[/TD]
[/TR]
[TR]
[TD="colspan: 8"]WHEN Customer 'DOG BUSINESS PURCHASING' THEN 'ROW'[/TD]
[/TR]
[TR]
[TD="colspan: 8"]WHEN Customer 'DOG BUSINESS PURCHASING LLC' THEN 'ROW'[/TD]
[/TR]
[TR]
[TD="colspan: 2"]ELSE 'ROW'[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]END[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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'
[TABLE="width: 512"]
<colgroup><col span="8"></colgroup><tbody>[TR]
[TD="colspan: 6"]WHEN Customer 'CAT SUPPLY I, LLC' THEN 'CAT'[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 6"]WHEN Customer 'CAT DIVERSIFIED GROUP' THEN 'CAT'[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 6"]WHEN Customer 'CAT MOBILITY' THEN 'CAT'[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 6"]WHEN Customer 'CAT SERVICES, INC.' THEN 'CAT'[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 8"]WHEN Customer 'CAT GLOBAL PUBLIC SECTOR SOLUTIONS' THEN 'ROW'[/TD]
[/TR]
[TR]
[TD="colspan: 8"]WHEN Customer 'CAT SOLUTIONS CENTER' THEN 'ROW'[/TD]
[/TR]
[TR]
[TD="colspan: 8"]WHEN Customer 'CAT SOLUTIONS INC.' THEN 'ROW'[/TD]
[/TR]
[TR]
[TD="colspan: 8"]WHEN Customer 'DOG BUSINESS PURCHASING' THEN 'ROW'[/TD]
[/TR]
[TR]
[TD="colspan: 8"]WHEN Customer 'DOG BUSINESS PURCHASING LLC' THEN 'ROW'[/TD]
[/TR]
[TR]
[TD="colspan: 2"]ELSE 'ROW'[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]END[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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