Categories
- All Categories
- 127 Oracle Analytics News
- 23 Oracle Analytics Videos
- 14.5K Oracle Analytics Forums
- 5.5K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 47 Oracle Analytics Trainings
- 7 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 8 Oracle Analytics Industry
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
w_AP_INV_DIST_F/PRODUCT_WID values are zero's

7688438
Rank 5 - Community Champion
Hi All, w_AP_INV_DIST_F/PRODUCT_WID was populated as zeros for most of the records Because of this the product categories spend counts data is not matching with EBS source. select COUNT(*) FROM W_AP_INV_DIST_F T596283 WHERE TO_CHAR(TO_DATE(POSTED_ON_DT_WID,'YYYYMMDD'),'YYYY')='2015' AND T596283.PRODUCT_WID=0; --1,754,949 ODI out of the box formula:-
Any Changes or customization on this code???
Thanks
R
0