Skip to Main Content

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Undo drills and view prompt values warning message on a dashboard page

915764Feb 10 2012 — edited Jun 3 2013
Hi ,

I have created a dashboard with a single page containing two sections. In first section i am having a prompted report for region and a Region Dashboard prompt ,
in second section i am having two prompted reports for region , i mean region dashboard prompt drives all other reports in that page. When ever I select a region from the dashboard prompt i am seeing message on Dashboard page as **"_Undo drills and view prompt values_"**


If any one having the solution let me know in detail,How to overcome this.......

Comments

164043
Ricardo, you can do that from CURL extension. You can set options via curl_setopt and
retrieve it with curl_multi_getcontent. Here is the man page:

http://hr.php.net/manual/en/ref.curl.php

Good luck.
I'll track down someone in the CRM on Demand group and get some background. But as I understand it at the moment, everything is available as a webservice, and the wsdl files are available on http://download.oracle.com/docs/cd/E14004_01/books/CRMWeb.zip Googling will give plenty of online references about using PHP to consume web services.

Documentation is at http://download.oracle.com/docs/cd/E14004_01/books/CRMWeb/CRMWeb81TOC.html
(The documentation portal with these references is at http://download.oracle.com/docs/cd/E14004_01/homepage.htm )
679538
Thanks, I reviewed the links, please, Can you give me some examples of how connect to CRM On Demand with PHP?
164043
I cannot speak for Chris but connecting to web server is essentially the same, regardless of the service provided by the web server. CURL and some parsing is what I would do in your position. Of course, I am not in your position.
164043
You can also use http_request PEAR package. The documentation is here:
http://pear.php.net/manual/en/package.http.http-request.php
751573
This is in PHP and will return the session ID.

$this->crmdomain points to your URL.

function login() {

$url = $this->crmdomain . "/Services/Integration?command=login";
$page = "/Services/Integration?command=login";
$headers = array("GET ".$page." HTTP/1.0",
"UserName: YOUR USERNAME",
"Password: YOUR PASSWORD",
);

$this->ch = curl_init();
curl_setopt($this->ch, CURLOPT_URL,$url);
curl_setopt($this->ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($this->ch, CURLOPT_HTTPHEADER, $headers);
curl_setopt($this->ch, CURLOPT_SSL_VERIFYPEER, FALSE);
curl_setopt($this->ch, CURLOPT_SSL_VERIFYHOST, FALSE);
curl_setopt($this->ch, CURLOPT_HEADER, true);
$data = curl_exec($this->ch);


if (!curl_errno($this->ch)) {
$SessionId = substr($data,(strpos($data,"Set-Cookie:")+23),(strpos($data,";")-strpos($data,"Set-Cookie:")-23));
curl_close($this->ch);
return $SessionId;
} else {
return(0);
}

}//endof
1 - 6
Locked Post
New comments cannot be posted to this locked post.