Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 218 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 81 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Oracle Data Visualization - Essbase Connection
Summary
Oracle Data Visualization - Essbase Connection
Content
Hi all,
We are trying to use Oracle Data Visualization to create some reports from Essbase.
We are able to create the connection, to select one cube but when we create the project Oracle DV is not showing the dimensions or the members of the Essbase cube.
In some cases (with the Sample.Basic) it shows the dimensions but no members or generations, we can see only the folders for all the dimensions.
In other cases instead we cannot even see the dimensions names, it looks like it is loading but nothing happens.
Has this issue ever happened to someone else? Any idea about how to solve it?
Thanks in advance
Michele
Answers
-
Hyperion Essbase version: 11.1.2.3.505.2
DVD version 12.2.2.2.0-20170208162627
0 -
What version of Essbase(e.g 11.1.2.4.016) and are you on the latest version of DVD?
0 -
Hi Michele,
re-define the connection. instead of using server name in DSN define the IP Address of the server. then you should be able to see the members.
now i can see members after using IP address
** to figure out the issue browse the log file (obis1-diagnostic) under the path :
C:\Users\<UserName>\AppData\Local\Temp\DVDesktop\logs\OBIS
if you see socket communication error in your log file then you have problem connecting Essbase Server , then you IP Address of Essbase Server in the DSN field of the connection. hope this helps you to fix your issue.
0 -
Thank you very much for your help on this, it is working now
0