A spk file is an archive file, so think a .zip file. The BI Dashboards needs a table as the data source (think SAS dataset). Because you are effectively zipping the table, then the BI Dashboards can't read it. ... View more

Ive used SAS Enterprise Guide to access SQL Server Analysis Services, but never tried WRS etc. Im thinking that EG is using OLEDB for OLAP as a local client side connection and this connection isn't available server side, so WRS, IMS etc won't be able to access the cubes. ... View more

If you go into the search screen in Portal, search for the page you want to redirect them to and then copy the url (via right click) you should be able to embed that url in your STP. The trick is Portal may time the user out before they click on the link and then they will get a Portal login screen. I got this working in 9.1 havent tested it in 9.2 though. ... View more

Information Map Studio is used to hide the complexity of the underlying tables to users so they can easily create reports without needing to knwo what tables to join etc. It also allows you to apply business friendly names to fields rather than showing the names in the tables (whihc are normally technical names) Web Report Studio allows users to create reports via a web browser and save them centrally so they can be accessed by other business users when required. ... View more

We have built an addin (which we sell) which will let you do this: http://saasinct.com/sas-portlet-details/wrv-wrs-report-linkage.html ... View more

Yes it does, As always there are things that only work with relational data vs OLAP data and vice versa. Also functionality has improved between 9.1 and 9.2 Lastly you can access OLAP cubes from within Excel without gong through the SAS AMO addin. ... View more

Hi Costanzo What version of IDP/WRS/SAS are you using? ... View more

You could write some code in the stored process that creates the folder via the metadata API. Paul has posted examples on how to create metadata pro grammatically here. http://platformadmin.com/blogs/paul/2010/07/mkdirmd/ But this is a sledge hammer, any chance of what you need the nut to do in a bit more detail? ... View more

Hi Tim Usual horrible question 😉 Which release and when? ... View more

How did you get on? ... View more

We have struck this, tried all the options and have come to the limit of the 32 bit operating system and the way the SAS Metadata server has be (un?)architected to handle it. We are now planning to move to SAS 9.2 / 64 Bit to solve the issues. Try scheduling to restart the metadata service each night s this sometimes helps. Also try and get rid of any dependent repositories if you have any. One site I know of started with a fresh metadata repository and recreated all their content, that worked but a little time intensive 😉 Or upgrade to 64 bit windows which probably means SAS 9.2 at the same time. ... View more

Well you know the obvious answer is have one metadata server 😉 But as you have said you cant change this. If you have SAS Connect licensed you should be able to remote submit the SAS code from one workspace to the other, that would allow the Workspace server on the Oracle side pass a query to the workspace server on the Teradata side, using the SAS/Access to Teradata engine. The issue is if you try and swap metadata servers mid processing then the SAS work file that have written to the Oracle/Workspace server will no longer be available amd vice versa. If you wrote temporary SAS Datasets to a physical shared file path (accesable via EG) rather than a metadata based path that might work. Or have two eg project's one doing the Oracle call and the other doing the teradata call and then call one within the other (somehow). Or you could maybe do a manual metalib statement to define a libname on the Teradata Metadata server from the Oracle one. Lots of maybe's but you would need to test each one to see if any work. Interesting problem though... ... View more

I dont this there is anyway to do this. The EG project is stored in a EG specfic file (.egp) which can be only read by the EG client, not by SAS. When you schedule a EG project it creates a vbs file that is used to run the EG roject in the baqckground. I can't remember if it is runs the .egp or if the EG priject is exported as a .sas file. You could do somethig tricky trying to get the STP to call this version, but you would then have to scheduel the EG project each time you make a change. So the answer is nope to what you want to do I think. ... View more

I agree with everybody else. At the the moment you have to troll all the other forums to find any admin advice. Also when posting its unclear which one to use as Admin questions often span multiple SAS products. Lastly with the SAS PA Fast course we finally have a way to train SAS Administrators up, a forum would let them share their experience and advice. ... View more

If you have upgraded to SAS 9.2/M3 use the BI Dashboards, they allow you to do this. ... View more