Catalog Archive

Hesh · May 28, 2018 9:34AM

Hi,

OBIEE 12.2.1.0.0

I have a requirement to archive old unused OBIEE Analysis from Catalog and need to do this periodically.

I am thinking around preparing some Linux scripts (something like Tar with Remove files option) along with runcat utility.

What would be the best approach for this? do I need to take any extra measure while doing this?

Appreciate your suggestions and thoughts!

Regards

Hesh

[Deleted User] · May 28, 2018 9:36AM

Not tar. Catalog objects are a combination of the catalog object's XML and a .atr file holding its attributes and its security.

That's why you have the runcat command line!

runcat.sh -cmd archive -help

^--- That will tell you how to create an archive via command line

Hesh · May 28, 2018 10:14AM

Thank you Christian Berg,

I will review runcat.sh .

Many things running over my mind, if we archive one Analysis and that Analysis is used in one dashboard.. I believe that will throw error! ...any more other thoughts where things can be surprising? I thought it would be easy thing to do but now looks a bit complicated

Regards

Hesh

[Deleted User] · May 28, 2018 10:32AM

Wow that isn't a topic which can be answered just here in a thread. Lifecycle management, dependency-analysis etc is a whole own thing you need to think about and adapt to your own system and setup.

We've presented quite a lot about this over the years, blogged and written in here. Long story short we can answer detial question here but the concept and strategy must first fit your solution.

Best also download the SampleApp VM and look at what is in there. Quite some content on lifecycle management and deployment strategies etc there. For example analyses which show you what analysis is used where etc.