Problem Note 61742: The NEXT_DETAIL_SK variable is incorrect in the CXTWH.Business_process_step_details table and you cannot obtain any matches
 |  |  |  |  |
The variable NEXT_DETAIL_SK is incorrect in the CXTWH.Business_process_step_details table. You need to multiply by 1000, as shown in the following example, in order to obtain any matches when you try to reference and pull data from code:
Select to_char(a.session_sk)as Session_SK,TO_CHAR(a.detail_SK) as detail_SK, TO_CHAR(a.next_detail_SK);as Next_detail_SK, process_dttm,
Step_order_no, B.*, is_completion_flg, is_start_flg, page_url_txt as next_page_url_txt
From Business_process_step_details A
Left Join Business_process_step_dim B on A.process_step_sk = B.process_step_sk
Left Join detail_fact c on C.detail_SK=a.next_detail_SK*1000
Left Join page_dim d on c.page_sk=d.page_sk
WHERE process_dttm >= TO_DATE('26/JAN/2017 00:00:00', 'dd/mon/yyyy HH24:MI:SS')
AND process_dttm < TO_DATE('26/JAN/2017 01:00:00', 'dd/mon/yyyy HH24:MI:SS')
Step_order_no, B.*, is_completion_flg, is_start_flg, page_url_txt as next_page_url_txt
From Business_process_step_details A
Left Join Business_process_step_dim B on A.process_step_sk = B.process_step_sk
Left Join detail_fact c on C.detail_SK=a.next_detail_SK*1000
Left Join page_dim d on c.page_sk=d.page_sk
WHERE process_dttm >= TO_DATE('26/JAN/2017 00:00:00', 'dd/mon/yyyy HH24:MI:SS')
AND process_dttm < TO_DATE('26/JAN/2017 01:00:00', 'dd/mon/yyyy HH24:MI:SS')
Be sure to keep this issue in mind when you are working in the data set.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS Customer Intelligence 360 | N/A | ||
A fix for this issue for SAS Customer Experience Targeting Server 6.4 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/Y67.html#61742| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2018-04-16 10:39:08 |
| Date Created: | 2018-01-24 08:59:58 |