topic Re: SAS Folders in EG when connected to Custom Metadata Repository in SAS Enterprise Guide

SAS Folders in EG when connected to Custom Metadata Repository

deleted_user — Fri, 01 Jun 2007 07:22:05 GMT

Hi,
is anyone using custom metadata repositories with EG and if so, can you use the SAS Folders? I'm having troubles with SAS Folders, when I try to access them in EG when I'm connected to a custom metadata repository.

The SAS Folders window says "There was an error retrieving the stored process metadata. Enterprise Guide cannot display the list of stored processes in the current repository".

When I use the EG explorer and try to open SAS Folders I get: "Item has already been added. Key in dictionary: 'SAS Folders\BIP Tree' Key being added: 'SAS Folders\BIP Tree'."

I have previously created Information Maps under my BIP Tree in Custom repository. What I would like to do is enable users connected to custom repositories to be able to create Stored Processes and Publish their reports to WRS repository.

I know custom repositories are not 100% supported in 9.1.3 SP4 for BI Clients, but still...

Re: SAS Folders in EG when connected to Custom Metadata Repository

ChrisHemedinger — Fri, 01 Jun 2007 13:15:30 GMT

The limitation is that EG 4.1 doesn't tolerate folders with identical paths among different repositories. Because EG presents this as one aggregate view of everything -- it does not merge folder contents that originate in different repositories.

For example:

FOUNDATION\BIP Tree\Report Studio\Reports\Stored Processes
HR\BIP Tree\Report Studio\Reports\Stored Processes

Would create a conflict -- ONLY IF EG is pointed at the HR repository, which "looks through" to Foundation.

Chris

Re: SAS Folders in EG when connected to Custom Metadata Repository

deleted_user — Mon, 11 Jun 2007 14:37:52 GMT

Thanks Chris! I figured it out too, and now I have another question for you:

Do EG 4.1 and SAS 9.1.3 SP4 support publishing SAS reports to WRS repository when connected to Custom repository in EG?

For example I have source data available only to Marketing people in my Custom repository called Marketing and I would like to combine all my analyses on that data to one report in the SAS report format and publish it to a Folder accessible by Marketing people via WRS or Portal. I want to be able to use WRS for Foundation and/or other Custom repositories too.

How about the limitations with Publication channels how are those related to the use of Custom repositories?

If you can provide answers to these questions it would be very helpful and same me a lot of time from testing it out myself...

BR,
Jouni

Re: SAS Folders in EG when connected to Custom Metadata Repository

ChrisHemedinger — Mon, 11 Jun 2007 20:19:33 GMT

I'm afraid the answer to this is "it depends".

In general, it should work. However, some repository update operations can fail if the item you are adding to metadata contains references to objects within a different repository. For example, if your SAS report contains references to stored processes that reside in Foundation, things might not completely work as you hope.

Chris