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
Date
Votes
1 comment
-
JaeW_atOnyx 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!
Please sign in to leave a comment.