Join Subject Areas in 11g vs 12c

Question

Hi,

We a requirement to report on two subject areas. I have been doing some search online.

OBIEE TRAINING: querying across multiple subject areas in obiee 11g

Does the folder and column names (i.e. "customer detail"."customer number") have to exact match with the other subject area? Need to be exact same on logical tables as well?

Is there other consideration when joining subject areas?

Are there any significant improvements or new features in 12c comparing with 11g?

Thanks

[Deleted User] · Answer

Yeah I am good at confusing people with even more questions.

Regarding the "enable dimensionality" flag: i am not a fan because it more or less just hides incomplete RPD design and needs to be set in every analysis.

Also as soon as you use anything else but Answers to access the RPD you'll have issues.

BIAP · Answer

Wow...You didn't answer my question, but you broaden my mind about cross-subject modelling...

After some investigation, here are some tips for future readers:

You can only report on measures from multiple facts where all dimensions that are used in the analytic are shared.

Subject areas should have Common Dimensions.

Add at least one metric from each subject area

Turn on the enable dimensionality flag under advanced tab in the analysis.

[Deleted User] · Answer

Cross-subject modeling isnt necessarily tied to literally "joining" things together in the physical layer. You cant "join" a cube and an xml file or a database and a Hadoop cluster. ...or just two simple tables residing in different databases.

I think it would be good to also understand the concept of federated queries and in-memory stitch joins.