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')
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
SAS System | SAS Customer Intelligence 360 | N/A | | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2018-04-16 10:39:08 |
Date Created: | 2018-01-24 08:59:58 |