1) Is this results schema supposed to be a blank schema and the tables will be written when the analysis is running or are the tables created during the run? It is not clear to me what we are supposed to see in terms of 'results'
- As far as I understand, yes, results schema is supposed to be a blank one, and after you run Achilles analysis, tables will be created.
2) Can we have the results schema in another database?
- The results schema is always co-located in the same server as the cdm schema. Please see this post for details: http://forums.ohdsi.org/t/oracle-webapi-schema-not-created/4851/6
I am new to this too, and I hope someone who's good at it would confirm it.