Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Logical Column Mapping...!

All,
I have a requirement i need to display same column from Two tables and its a snowflake schema.
I want to display data from AL_FACT_ENG_EBOM and AL_FACT_ENG_EBOM_LEVEL_ZERO same column is available in both the tables..
How can i map same column from both table ?? is it possible to do it??
Hoiw
Answers
-
Not sure about why you would need that or what the use case behind would be if it's in a snowflake, but technically you can only "map same column from both table" - i.e. mapping the two physical columns into one logical column - if you have them coming from two different logical table sources.
You will never ever be able to do it if you just have one LTS with joined tables. It' simply not how the metadata modelling works.
0 -
"I want to display data from AL_FACT_ENG_EBOM and AL_FACT_ENG_EBOM_LEVEL_ZERO same column is available in both the tables.."
Do you mean IF available ... what happens if it is in BOTH tables for the same dimensional intersection? Are the tables at the same grain?
You have a lot of modelling considerations to work out ...
Use drives your design - what is the use case? In business terms ...
0