Oracle Transactional Business Intelligence
List of Agents
Summary
List of Agents in "My Folders"
Content
Hi Team,
Does anyone know how to list a list of Agents that were created by users and saved in their "My Folders"?
I believe the only way is via backend, via database. So, I raised a SR for that.
However, I think it does not hurt to ask and hear if anyone else have needed something similar to that.
Thank you,
Alvaro Couto.
Comments
-
Yes the only way is via the backend. Through the front end only the user can see their own My Folder.
Regards Caroline
-
Thanks Caroline. That would be my thought as well.
-
Hi Caroline - could I please jump on this thread and ask for clarification on how one can access this in the backend?
Many thanks
Linda
-
Hi Linda - I've not looked at it in a while, but if you are running on premise then you used to be able to go into the catalog manager and see content from all parts of the catalog. You could run searches to look for specific content types and get listings of the results.That access isn't available in the cloud.
it's quite an old doc now but this is a summary of that feature - https://www.oracle.com/technetwork/middleware/bi/documentation/bieqt-1911962.pdf
Regards Caroline
-
Thanks Caroline. We are using Cloud HCM so I assume we cannot get this information. I was hoping there was a nice easy way to see all the details of all the agents we have in place. Is there a way to do this in the Cloud would you know please?
Kind regards
Linda
-
Alvaro who started this thread has raised an SR asking for that information - perhaps keep in touch and see what response he gets.
There is no way for you to get that information yourself as far as I know.
Regards, Caroline
-
Hi Linda,
I will update you guys as soon as I got Oracle's response to my SR.
Thank you,
Alvaro Couto
-
Thanks Alvaro & Caroline
Linda
-
Hi Linda,
You'd need to get a copy of the catalog and then you can do pretty much anything you want with it. Both the folder structure as-is on the file system or a .catalog file. Both work.
-
Hi - did you receive follow-up from Oracle on this? I am currently having an issue where users are receiving a report that I cannot find in any folders, so anticipate that it is in someone's My Folders. I submitted an SR but am told they cannot access My Folders. I am hoping you got a report, so I can push back to them with other information to help me get what I need
-
The catalog is stored in the "backend" on the application server not in the database. Under the root folder there are 2 folders Users and Shared. The shared folder is the one you can see in the catalog. Under the users folder there is subfolder for each user with their username then at runtime that folder is shown as "My Folder" depending who has logged on. So yes anything a user has created exists as files inside the user folders. As you know in cloud you cannot connect to the application server nor use the catalog manager client tool to read the catalog like you can on premise.So on cloud you can perhaps use the web services to read the catalog (cloudurl/analytics/saw.dll?wsdl). There is a web services guide here Oracle® Fusion Middleware Integrator's Guide for Oracle Business Intelligence Enterprise Edition 11g Release 1 (11.1.1) E16364-08 December 2014 https://docs.oracle.com/middleware/11119/biee/BIEIT/title.htm.
