Passing multiple values in url and api
AR
I'm trying to use the api to pass multiple values and bypass the promt
to a report. The report should accept multiple values (like the IN()
clause in a sql statement). However when I try to access the report
through my html page the prompt still shows up. Below is the code for
the html page. Passing multiple parameters did not work so I am
passing one only now. Even this brought up the prompt page which I
don't want to do. I am using the example from what I read in the
developer library documentation. Any help would be appreciated.
<html>
<body>
<form action="http://localhost/MicroStrategy/servlet/mstrWeb"
method="get">
<input type="hidden" name="evt" value="3069"/>
<input type="hidden" name="src" value="mstrWeb.3069"/>
<input type="hidden" name="documentID"
value="97469D8949F586B42D8A30B1D7720689"/>
<input type="hidden" name="viewMode" value="1"/>
<input type="hidden" name="elementPromptAnswers"
value="D7A187DB45E16A0FE3E8CA9EA40BBEC3;D7A187DB45E16A0FE3E8CA9EA40BBEC3:2"/
>
<input type="submit" name="Test" value="Test"/>
</body>
</form>
</html>
Caio Gouveia
What version of MicroStrategy are you using? There are some changes
made to version 8.1.
What is the URL you are using to call this report?
Is the prompt an element or value prompt?
Here are some examples of how you can call it:
In 8.1 you can answer more than one value prompt using the ^ symbol:
For Element prompt you can select multiple answers like this:
http://localhost/microstrategy/asp/Main.aspx?evt=4001&loginReq=true&src=Main.aspx.4001&reportID=D08450DF4E71E2068B9AE78845C1BA28&report
ViewMode=1&elementsPromptAnswers=8D679D4B11D3E4981000E787EC6DE8A4;
8D679D4B11D3E4981000E787EC6DE8A4:4;8D679D4B11D3E4981000E787EC6DE8A4:3
It seems that you are already doing this but without seeing the full
URL is hard to troubleshoot.
Also, is this a document or report?
Cheers,
Caio Gouveia
www.dmeaning.com
Caio Gouveia
Just to confirm that the following URL works fine. You will not be
prompted, and you can choose multiple answsers:
Caio Gouveia
www.dmeaning.com
On Sep 28, 2:07 pm, Caio Gouveia <caio.gouv...@gmail.com> wrote:
> AR,
>
> What version of MicroStrategy are you using? There are some changes
> made to version 8.1.
> What is the URL you are using to call this report?
> Is the prompt an element or value prompt?
>
> Here are some examples of how you can call it:
>
> In 8.1 you can answer more than one value prompt using the ^ symbol:
>
> http://localhost/MicroStrategy/asp/Main.aspx?Server=LON-PMAYA3&Projec...USA
>
> For Element prompt you can select multiple answers like this:
>
> http://localhost/microstrategy/asp/Main.aspx?evt=4001&loginReq=true&s...
> > </html>- Hide quoted text -
>
> - Show quoted text -
AR
Thanks a lot for your help. Apparently the MS documentation had a
typo so that is why our code was not working. Tech support helped
resolve the issue for us.
Another question I had that hopefully you can help with:
I have 2 prompts for one report. We want to pass one prompt's answers
through the URL and have the user hit the second prompt page. Is this
possible? Answering some prompts through the API and answering the
other through the MS prompt page?
Thank you,
AR
On Sep 28, 2:46 pm, Caio Gouveia <caio.gouv...@gmail.com> wrote:
> AR,
>
> Just to confirm that the following URL works fine. You will not be
> prompted, and you can choose multiple answsers:
>
> http://localhost/microstrategy/asp/main.aspx?evt=4001&loginReq=true&s...
>
> Caio Gouveiawww.dmeaning.com
>
> On Sep 28, 2:07 pm, Caio Gouveia <caio.gouv...@gmail.com> wrote:
>
>
>
> > AR,
>
> > What version of MicroStrategy are you using? There are some changes
> > made to version 8.1.
> > What is the URL you are using to call this report?
> > Is the prompt an element or value prompt?
>
> > Here are some examples of how you can call it:
>
> > In 8.1 you can answer more than one value prompt using the ^ symbol:
>
> >http://localhost/MicroStrategy/asp/Main.aspx?Server=LON-PMAYA3&Projec...
>
> > - Show quoted text -- Hide quoted text -
Caio Gouveia
Yes, this is possible. Just pass the answer to one prompt on the URL.
(Same URL I posted before)
MicroStrategy will display the second prompt only.
Caio Gouveia
www.dmeaning.com