I have a question related to technical aspect/approach when connecting to Oracle DB from Tableau Prep.
Currently for reporting we are using OBIEE (Oracle Business Intelligence Enterprise Edition), where all models, dimensions and facts are created in repository.
I have connected Tableau Prep to Oracle schema used in RPD, and now I'm wondering about better approach.
I can try to replicate in Tableau Prep repository model connecting all tables as it is in repository and save it as source to which Tableau Desktop will be connected.
Or maybe better solution is to create in Oracle DB separate schema/table where all tables will be connected, and Tableau Desktop will connect to this table.
Where in such situation? Had some design thoughts? Which one can work better?
Retrieving data ...