topic Re: Documentation for blueprints? ( Missing join ) in Data & Schema Discussions

Documentation for blueprints? ( Missing join )

RADSr — Tue, 08 Nov 2022 16:43:42 GMT

I've got an issue w/ out Oracle EBS blueprint missing some joins ( first up GL_LEDGERS to JE_GL_PERIODS ) and I'd like to confirm the join criteria.

Is there any documentation available where I can look this up?

Re: Documentation for blueprints? ( Missing join )

amit_kothari — Tue, 08 Nov 2022 20:29:33 GMT

Hi Randy - There is no direct join between GL_LEDGERS to JE_GL_PERIODS (alias of GL_PERIODS), they are associated via the GL_JOURNAL_LINES so add a metric from that table.

Re: Documentation for blueprints? ( Missing join )

RADSr — Tue, 08 Nov 2022 21:27:07 GMT

Thanks Amit,

Just pulling the "Period" table from the business schema but adding in "Net Sales" from "Income Statement" returns a result.

I have a similar issue with "Account" which throws errors -- again rectified when I add net sales.

Our goal is to expose this data to IBM's TM1 via the external BI Tools configuration, but it looks like we'll need to author "feeder" queries in the Analyzer interface and then copy the external SQL. Is that the best/recommended approach?

Thank you!