Skip to Content
author's profile photo Former Member
Former Member

Dynamic Hyperlinks using opendoc

Hi,

We have our Development and Testing BO on the same machine which is BO 3.1 and for Report development we have reports in the folder structure Development folder/Subfolder1 and for Testing we copy the reports to Testing/Subfolder1.

No we have developed reports with hyperlinks using opendoc which use the iDocId and so when we copy the reports from dev to Testing we have to update the hyperlinks with the new iDocId as a copy creates a new iDocId. The problem is that we have many reports and each of them have several links and updating the iDocId is not feasible each time as we move to Testing phase.

So we looked at using the sPath and sDocName, but even in sPath we have to mention the entire Path and we end up with the same problem.

Is there a way to make the link dynamic to look at the report called in the current folder when the calling report is located ? Or any other function which can give us the iDocId or the Path of the report dynamically in webi.

Also since we will be soon migrating to BO4.0 and I came across that sPath is deprecated in BO4.x so a solution for dynamically coing the links would help using the iDocId.

thanks

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Jan 08, 2014 at 02:52 AM

    The report can be uniquely identified by either iDocID or a combination of sDocName and sPath. So there is no other option. In your case, I guess the second option will be better. Though BO4.x encourages us to use iDocID, but if you are not using any localized folder name, sPath will continue to work even after migration.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Agree with Arjit, the folder Structure in LaunchPad is just something to help users, on the backend side there is just an input and output repository server without a fancy user-friendly folder structure.

      I assume that you are using the CUID's of the reports and not the IDs (you can use both with iDocID).

      CUID's will be kept after transport (other system, not folder like in your case), ID's will change between systems.

      Overwriting and transporting the reports, will keep the CUID intact, so the updating of the links should be a once in a lifetime activity for you, isnt it?

      If I were you I would create a variable for the CUID so that the change can be done pretty quickly.

      Best regards,

      Victor

  • author's profile photo Former Member
    Former Member
    Posted on Jan 09, 2014 at 04:54 PM

    Bang on Victor ,

    CUID of any document is kept unique even across env. so it has to be used for hyper linking and not idocid , spath combination.

    Even Standard documentation suggest that we should CUID . Spath is supported but going to be deprecated.

    Regards

    Jeevan

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.