Add Data model to OPI scenario

[qurm]

I am trying to add a Data Model to OPI. The documentation does not make is clear what is required in the table structure, except a "key field". I tried with a simple table like below, with a PROCESS_INSTANCE_ID key field, and the data model can be configured OK. However on Generate, the current context view is modified and ends up being corrupted ("Open failed: cannot read the input file"). The old solution I have found is to revert to a previous version using Replace With, Local History, ...

1. Why does the Generation modify the context view? I would expect that the Data Model is separate to that?
2. The Generate creates a new table definition named like

SPVR_MNTCE1__238047043_CTX.hdbtable in the project. Is this normal and what is its purpose.

3. Can anyone supply a working table structure as a starting point for an OPI Data Model?

I am using HANA SPS 11, OPI SPS 12

Thanks, Andy

[qurm · Accepted solution]

Just to close this off for other readers - the Data Model feature in OPI is apparently deprecated from HANA SPS12, and it is not recommended to use it. I heard this from the OPI Product team.

Andy