Good Morning Experts.
I was able to successfully browse the SQL of a Bex query (transaction RSRT1), copy and tweak it to run in SQL*Plus(Oracle).
Since the tables to the cube in question are normalized ad nauseum, I need to get to the next level of tables and joins to retrieve real data, and not just the SIDs.
Can anyone suggest how to get to the 'master data' to complete the display of the query?
Many Thanks
AA 8~)
I was able to successfully browse the SQL of a Bex query (transaction RSRT1), copy and tweak it to run in SQL*Plus(Oracle).
Since the tables to the cube in question are normalized ad nauseum, I need to get to the next level of tables and joins to retrieve real data, and not just the SIDs.
Can anyone suggest how to get to the 'master data' to complete the display of the query?
Many Thanks
AA 8~)