Hi,
There is a way using bi-lcm(web-app) API to download RPD and do some other operations.
Then, I'm curious to know if there is a way using web-app API to archive catalog.
Any reply is appreciated.
Not sure of a web API but you can use the runcat.cmd/runcat.sh catalog manager command line utility to do this.
Check section 16.4.1:
https://docs.oracle.com/middleware/1221/biee/BIESG/prescatadmin.htm#BIESG2905
Thanks for you reply. The runcat.cmd is used to start the user interface for Catalog Manager. Actually, I want to write a script that can automatically archive catalog daily.
the runcat.cmd/sh does open the catalog manager but it can also be opened on the command line
try:
./runcat.sh -help
runcat.cmd -help
Do not stop at the basic usage of that command (and Joel is 100% right)
Of course no "double click" execution, you need to run the command by command line to not get it opening the GUI and start having fun in your script (runcat.cmd/.sh is quite powerful ! )
why not create a simple shell script and run it using cron job whenever you want
#!/bin/bash
# Author :Venkata Rachuri
#DATE 05/24/2017
# This will backup the catalog with date and time stamp
DATE=$(date +"%Y%m%d%H%M")
tar -zcf "/OracleBackup/QA/$(date '+%d_%m_%y_%H_%M')_QACAT.tar.gz" "/Mycatalogpath/obiee/bidata/service_instances/ssi/metadata/content/catalog"
# END
Thanks
Venkat
Yes, runcat.cmd can used in CMD. But it does not has an option to open a specified catalog.
With UI, I can open catalog such as "HOST:PORT/analytics/saw.dll". Is there any other offical doc?
Thank you very much.
DongxiYU wrote:Yes, runcat.cmd can used in CMD. But it does not has an option to open a specified catalog.With UI, I can open catalog such as "HOST:PORT/analytics/saw.dll". Is there any other offical doc?
You didn't really run the command, did you?
C:\Oracle\Middleware_OBI12c\Oracle_Home_12.2.1.3.0\bi\bitools\bin>runcat.cmd -cmd archive -help...# Command : -cmd archive -helparchive Creates an archive of a subset of the catalogDescriptionCreates an archive of a subset (folders and/or individual objects) of the web catalogFor more information, please see the Oracle Business Intelligence SuiteEnterprise Edition's Presentation Services Administration Guide.Syntaxruncat.cmd/runcat.sh -cmd archive -folder <path{:path}> -folderFromFile <path of inclusion list file> -skipFolder <path{:path}> -skipFolderFromFile <path of exclusion list file> [-noTimestamps] [-noPermissions] [-dontRecurse] -[force]outputFile <output file> ( (-offline <path of catalog>) | (-online <OBIPS url> -credentials <credentials properties file>) )Basic Arguments-[force]outputFile <output file> Path of the report fileOptional Arguments-noTimestamps Don't include timestamp information in archive-noPermissions Don't include permission information in archive-dontRecurse Just archive the immediate contents of the given folders, not the entire subtrees-folder <path{:path}> Which folders in the catalog to archive-folderFromFile <path of inclusionlist file> File containing the folders in the catalog to archive-skipFolder <path{:path}> Which folders in the catalog to skip archive-skipFolderFromFile <path of exclusionlist file> File containing the folders in the catalog to skip archiveCommon Arguments-offline <path of catalog>-online <OBIPS url>-credentials <credentials properties file> ----- Sample Credential File ------ @ login=weblogic @ pwd=weblogic1 -------------------------------------folderFromFile <folder from file> ----- Sample Folder From File ------ /shared/groups/misc /shared/groups/_filters ------------------------------------Exampleruncat.cmd/runcat.sh -cmd archive -offline c:\oraclebi\data\web\catalog\paint -outputFile c:\temp\shared.catalog -folder /shared -skipFolder /shared/Groups:/shared/Misc"Return status from Catalogmanager command : 0"
What do you think the "-online" parameter is for?
Everything is written there, the "help" of runcat.cmd command.
In the syntax you have the sample for both offline or online usage, when online an example of the file with the credentials is provided. Everything is written there ...
I misunderstood its usage. Thanks you!
Agenda Presentation: What's New in FDI 26.R3 Open Q & A: Ask your questions of implementation and product specialists Replays of past FDI CEAL Guidance Office Hours are available on Oracle VideoHub here. Fusion Data Intelligence - CEAL Guidance Office Hours The FDI Office Hours are hosted by CEAL solution architects who…
So when I click the apply button, it uses the value . Also. How do I stop the auto populate table when the report opens???? I am in OAC
Good day, please kindly assist. We are creating a graph to calculate the number of assets per milestones. However, the planners have only populated assets for only one milestone from the list of milestones the customer wants to track. Which gives an incorrect view as the project moves past different milestones that it has…
I scheduled the report in OTBI and the agent was run successfully. However, I do not receive the report after the run in my inbox. The addresses are properly recorded, and the report is in an excel format and saved as a pivot table in otbi. What can be the cause?
Anyone has any idea why the OAC documentation on custom viz is not available now? I was able to access till last week - https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsdv/build-package-extension.html. Does this mean OAC doesnt support custom viz or custom workbook extensions?
I made a parameter with letter range values… put it into a dashboard filter. Then I created an expression filter to bind it to my last name column in the table with the image I uploaded here. I am getting the following error??? Invalid Expression. Validation of parameter values failed. A general error has occurred. Message…
