cancel
Showing results for 
Search instead for 
Did you mean: 

Display folder path

Former Member
0 Kudos

Is it possible to display the BusinessObjects folder path on a Webi report?  Example. "Public Folders/Production/Finance..."

Same question for a Crystal Report?

Thanks,

Josh

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

you can achieve this through Query Builder :

Use two queries

1 - To get the document´s parent folder

    select si_parentid from CI_infoobjects where si_id =53836

  it should return the document parent´s folder id <parent folder id>

2 - Then run the second one to get the folder´s path

select * from CI_infoobjects where si_id = <parent folder id>

Look for :

SI_name and si_path.

Regards,

Rogerio

Former Member
0 Kudos

Thanks for your response.

Is that something that can be displayed on a Webi report built from a Universe or a Crystal Report?  The goal is to display on all reports in a Public Folder in the BI LaunchPad the Folder path of where the report resides.

former_member201488
Contributor
0 Kudos

If you have auditing enabled you can do this by creating a second query against the activity universe and return the report path from there, which you can then surface on your report. Works on 3.x, with the caveat: you need to use the reportname() function as an input to query the activity universe, so this will only work for unique report names - unless you manually specify the CUID in the report. YMMV.

HTH

NMG

amitrathi239
Active Contributor
0 Kudos

Hi,

I don't think so it is possible now.no function is available for this in webi

Idea is  place for this.you can vote for this.

Add function for web-i reports which displays folder path where web-i report is saved. : View Idea

Amit