Intra-document Linking and passing parameters

building reports webintelligence
1

Hi Experts,

I have a report with two tabs. I have created a Hyperlink from tab1 to tab2 which works fine.

I want to pass the hyperlinked selection as a parameter from tab1 to tab2. How can I achieve this?

I have read many topics about hyperlinking and passing parameters for two different webi reports(documents) using Opendocument but I couldn’t find how to pass a parameter in hyperlinking from one tab to another.

Any help will be appreciated.

Thanks

Afreen (BOB member since 2016-10-25)

2

I’ve never tried it but you might want to look into building your hyperlink into a table that is used as an input control. That input control can then filter in both tabs (either in a complex way if your version is older or out of the box if you’re on a new enough version of Webi). The fact that you’re hyperlinking between tabs suggests that your version is new enough to use out of the box functionality within input controls to filter across multiple tabs,

3

Thanks Mark. Yes I am using newer version of WEBI. I’ll try your suggested soln. and will update you.

Thanks!!

Afreen (BOB member since 2016-10-25)

4

Just tried this, won`t work, looks like adding an element link and the intradocument link to one cell breaks the element link…

ABILtd :uk: (BOB member since 2006-02-08)

5

Thanks Andy. I’ve not got access to Webi here so can’t test it.

6

Hi Afreen,

Unfortunately, the new Intra-Document Linking feature doesn’t filter the target tab for a specific value, currently it just works as a hyperlink to navigate to a different tab. I’ve created the below Idea or Improvement Request, please vote up on it, and let’s hope they bring in this feature sooner than later.

Update Intra-Document Linking feature to filter data in the target report (or tab)
https://influence.sap.com/sap/ino/#/idea/215286

M H Mohammed :us: (BOB member since 2010-06-16)

7

Thanks Mohammad. I’ll definitely do.

Regards!!

Afreen (BOB member since 2016-10-25)

8

I figured out a small work-around for passing a single value, in case anyone is still around. The trick is to use a Reference Field.

On the Main tab, I have 2 tables.
Table1: “Top 20 Products” with multiple columns and ranked by production quantity.

Table 2: “Selected Product” with just one column [Product Name]. Change the column header to the field [Product Name]. When there’s more than one product the header shows “#MULTIVALUE”. When there is only 1 product in the table, the header shows the Product Name.

In Table 1: Define an Element Link on [Product Name] for Table 2 “Selected Product”. Clicking on a row in Table 1 filters Table 2 to a single value. Clicking on a column header in Table 1 makes Table 2 very long.

On Table 2: Assign a Reference Field on the header. [Selected Product Reference]
Hide Table 2.

Now on the Main tab, place a Cell that is a picture of a button with the text “Show Production Details”. (hidden when no product is selected).

Add Intra-Document link to the button cell to the report tab for Production History.

Report tab Production History: Table of “Production Lots” with details.
Define Variable [Show Lots] = If [Product Name] = [Selected Product Reference] then “Y” else “N”

Filter on table Production Lots: [Show Lots] = “Y”
Hide the Production Lots table when empty.
Behind that table, put a big cell that says Go Back to Main tab to select a Product. Add an Intra -Document link to that cell, taking them back to the Main tab. When the table is hidden, the button is visible. When a Product is selected, table is visible, and the button is behind the table.

If anyone has any solution that is slicker, I’d love to hear it.

I’m really gonna miss this site! :slight_smile:

Seagrass (BOB member since 2014-11-18)