Archive reports in a given month via Command Line (Catalog Manager Tool)

User_E9OMM

Hi !

This is my requirement : I have 100 reports in my Shared Folder. Out of which, 20 reports have been created in this month ( May 2017).

Now I want to archive those 20 reports ( it's like this -- Archive X number of reports in Y month ) in one specific folder.

Analysis so far - I found one very informative article in oracle support [How To Use The Command Line To Archive The Web Catalog In OBIEE 11g (Doc ID 1678573.1)] https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=yugy4fwn1_4&_afrLoop=526229716848983#FIX

My question is, is there any way, where using that command, I have an option of defining the Time Period ? ( I assume that we may not have options to specify Month/Year or even like Between X Date and Y Date to gather select reports) However, if so, do you have tricks or suggest any workarounds ?

Note - Presently I am yet to get the access to the OBIEE setup. I wanted to run [./runcat.sh help ] command for myself  and do some R&D checks, but presently it is not possible. But for now just wanted to get some inputs from you to know if this requirement is really feasible. And also I wanted "Archive functionality" because there is one script we found in one of the blogs that takes BACKUP ( copy/paste) of reports and dashboards. We wanted Archived catalog because we will use it for un-archival later in some point in time.

Thank you.

Regards AM

Community DW Integration

my mp3 juice

If you are looking for an MP3 song then our website mp3 juice pro will provide you the best search result within the blink of an eye. As we have the most popular and the fastest search engine in the whole world. In a matter of time, you can find exclusive TV shows, movies and music with Mp3 juice. Also, you can discover loads of popular videos and music from different platforms.

https://mp3juicepro.com/

Thomas Dodds

• Archive functionality is not designed for entire catalog
• this functionality can be called from the command line
• this functionality can be run against a single folder in the catalog
• runcat.sh can also create/delete a folder in the catalog

So you could write a script that uses the catalog manager to create a folder, then you copy the reports based on their create date with the OS, use the catalog manager to archive the new folder to another location, then delete this folder out of the catalog.

^ the 'WHY' has me befuddled ... why not just a normal monthly backup of the whole catalog?

User_E9OMM

Hi Thomas,

Thank you for answering my question.

My interpretation of your inputs :

1> The archive process (command line) is limited only at a DAY level.

That is we can run that command to generate archive file of web objects that are stamped with a particular date.

There is no option to pass a Month parameter to the archive command.

2> I agree with you on taking a backup (archive) of entire catalogue at monthly basis.

But that backup will pack all the reports ( This month, Last month, Previous to last month and so on)

In our case, customer is looking for taking the archive of reports created in a select yearmonth. ( Like 201705, 201704)

One question :

Would it be possible for you to give one example of archive runcat command that shows the DATE parameter ? - [syntax]

Thank you again for your time and I acknowledge your valuable inputs.

Regards

AM

Gianni Ceresa

You maybe got it wrongly ...

"archive" isn't based on any date/time parameter. "archive" works on a path, it archive what is in that path at the time of running the command.

You have runcat.cmd installed on your workstation/laptop to see the attributes the runcat.cmd -cmd archive accept. (Catalog Manager being installed next to the Admin tool you don't really need any server access to see the options and test the commands)

Thomas Dodds

Not at a day for archiving ... use the OS to move based on creation/modification dates

User_E9OMM

Thanks Gianni Ceresa ! I shall test it out.