Webi Document Linking on most recent instance and restricting based on clicked Dimension

[former_member718275]

Hi forum I'm struggling to solve which i think on the surface should be a straight forward thing to do.

I have two Webi Documents. Doc1 is a Summary document and Doc2 is Details. Doc2 has a lot of data therefore I cannot have it refreshing on Open so I manage using a Schedule across both Doc1 and Doc 2 at the same time.

What I want to happen is a User clicks on a Dimension value in Doc1; this opens the most recent instance of Doc 2 and restricts the data to the value selected in Doc1. I have tried using parameters but seems I can only do this if the report is refreshed? I have performed an online exhaustive search but nothing is jumping out at me as a solution

[former_member718275]

Thank you Ayman for taking the time to respond. I'm comfortable with using sInstance to get the most recent copy but whay I can't figure out is how to restrict the data in the 2nd report (most recent instance which I dont want to refresh again) based on the parameter I send to it. Have looked at Param and creating a Query Parameter on 2nd report with Optional Prompt selected however each time I execute I get this:

An error occurred: Cannot find a document instance matching your prompt values

[ayman_salem]

To get the instance of documents, add "sInstance" to the openDocument link with the desired value (User, Last or Param)

For more information,, see "Viewing Documents Using OpenDocument" manual.

(Section 6.2 Document identifier parameters --- > 6.2.4 sInstance)