Tips for Hyperlink Expression Window

Use the view items and functions to define your hyperlink expression by clicking on or dragging and dropping the item into the Expression area. You can also key text directly into the Expression portion of the window.

Build your expression using URL’s alone or in combination with items from the view. The evaluated expression will be an active hyperlink when the measure item is clicked on. The hyperlink can direct users to other applications, websites or views.

Enclose your entire expression in quotation marks.

See below for example hyperlink expressions that:    

Click Validate at any point to verify whether or not the format of your expression is valid.

Example – Open a Website and Pass View Information to Website

Example 1

This example uses a URL only in the hyperlink expression. Clicking the hyperlink in the related view will access the Mapquest home page.

"http://www.mapquest.com"

Example 2 and 3

The next examples include view information in the hyperlink expression. In the first example, several attribute relationships for Customer Sold-To are used in the expression. The city, state, and postal code information derived from the current member are used as parameter values in the URL.

"http://www.mapquest.com/maps/map.adp?&city=" + [Customer Sold-To].[Customer Sold-To].CurrentMember.Properties("SldTo City") + "&state=" + [Customer Sold-To].[Customer Sold-To].CurrentMember.Properties("SldTo Province State") + "&zipcode=" + [Customer Sold-To].[Customer Sold-To].CurrentMember.Properties("SldTo Postal Code") + "&country=US&cid=lfmaplink"

The second example has syntax that first checks to see if a particular attribute relationship exists. If so, the hyperlink opens to Google and searches on that attribute relationship. The SldTo Long Description is the attribute relationship used in the expression.

Iif([Customer Sold-To].[Customer Sold-To].CurrentMember.Properties("SldTo Long Description")=null, null, "http://www.google.com/search?hl=en&q=" + [Customer Sold-To].[Customer Sold-To].CurrentMember.Properties("SldTo Long Description"))

Example – Run another View and Filter it with Member Information from Original View

Example 1

This example opens another view and runs it based on that view definition only. The Stratum.Viewer URL and ID for the view are used in the expression. See also Passing Parameters into Views via URL’s for additional parameters that can be used in these expressions.

“http://silvonxyz:60001/ViewWindow.aspx?ViewId=10391”

Here is a view containing the hyperlink.

Here is the other view, Revenue Trending by Customer, which will open and prompt you to choose a sales director for which you want to see view data. The prompting comes from parameters tied to a level in the View Filter of the view.

Example 2

The previous expression is then adjusted to pass sales director information from the original view to the other view. The hyperlink will open the view and filter it for the sales director associated with the measure item value that was clicked.

"http://silvonxyz:60001/ViewWindow.aspx?ViewId=10391&vp:SalesDirector="+[Sales Director].[Sales Director].CurrentMember.name+ ""

The hyperlink is clicked for the measure item value of sales director Steve Mentas.

The trending view opens and is filtered for that particular sales director. No prompting to choose a parameter occurs because the hyperlink determines the sales director to use in the filter.