SAC Story Passing Prompt/ Variable value into hyperlink target story

[former_member281456]

Hello Experts,

We have a requrment to jump into a detail report from summary report where the detail report can be used as separate standalone story as well.

We are using BW Live connection and underlying BW Queries has common prompt for the summary and detail report.

Is there any way to pass the BW Prompt value from the summary to the detail report? We can achieve it by keeping the detail report as a separate tab using merege variable function in the same story. However, if this is a separate story altogether, is there any way to pass the variable value to the target detail report.

Thanks,

Supriya

[former_member62434]

Hi Supriya,

Have you found the solution?

Best regards,

Paula

[former_member812226]

Not possible from Story, Use an analytical application instead.

[Former Member]

Hi Supriya,

As mentioned you have 2 Story Pages(Summary report where the detail report can be used and separate standalone story as well). You can try the below Step:

1. Add these 2 Story Pages in Digital Boardroom and add Tile Navigation for Summary report Story for upon particular Selection(like Table or Chart).

2.Summary report Give the Story and Page details to where it needs to be moved from Summary report.

3. Select - Apply selected dimension as filter checkbox( Uploaded the image of same).

Thanks,

Kiran

[former_member281456]

Thanks Kiran,

We can pass the selected dimension as a filter to the target story but my question here is - how do I pass the BW Qyery Variable value from one story to another to ensure BW query side filtering is also consistent.

Thanks,

Supriya Das

[mfoeken]

Hi Supriya,

You can open a story through a hyperlink with variable values included as part of the URL. Please check the following part of the URL API Guide: https://help.sap.com/viewer/a4406994704e4af5a8559a640b496468/release/en-US/3fa25603111049fba11eb898c....

Kind regards,

Martijn van Foeken | Interdobs

[former_member281456]

Hello Martijn,

Thanks for this link. It describes how to pass fixed values. Is there any way we can pass value dynamically.

Like if I have a variable var_Summary in the summary story and a variable var_Detail into the detail target story, can I pass

the value of var_Summary to var_Detail if there is a hyperlink from the summary story to the detail target story.

Thanks,

Supriya

[deshmukh]

Were you able to achieve this? We also have similar requirement. If you have achieved it pls let me know.