Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

need to pull the information from two facts and associated dimensions

1001166Apr 4 2013 — edited Apr 8 2013
HI All, i need to pull all the columns from the two Facts and their associated dimensions, get the results.

here is the example:

Fact1 --> D1, D2, D3
FACT2--> DA, DB, DC, D1

D1 Dimension has a Join with two fact tables, as long as i'm using columns from D1 and FACT2, DA, DB, DC report works.

but my requirement is to get the results when pulling the columns from all the dimensions and two facts like Fact1, FACT2, D1, D2, D3, DA, DB, DC

how to achieve this requirement, can someone pls help me with this.

your responses are much appreciated.

Thanks
rar

Comments

Timo Hahn

User, tell us your exact JDev version, please!
Look like you did not change the proxy to use HTTPS too. The log shows that HTTP is still used to access the service.
Timo

Eugen Lang

@timo-hahn1 JDev - Studio Edition Version 12.2.1.0.0
The log shows that HTTP is still used to access the service - you understood this from the line Service Name: http://xmlns.oracle.com..... ?
Thank you!

Timo Hahn

Yes, you said you changed everything to HTTPS. So when I see something about HTTP I start thinking...
Have you tried to reach the service using some external tool like SoapUI using HTTPS?
If you can reach the service this way, you know that it's not the service part, but the calling part, and investigate there.

Timo

Eugen Lang

@timo-hahn1 Thank you for answer! Yes I am trying to access a service using SOAP. Yes, I noticed that one parameter in the proxy settings has not changed. And when you change it, it changes but is not saved (changed the link -> clicked save -> closed the settings window -> opened the settings window again = the value was the same) Why can't it be changed?
not change.pngchange 2.png
in the second screenshot, I changed the url and saved it. But it doesn't save.

Timo Hahn

Have you tried to refresh the WSDL, the checkbox above the WSDL location?
You are working on a copy of the WSDL and only get changes once you update this local copy.

Timo

Eugen Lang

@timo-hahn1 Yes, I checked the box, an error occurs (screenshot).
change 3.png

Eugen Lang

@timo-hahn1 I just now noticed that I still have such an error in my vlogs - maybe this is the reason for what is happening?

loglog.png

Timo Hahn

This can be the problem. You should investigate the LDAP problem anyway.

Timo

Eugen Lang

@timo-hahn1 Thank you!

1 - 9
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 6 2013
Added on Apr 4 2013
#11g, #business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #obiee
15 comments
403 views