0

Field is not appearing in the custom view in Data Warehouse

Hafiz Syed Danish Akhter

June 25, 2020 12:27

None

Follow

I have added a field from source(Ax) to Stage(JetAxStagev30) table name PROJTable and then deploy & execute then I have dragged this field into DWH( JetAxDwhv30) and then deploy & execute finally I had to call this field in my custom view but when I added this field in the view and then deploy it throws an error that this field does not exist in a specific table.so please any suggest solution

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  JaeW_atOnyx July 14, 2020 10:14

  Hafiz Syed Danish Akhter, I'm sure you figured it out by now, but what does the table look like in SSMS??

  This is always my first test when things in Jet aren't going right.

   

  Pay special attention when constructing your View whether you're building against the _R, raw, vs _V valid table.  Depending on how your transformed are applied, it can cause discrepancies in results!

   

  jae@onyxReporting.com