One parameter for multiple information links

[Thomas Carlough 2]

Good Morning,

I have one analysis using 6 or 7 information links and would like to set the date range for all information links using a single parameter or filter. Is there a way to do this either at runtime or before hand with a single action

 

Thank you,

 

Tom

[christopher sawtelle 2]

If you are using a common date column element for each infolink then you could make a filter and add it to each infolink.

[Thomas Carlough 2]

I was asking if there was a way to do this for all of them at once. I may want to change the date often but I want each info link to use a single date range.

 

Each will be a date but the column it comes from will differ.

[Sean Riley]

If you set up the 7 tables as on-demand data tables, you can set the input parameter to be the same document property. That way you can update the document property and all information links will be updated based on that shared value.

[Sean Buechele 2]

Has there been any development on this I have also been trying to figure this out. I have common columns across several incoming info links and want to be able to just filter/prompt "Date" once and not have to click through 7 menus applying the same prompt over and over. Thanks in advance!

[Nag P]

Hello,

 

I have the same question, can any one answer how to pass single parameter value for all information links

 

 

[konan thomason]

Has anyone found a solution for this issue I have the same situation where I have 7 tables adding data and I don't want to be prompted repeatedly for the same value.

 

Thanks,

[Enkeled Kanaj]

Anyone has found a solution to this problem? having several prompts with same value like date and other dimensions. 

[Olivier Keugue Tadaa]

Hi Enke 

Have you tried this solution from @Sean Riley?

Quote

If you set up the 7 tables as on-demand data tables, you can set the input parameter to be the same document property. That way you can update the document property and all information links will be updated based on that shared value.

 

Other options are :

• a script with Iron Python
• adding a parameter on the Information links with the same name (via the filter section or by editing the underlying SQL with the "condition=?parameter_name" syntax)

 

I hope this helps

Edited July 11 by Olivier Keugue Tadaa

[David Boot-Olazabal]

Hi,

You can make this happen, if you change the SQL of your information links directly. By doing so, you can add prompts in the WHERE clause that override the ones you create in the information link's prompts/filters settings.
By adding a code like (Date = ?Date) in the WHERE clause, you can set up a prompt. If you would do this for all your information links, this is how it would look like (example of 2 information links):

Info link 1
Select Region, State, City, Person, Birthdate
From Geo
Where
(Birthdate = ?Date)

Info link2
Select Order, Product, Purchasedate
From Orders
Where
(Purchasedate= ?Date)

Now, if you save your analysis file and reopen it, you will get the Date prompt only once, allowing you to render data for all information links with the same filter on Date.

Kind regards,

David

[Olivier Keugue Tadaa]

Thanks David,

This illustrates the second option below 👇. 

1 hour ago, Olivier Keugue Tadaa said:

Hi Enke 

Have you tried this solution from @Sean Riley?

 

Other options are :

• a script with Iron Python
• adding a parameter on the Information links with the same name (via the filter section or by editing the underlying SQL with the "condition=?parameter_name" syntax)

 

I hope this helps

 

[Enkeled Kanaj]

Please can you explain a little bit further how to do this without modifying sql. I am new to this tool

 

Thank you

[Olivier Keugue Tadaa]

Hi Enke

Yes, you can proceed like this to avoid modifying the SQL, which is something we don't want after all.

Add the filter value as a ?parameter and click refresh the parameter to check the name and the data type as well as the values type

repeat this for all your information links 

You will be prompted only once when you reopen your dashboard.

 

Note that this approach is a programmatic one and the value can also be provided using API calls or configuration blocks (see here for more information about configuration blocks

I hope it helps

Let me know how it worked 

Cheers

Edited July 11 by Olivier Keugue Tadaa

[Enkeled Kanaj]

What about the prompt tab? Shold I fill it?

[Enkeled Kanaj]

It did not work. It requested two times again and showed in listing only the value I entered during the testing

[Olivier Keugue Tadaa]

41 minutes ago, Enke said:

What about the prompt tab? Shold I fill it?

The prompts will not achieve what you need. 

[Olivier Keugue Tadaa]

32 minutes ago, Enke said:

It did not work. It requested two times again and showed in listing only the value I entered during the testing

hmm. it works on my example. check the parameter names and data types

[Enkeled Kanaj]

Yes, it works without prompts but that needs to include only one value not all.

 

I used to work with sap bi which was great. This tool is difficult for non proffesionals.

[Olivier Keugue Tadaa]

2 minutes ago, Enke said:

Yes, it works without prompts but that needs to include only one value not all.

 

I used to work with sap bi which was great. This tool is difficult for non proffesionals.

I see. So you have many parameters. What do you mean by "difficult for non-professionals"? You have an intuitive end-user interface for built-in features. Depending on what you need to achieve, we are suggesting alternatives for not out-of-the-box features like this one. You can submit an idea on our idea portal or vote/complete this one https://ideas.spotfire.com/ideas/TS-I-6590 

[Enkeled Kanaj]

Thanks! I voted. In Sap BI when we use the same name and description it automatically merges the prompts of several queries.

 

Also the prompt list should be with a search list. My database have thousand nodes (elements). We are using this for telecominication KPIs. Why should we scroll down to find the name this primitive way.

 

Include this idea too please.

 

Thank you!

[Olivier Keugue Tadaa]

Thanks for your feedback. 

[Enkeled Kanaj]

Hi Oliver,

 

I solved it! I took the same idea from SAP BI called taking dimensions from another query. On demand setting I defined Input from the one main information link configured with prompt. all other Information Links left without prompts but taking as input the column from the information link with prompt.

 

Edited July 12 by Enke

[Olivier Keugue Tadaa]

Hi Enke, that's fantastic and even better than the first option based on document properties for on-demand settings. Thanks a lot for sharing this trick. It was a good brainstorming session indeed.  

[Enkeled Kanaj]

Hi,

I skipped the prompts at all.  For date I created a text and to "HTML edit" I putted the below html and java script and linked to document properties then to load on demand i linked the range of date to these document properties. All it works prefect. even for the main dimension I created a filter linked to document properties like here (https://support.tibco.com/s/article/How-to-Create-a-Property-Control-Filter-with-Partial-String-Matching) everything is loaded instantly because I have checked load automatically.

HTML

From Date
<span id="fdate">
   <SpotfireControl id="db61d1d0e2eb4742b874ad7b97eafe2d" /> (fromdate to document properties)
</span>
To Date
<span id="tdate">
   <SpotfireControl id="d5c82621435f47e3b0520050518b40ef" /> (todate to document properties)
</span>

Jscript

dateInput = document.querySelector("#fdate input")
dateInput.type="date";
dateInput.onchange = ()=>{dateInput.focus();dateInput.blur();}

dateInput = document.querySelector("#tdate input")
dateInput.type="date";
dateInput.onchange = ()=>{dateInput.focus();dateInput.blur();}