How to export/import the Folders/Reports from one envirornment to another..

BI Analytics

I am sure, in Answers/Dashboards, most of OBIEE  developers may  face a common issue of copying all their objects from one folder to another folder, one environment to another environment (in the developing stage) etc.

If you got the access to the system in which the Catalog is stored then, these actions are very easy. But how to do it in Dashboard catalog.

OBIEE 11g came up with a solution for this problem. Archive and Unarchive. In Archive you can archive (export) a folder with diff objects to the local file system. The archived file can be Unarchived (imported) into another folder. So simple… isn’t it?

Archiving

I am implementing Archive and Unarchive process using two instances one is ‘‘eld15’’ and second one is ‘‘obiee2’’ instances. Here ‘‘eld15’’ instances ‘Shared Folder’ having ‘Test_eld15’ reports folder. Using Archive/Unarchive process ‘Test_eld15’ folder will move to ‘‘obiee2’’ instances under ‘Shared Folder’.

1

Archive and Unarchive options are available under ‘Tasks’ option.

2

In Archive you can archive (export) a folder with diff objects to the local file system. Select the ‘Test_eld15’ folder and now, click on the Archive link, which will open a dialog box with some options for the archiving. Check the two boxes.

Keep Permissions: Folder level permissions also keep at the time of archiving the folder

Keep Timestamp: Kept the database timestamp

3

After clicking OK button, a dialog box will appear asking where the catalog to be saved. Select the desired location and save the file.

4

This archive file saved into a Downloads.

5

Unarchiving

 Select the ‘Shared folder’ into which the archived (exported) filed needs to be Unarchived (imported).

We are going to unarchive the ‘Test_eld15’ file will be created in the shared folder. Then click on the Unarchive link inobiee2’ instances.

6

The Unarchive dialog box will appear which allows us to select the file which needs to be Unarchived into the currently selected folder ( in our example, its ‘Test_eld15’). Click OK.

7

In this Unarchive window having three option. Each one having multiple options.

Archive file:  Browse the appropriate archive file name (‘Test_eld15’).

 

Replace

The Preferences dialog contains the following options in the Replace area:

  • Force — Pastes all files, overwriting even those that have the read-only attribute set.
  • All — Pastes all possible files, overwriting only those that do not have the read-only attribute set. (Default)
  • Old — Pastes all possible files, but does not overwrite any existing files unless they are older than the source.
  • None — Pastes all possible files, but does not overwrite any existing files.

 ACL

The Preferences dialog contains the following options in the Paste ACL area:

  • Inherit — inherits the object’s permissions (ACL) from its new parent folder. (Default)
  • Preserve — Preserves the object’s permissions (ACL) as it was in the original, mapping accounts as necessary.
  • Create —   Preserves the object’s permissions (ACL) as it was in the original, creating and mapping accounts as necessary, depending on the mode and type of owner, as described in the following list:

8

Once it is successful click on “Ok” and a ‘Test_eld15’ file will be created in the shared folder shown.

9

Hope it helps.

Best Regards,

Raghu Nagadasari

Advertisements

About raghunagadasari

Working with a MNC on BI Applications 7.9.6x, OBIA 11.1.1.7.1. Having work exp on EBS, Oracle Apps, ODI, Informatica, OBIEE, Pl/sql,
This entry was posted in OBIEE. Bookmark the permalink.

3 Responses to How to export/import the Folders/Reports from one envirornment to another..

  1. Praveen says:

    Really appreciate the wonderful work. It helped a lot. Thanks a ton

  2. Hari says:

    Thanks a lot. It helps in understanding at detail level

  3. Javier says:

    Thank you 🙂

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s