Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Scheduling of RPD utility

Received Response
1
Views
4
Comments
User_R93U9
User_R93U9 Rank 3 - Community Apprentice
edited Aug 13, 2024 5:52PM in Oracle Analytics Cloud and Server

How can i run rpd utility from command prompt? I want to schedule it monthly.

Answers

  • Martin van Donselaar
    Martin van Donselaar Rank 6 - Analytics Lead

    Do you mean to schedule validaterpd?

    And can you explain what exactly you are trying to achieve by doing that?

  • User_R93U9
    User_R93U9 Rank 3 - Community Apprentice

    I got it resolved but now i m stuck with catalog manager report automation. I want a report on analysis and dashboard which shows me what object is placed at which path, which dashboard has what dashboard pages and analysis associated with it. We can do this using create report option in catalog manager. Can we automate that option to run on weekly basis?

  • Gianni Ceresa
    Gianni Ceresa Mod

    It would be nice if you contribute back to this community forum.

    "I got it resolved" doesn't really help any other user having the same question. So would be nice if you post back how you resolved it and then close the thread.

    And for a different question you open a new one, ideally writing a bit more than a single sentence.

  • User_R93U9
    User_R93U9 Rank 3 - Community Apprentice

    Thanks Gianni.

    Following is the Batch file that helped me to automate the utility. This can be scheduled as per requirement in any environment.

    REM The temp output location of the CSV output. This will be removed on success

    set OUTPUT_CSV_TEMP=C:\test\temp_repo.csv

    REM The final location to copy the CSV output to

    set OUTPUT_CSV_FINAL=C:\test\Final\temp_repo_final.csv

    REM The location of the RPD file to use for the export

    set RPD=C:\Users\a021339\Desktop\Release Docs\RPDs\EFRL_HR_ASIS_BAU_Merged_Q4_V21.rpd

    REM The temp output location of the rpd. a copy of your RPD is taken so that the originial is never opened by the AdminTool. This will be removed on success

    set RPD_TEMP=c:\test\rpd.rpd

    REM location of the RPD instruction file

    set CMD=c:\test\export_metadata.txt

    REM Settings taken from your bi_init.bat file. This may be found at C:\Program Files\Oracle Business Intelligence Enterprise Edition Plus Client\oraclebi\orahome\bifoundation\server\bin

    set ORACLE_INSTANCE=C:\Program Files\Oracle Business Intelligence Enterprise Edition Plus Client\oraclebi\orainst

    set ORACLE_BI_APPLICATION=coreapplication

    set COMPONENT_NAME=%ORACLE_BI_APPLICATION%

    REM include the below line if you're exporting from a server installation of OBIEE

    REM call %ORACLE_INSTANCE%\bifoundation\OracleBIApplication\%ORACLE_BI_APPLICATION%\setup\user.cmd

    REM do not edit below this line.

    copy %RPD% %RPD_TEMP%

    set PATH=%ORACLE_HOME%\bifoundation\server\bin;%ORACLE_HOME%\bifoundation\web\bin;%ORACLE_HOME%\bin;%JAVA_HOME%\bin;%windir%;%windir%\system32;%PATH%

    "C:\Program Files\Oracle Business Intelligence Enterprise Edition Plus Client\oraclebi\orahome\bifoundation\server\bin\admintool" /command c:\test\export_metadata.txt

    If not exist %OUTPUT_CSV_TEMP% Exit

    REM copy csv to final location

    copy %OUTPUT_CSV_TEMP% %OUTPUT_CSV_FINAL%

    REM cleanup

    del %OUTPUT_CSV_TEMP%

    del %RPD_TEMP%