on 09-14-2015 8:05 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.