Custom Parameters

Hi Larry,

Thanks for reaching out. I agree we should have more public-facing documentation regarding this, and I will request for this to happen, but in the mean time I do have an example from internal documentation:

Custom Parameter is used in report builder via Link to URL option.

Use: We can store a URL or a part of URL as a parameter in Yellowfin and use that parameter in the report instead of adding the URL in every report

1.Go to Admin Console --> Configuration --> System tab --> Custom Parameters

Give variable name : eg : TESTPARAM

Give the link: eg: www.google.com.au/

2.Click on '+'

3. Save it.

4. Create a report. Drag and drop dimensions and metrics. Go to Format option of any of the columns

5. Change Format to "Link to URL"

4. Give the URL:

https://${TESTPARAM}

Parameter should be given as: ${parameter}

5. Click on the 'X' to save it5. Now Booking Method is displayed as hyperlink.

6. When we hover over it, we can see the URL is shown at left bottom

7. If we click o the data, it navigates to the URL

Hopefully this helps!

Please let me know if you have any other questions on this as you're going through it.

Regards, Mike

Mike, this is terrific! You can just ask someone to copy and paste your excellent tutorial, IMO. I spoke with someone that tried this and it mostly worked out for them. They believe that they have a syntax error but stated that trying to also pass the column value by adding ## did not work. Perhaps that's a caveat to using custom parameters, you cannot also pass in the column value. If that's the case then this won't work for my partners. Still a great tutorial!

Hi Larry,

Thanks for your response. I've reached out to the appropriate party about adding this to our Wiki.

Please let me know if you have any other questions or if we're okay to close this case out for now then.

Regards, Mike

Mike,

This does resolve the issue but I wanted to confirm if ## works along with custom parameters or not.

Hi Larry,

Sorry about that. I can confirm this does not work in the Custom Parameters section. I've gone ahead and created an Idea post and submitted an enhancement request for this. You can reference the Idea post here.

Any potential updates regarding this will be posted there. As such, I'll go ahead and Resolve this Question item.

Regards,

Mike

Forgive me while I dredge this back up. :)

I have the following situation occurring.

• Custom Parameter = ww2.crediblebh.com/client/my_cw_clients.asp?client_id=
• Format in Report = https://${ClientURL}/##
• Result in Report = https://%24{clienturl}2016644/

After this failed experiment, I changed to the following:

• Custom Parameter = ww2.crediblebh.com
• Format in Report = https://${ClientURL}/client/my_cw_clients.asp?client_id=##
• Result in Report = https://%24{clienturl}/client/my_cw_clients.asp?client_id=2016644

In both cases, the resulting URL sent to the browser = https://%24%7Bclienturl%7D/client/my_cw_clients.asp?client_id=2016644 with the url encoding showing. What am I missing?

Hi Jason,

Thanks for reaching out. What version and build of Yellowfin are you on?

Regards,

Mike

I am using BI within the Credible framework. I am not certain how to tell which version/build I am on. Any tips on how to find that information?