With Oracle Data Visualization Desktop we can have 3 types of sources:
File (XLSX Excel), Oracle Applications and Database.
While the Database has an interesting list of options (see the community link
here for "how-to" examples):
I will talk about the "Oracle applications" data source that enables us to have OBI Analysis as data source.
When selecting this option we are hinted about the URL structure:
I filled my OBI 12 server URL, user and Password. Gave the Connection a name:
Next I could select an Analysis (only Analysis, not dashboards...). Did you notice we can also use logic SQL?
Decide what columns are Attributes and Measures and the type of Aggregation for the measures (stayed with the defaults).
And create a Project with it's columns.
I wanted data from 2 Analysis, so I selected another one:
Pressed Add Data source at the bottom:
Created New Data Source:
I could connect to other data sources, but I picked the "From Applications" and selected another Analysis.
Since in both analysis I had "Per Name Year" column the system suggested them as a matching columns:
We always can change our mind later, by selecting "Source Diagram":
And Changing the definition:
Now I can create VA Project from both Analysis.
Please note that in the Canvas setting we can Refresh Data and Data Sources:
One more little test I did, was to connect to OBI 11.1.1.9 as data source. It worked fine.
