nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

OBIEE 12c: System-Wide Default for Column Property -> Settings lost when Catalog is archived and tra

Michael Lorkowski

Hello,

my Name is Michael and i have a question to OBIEEs system-wide Default for column properties. When i change a property (for ex. Decimal Places from 0 to 2) and save them as "Save as the system-wide Default for 'xyz'", it works in my Environment. I can use different users - erverything is fine, my new property is available. Now i'm forced, to Transport the catalog from DEV to PROD. I use the 'Archive' and 'Unarchive' function. In the following Environment (PROD) are the Settings not like the Settings in my first environment. Now i have the 'old' Settings (Decimal Places = 0).

Now the question: Is it possible to Transport system-wide Defaults from Environment to Environment or have i set to in every Environment?

Kind Regards,

Michael

Find more posts tagged with

Accepted answers

All comments

[Deleted User]

Michael,

WHAT are you archiving exactly and HOW? Via command line? Through the web GUI? Through the catalog admin tool? Which path are you archiving and where to are you unarchiving?

Michael Lorkowski

Hello Christian,

i use the web GUI, the Task 'Archive' and 'Unarchive'. I Archive one Folder (with subfolders) directly located under 'Shared Folders'. But i think i see the Problem now: my fact where i changed the Settings isn't a part from the catalog-Folder, it is a part from the repository. I use the fact, when i build new analysies. Do you know a way, how i can Change a Setting, so that the Change is available in following Environments?

Kind Regards,

Michael

Michael Lorkowski

Hello Christian,

Kind Regards,

Michael

Gianni Ceresa

The system wide defaults are stored in the catalog, but in the /system path, so you would need to move those settings as well and not just the subpart of /shared you look for.

[Deleted User]

Ok that's what I thought. If you are in the web interface then there is no way to move these settings.

A webcat is made up of 3 main folders

/shared

/users

/system

The system-wide defaults are as you can probably guess in /system and that along with /users is unavailable from the web GUI. Only the command line and the admin tool (which is just a java gui on top of the command line) allow that.

Personally I prefer to use the command line

.\runcat.sh -cmd archive

-online http://yourserver:9502/analytics/saw.dll

-credentials /tmp/cred

-outputFile /tmp/sys_defaults.catalog

-folder /system/metadata

Gianni Ceresa

You have been slow on this one ... doing the screenshot took you longer than expected (that's why I didn't go into many details as I knew you were doing it)

[Deleted User]

:-P

Michael Lorkowski

thanks for your fast answers. I'll try it. Thanks.

Michael Lorkowski

Hello, me again, i Archive the whole 'metadata' folder (subject Area which has changed is "GZD - KraftSt"). I can see the correct 'last modified' Information in 'metadata', esp. in 'GZD - KraftSt'. It works.

I use the function 'unarchived' in target Environment 'Two', while i'm choosing 'System Folders' to unarchive the 'metadata' below 'System Folders'.

The 'last modified' isn't the same like Environment 'One' and the system-wide Settings are not available. Is anything wrong in my steps? Is there any mistake?

Thanks a lot for your Help.

[Deleted User]

Are you doing this in online or offline mode? /system should only ever be moved in offline mode