How to pass selector value from one Dossier to another without using Prompt and Custom SDK?
Hello All,
As we all know that now hashtag#MSTR is more focused on Dossier and clients want to build the dashboard more in Dossier then traditional RSD.
So, Have you ever come across a requirement where you need to pass the selector value from one Dossier to another Dossier like we used to do in RSD.
Note: Using the prompt to pass value is not a good option as the user needs to change the selector value in 2nd Dossier as well.
Till now I have seen the developers were using prompt to pass the value from one dossier to another. But today I am going to show you how to pass a selector value from one dossier to another without using the prompt option and also without any custom SDK.
Example: It should be like 2nd dossier should be selected as Year=2017 and Month=Feb (as we have selected the same in Dossier 1) but we should also get the other elements in 2nd dossier to filter the data.
Below is a working example:
YouTube Video Link: https://www.youtube.com/watch?v=TQh7Dluv_4M&feature=youtu.be
You have to use URL API to pass the selector value like below:
Main.aspx?evt=2048001&documentID=860B3212426663EFECAC62A6A8B32763&originMessageID=ACC4C5234BBCCA3CAA16F59127118555&selectorMode=2
Replace documentID with your Dossier ID and replace originMessageID with anything like with 0 or 1 or ABC123 it doesn't matter but you have to include originMessageID. And Use selectorMode=2.
Here is a working Example:
I hope this will help you in your real-time project.
Please follow my blog and Youtube Channel you like this.
This comment has been removed by the author.
ReplyDeleteNice Post. It helps. Few questions,
Delete* Is this will work only for Dossier? Because while trying in VI Dashboards its not working.
* Do we have any restriction on the type of filter to be used to apply this?
Thanks in advance
I didn't try this with VI Dashboard.
DeleteAlso, in Dossier I didn't face any issue for any kind of filter.
Awesome ! It works!
ReplyDeleteIt worked for me when I changed selector mode to 1.
ReplyDeleteNice to hear
DeleteWill the same link syntax work if I am using Tomcat?
ReplyDeleteAlso, can child dashboard opens up in a new tab, is there a way to open in the same tab?
No syntax will be different for tomcat server. please check any URL API doc for changing the syntax for JSP.
DeleteAnd regarding opening the dashboard in same tab, I haven't tried that. but let me see and will response you back on this.
Will this work on library as well?, I tried but not working. Can you help
ReplyDeleteThis URL API doesn't work on Library. Library is a different platform within MSTR and it doesn't allow URL API which work on MSTR Web.
DeleteThanks for your information. very good article.
ReplyDeleteMicrostrategy Online Course
Microstrategy Certification
Hi Amit,
ReplyDeleteThis is not working for my dossier. Below url construct throws an error "You have included an invalid argument.".
When i remove the &originMessageID=A, the url link opens the desired dossier but without passing filter values.
My URL API:
mstrWeb?evt=2048001&documentID=8F72DDF511EC9E44465F0080EF454F56&originMessageID=A&selectorMode=2
Some else contacted me and shared his issue and I re-created this again and it is working fine in my side. Have you added this URL Api in Text box edit link? Because I added below in the Text box edit link and it is passing value correctly:
DeletemstrWeb?evt=2048001&documentID=6429903C4B49741DE75B788F6809F707&originMessageID=AC&selectorMode=2
nice information thanks for sharing..!
ReplyDeletemicro strategy certification training