Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OBIEE 12c: System-Wide Default for Column Property -> Settings lost when Catalog is archived and tra
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
Answers
-
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?
0 -
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
0 -
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
0 -
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.
0 -
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
0 -
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)
0 -
:-P
0 -
thanks for your fast answers. I'll try it. Thanks.
0 -
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.
0 -
Are you doing this in online or offline mode? /system should only ever be moved in offline mode
0
