User folder/Saved Queries

Gianni Ceresa

Did you copy the whole <userXYZ> folder? I would only take a subfolder or content as the main user folder contains bunch of "special" things (metadata files storing things) the catalog maybe get confused about.

And you will still need to erase permissions to add yourself in it as by default only the deleted account will be granted any kind of access on those objects.

Charles M

Hi Gianni,

I did copy the entire <userXYZ> folder. I'll try again with some individual objects.

Also, on your second point, do you know how to do that?

Thanks for helping ...

Charles

[Deleted User]

Charles M wrote:Thanks Christian. I just tried this out in a non-prod instance, but it didn't seem to work.

Not sure what the impact of prod vs non-prod would be ;-)

Charles M wrote:Also, on your second point, do you know how to do that?

In all honesty I'd go the file-system way: Create a new object of the same type as you're trying to recuperate. Then go and take the CONTENT of the object you want to recuperate - go inside the file and grab all the XML - and then go inside your new placeholder object, paste the code, save and that should be it.

Gianni Ceresa

Christian Berg wrote:In all honesty I'd go the file-system way: Create a new object of the same type as you're trying to recuperate. Then go and take the CONTENT of the object you want to recuperate - go inside the file and grab all the XML - and then go inside your new placeholder object, paste the code, save and that should be it.

As a shortcut for this one, to not have to copy/paste content (XML) around files. Create a new object of the same type and same name. Then just copy the file over and replace it keeping the .atr your just created.

The .atr file has security and object kind, so if you have an .atr matching the name of the old object you want to access that's all you need in the end, without having to really look into the files and play with XML.

PS: as you can see it's not really a fun thing to do, so you maybe want to setup a process for when employees leave your company. Like resetting their password, connecting, on their behalf and copy all their content to a shared folder directly before to delete their account for real (cleaning up in your OBIEE and in your LDAP).

[Deleted User]

Gianni Ceresa wrote:Create a new object of the same type and same name. Then just copy the file over and replace it keeping the .atr your just created

True

Charles M

Hi Christian (and Gianni ),

Thanks again for the replies. Quick question here. On the file system, for the xml and atr files, the '+' signs just represent spaces, right? Also, how about '%' signs? Are they literal values or represent something else? Trying to get the naming right. BTW, they are all saved analyses.

Also, do I need to know the subject area that they are created in, or will that be overwritten?

Regards,

Charles

Gianni Ceresa

Hi Charles,

The filename generally uses + as spaces and % could be any kind of special character, OBIEE also shorten names, so sometimes it's quite random.

Just create an analysis with a similar name and then copy the XML file (not the .atr) from the user folder and override the one which has been created (so rename the XML file to match the one you created without touching the .atr).

Nothing will be overwritten, the subject area is contained in the XML, it will not move at all.

The filename of the XML must match the filename of the .atr, anything else isn't really important (as OBIEE will link the 2 together and apply the properties of the .atr, security and type, to your XML file).

[Deleted User]

Gianni Ceresa wrote:The filename of the XML must match the filename of the .atr, anything else isn't really important (as OBIEE will link the 2 together and apply the properties of the .atr, security and type, to your XML file).

Yupp.

Charles M

Christian, Gianni,

Thanks so much for the help with this! I was finally able to do it (way more objects than I wanted to have to do, but all's well that ends well). I now have all of the analyses in my own sub-folder. We can now move over to a shared folder and so on.

I wanted to follow up with one of Gianni's earlier points, but wanted to acknowledge the solution for now. I'll circle back on the follow up, as it is more auxiliary to the main point here ...

Thanks again, I'll mark the replies in a bit.

Regards,

Charles