I am looking for feedback on editing and tabular reporting against a versioned enterprise GDB (Oracle, in our case). Over time, we have come to regard an edit version as authoritative: people consult it with the expectation of seeing changes in real time. The edit version is edited daily by ~4 technicians, and then we do a nightly reconcile/post/compress. I have never seen anything "wrong" enough with the edit version that someone asked me not to reconcile and post the day's work. We don't have any versions that persist long-term. The existence of this edit version makes at least two things difficult: one is spatial views, and the other is tabular reporting. Both of these are possible with DEFAULT, but trying to target a specific edit version seems to be another matter entirely. For tabular reporting, we use the method described here: https://gis.stackexchange.com/a/164978/48394, but it's not very performant. Questions for the group: 1. Should we be looking at editing DEFAULT instead? Stop versioning altogether? Pros/cons? 2. Is anyone using spatial views that hit a specific edit version? How? 3. Is anyone doing tabular reporting against a specific edit version, using a method other than that described above? How? Thanks! Andy Andy Smith-Petersen Business System Analyst - GIS Portland Water District Phone: 207-523-5417 E-mail: [log in to unmask] http://www.pwd.org ------------------------------------------------------------------------- This list (NEARC-L) is an unmoderated discussion list for all NEARC Users. If you no longer wish to receive e-mail from this list, you can remove yourself by going to http://s.uconn.edu/nearcsubscribe.