Can Anybody give some clues of how to build JSON as the source for data and build metadata with that?
-- Can the physical layer even connect to data in JSON format?
-- If so can it query it back and forth and apply filters dynamically?
-- If Not, can BIEE connect to, JSON converted to XML as a source and query that?
Any suggestions on how to capture data in JSON format and report in BIEE
Try to check these and look at those doc IDs might help you.