Wednesday, May 4, 2016

Oracle DVD - Data Visualization Desktop with Analysis as source

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.


6 comments:

  1. Wow really superb content. Definitely it will be useful for capturing whatever we want. And please let people to know like these type of techniques.

    Hadoop Training in Chennai

    ReplyDelete
  2. Great post! glad to find your blog. Thanks for sharing.

    seo institute in chennai

    ReplyDelete
  3. Hello,

    could you tell me the version of OBIApps when you test DVD with OBIEE 11.1.1.9?

    thank you guy

    ReplyDelete
    Replies
    1. No OBIApps, just my local 11.1.1.9 installation.

      Delete
  4. cam we connect On premise with OBIEE 11.1.1.9?

    ReplyDelete
    Replies
    1. 11.1.1.9 should work. 11.1.1.7 not.

      Delete