Forecast tree hierarchy test can be done in Demantra 7.3.1?
Hi,
Please advise whether Tree Hierarchy Test Can be done in Demantra 7.3.1? When scan through via Engine Administrator, i could not find any option to run it. Then i tried to run it directly from bin folder and its throwing an exception,
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Checking the hierarchy of the forecast tree of
demantra on DEVDEM01
Number of tree levels: 30
There is always hierarchy between level 1 and 2
since level 1 is the ITEM,LOCATION with is the key of MDP_MATRIX
---------------------------------------------------------------
DB_Command::Execute threw an exception:
select distinct t_ep_spf_latest_rev_id, t_ep_L_ATT_2_EP_ID, t_ep_p2a_EP_ID, t_ep_L_ATT_2_EP_ID from mdp_matrix where (t_ep_spf_latest_rev_id, t_ep_L_ATT_2_EP_ID) in (select t_ep_spf_latest_rev_id, t_ep_L_ATT_2_EP_ID from mdp_matrix where do_aggri = 1 AND (prediction_status in (1,97) OR (prediction_status = 98 and aggri_98=1) OR (prediction_status = 99 and aggri_99=1)) group by t_ep_spf_latest_rev_id, t_ep_L_ATT_2_EP_ID having count(distinct t_ep_p2a_EP_ID) > 1)and do_aggri = 1 AND (prediction_status in (1,97) OR (prediction_status = 98 and aggri_98=1) OR (prediction_status = 99 and aggri_99=1))