About nrose

nrose · ‎12-09-2013

Hi, I need to register Custom Tasks in metadata, and all seems good except for two issues: How to I unregister a custom task from metadata? How do I register in so it appears as a capability in AMO? The documentation states it is the same process as EG, but the tasks do not appear as a capability in the AMO roles. Is there something different that needs to be implemented in the custom task itself? Thanks, Nick

nrose · ‎10-02-2013

Thanks Chris, that worked. Although the SaSData class is a bit easier to use, the API you mentioned has the advantage of allowing Excel data to be used, without much extra effort. Nick

nrose · ‎09-30-2013

Hi all, This is probably more of a question for Chris, but if anyone knows, I am not sure how to implement custom tasks so that they can read in data from Excel as input. The usual call in C# is to use: SasData data = new SasData(this.Consumer.InputData[0] as ISASTaskData2 but this assumes the data is SAS based from a library. When you run the task in Excel, and the user chooses Excel data, a window appears that allows the user to select the cells that contain the data of interest, but when the variable selector appears, no data variables appear in the selection, presumably because the Excel data was not able to be read in. A workaround is for the user to first copy the Excel data to the work library, and to run the task on this, but there must be a way of reading in the data as part of the custom task. Any help appreciated. Nick );

nrose · ‎09-24-2013

nrose · ‎07-19-2013

Try using the 'performance' button in step one of the wizard. It has an option to limit which rows a looked at. Nick

nrose · ‎07-12-2013

Thanks for the quick reply. The incompatibility I am describing can be found here: http://support.sas.com/documentation/cdl/en/whatsdiff/63859/HTML/default/viewer.htm#n0nclamx7boylwn1emmt1mlwlqqr.htm. Prompts don't work properly if you use 9.3 stored processes. I don't buy the argument that EBI is an older platform and so will have fewer enhancements. The BI web clients haven't changed in 4 years apart from minor tweaks whilst clients such as AMO and SAS EG have changed drastically. I get it - you can't enhance two products that are supposed to do the same thing, but whilst we wait for VA to mature, organisations such as ours have to figure the best path to take. I am happy for our organisation to move to the VA paradigm, but who is going to foot the bill for that transition? All I am trying to achieve is for existing EBI customers to not get the short end of the stick by this drastic change in direction that SAS is taking. So yes, a separate thread on how SAS is going to achieve this would be appreciated. Thanks

nrose · ‎07-11-2013

HI, its pretty obvious that EBI specific clients are on the way to deprecation. How then do you explain the pages of new features for VA in the SAS 9.4 release, whilst WRS and OLAP studio/server gets six trivial enhancements between them, IM studio gets no enhancements (are IM's even compatible with 9.3 stored processes yet?), and AMO and EG enhancements basically revolve around compatibility with VA? Will SAS please spell out a clear and accurate roadmap for EBI, and perhaps provide some details on how all those EBI users who are generously donating their licence fees to VA development can benefit from the VA client? thanks, NIck

nrose · ‎06-26-2013

See SAS 9.3 Support for Additional Software Products for more information. If you have purchased a product called 'SAS Bridge for ESRI', then this will NOT help in any way in producing content for WRS and EG. Enough said on my part - you should follow this up with SAS to get some advice on mapping and WRS. Nick

nrose · ‎06-26-2013

LOL At the risk of going around in circles, whether you call it the SAS ESRI Bridge, or ESRI bridge is not the point - the 'Bridge' is a desktop component that links ArcGIS Desktop with SAS. The ESRI Map component that you are interested in and allows the interactive visualisation of maps based on OLAP cubes in WRS, SAS EG and OLAP viewer need ArcGIS Server 10.0, and there is no 'Bridge' product. Thus, the 'Bridge' and ESRI Map Components are two very different technologies. Trust me, I have been using these two products for years. Anyway, good luck! Nick

nrose · ‎06-26-2013

Yes, but this is not the same as the SAS Bridge for ESRI , and you need ArcGIS Server 10.0 or lower for the ESRI map component to work. It is wrong to refer to it as the ESRI Bridge. Assuming that you are referring to the installation and configuration of ArcGIS Server 10.0 (or lower), it is just a misunderstanding in terminology. Regards, Nick

nrose · ‎06-26-2013

Perhaps you should read my response a bit more carefully - SAS Bridge for ESRI WILL NOT allow any mapping functionality within WRS - it is purely a desktop component. Regards, Nick

nrose · ‎06-25-2013

Hi Dave, You cannot include maps in a WRS report using the SAS bridge for ESRI. The bridge is a desktop tool, and is useful if you have ArcMap (ArcGIS Desktop) and you want to be able to map SAS datasets in ArcMap, and run stored processes in ArcMap. The only way to include maps with drill down capability is to install ArcGIS Server. You can then map enable your OLAP cubes by using GEO dimensions and linking it to a map service produced by the ArcGIS Server. There is no way to dynamically enable maps that are linked to Information Maps or other types of data - only OLAP cubes. Further to this limitation, is that the process is rather complicated, and you need to know your way around administering the ESRI server, and SAS Server, as well as knowing how to create map services, and linking them in metadata. Then there is the issue that WRS is only compatible with ArcGIS Server 10.0, and ESRI will be up to 10.2 in July. As I understand, there is no intention to make WRS compatible with more recent versions of ArcGIS. All development efforts for mapping is going to Visual Analytics, so, you are stuck with what is available now. The only option then is to have static maps, that are produced by stored processes. So, you have to create maps using PROC GMAP, but you need to convert this process into a stored process, and then you can add it to your WRS report. The best way to find out how is to look up how to add stored process to WRS in the WRS user manual Hope that helps Nick

nrose · ‎06-07-2013

Thanks Patrick, I am using DI Studio 4.6. The issues are outlined in the original thread - my main issue where no solution can be found is that every now and then, DI will lose its ability to save work. I would be interested to know if anyone else has had that issue. There are also random metadata corruptions that occur, and it is hard to reproduce these, and harder to find a solution. I find that the SCD Type transforms are great in theory, but when working with external DBMS's (we work with SQL Server), they are only useful for small tables because the processing is not pushed into the database. In general, given the emphasis on Data Integration, it would be helpful if transforms such as these were not so half baked and were better optomised for DBMS processing, Nick

nrose · ‎06-02-2013

Thanks, It is however better to combine other operators with the append rather that continuing to use the set operator. I have lost days of work having to re-create the logic lost using this set operator. Archiving doesn't help - after re-creating a job and archiving, I found that a month later, the job broke again, and importing the archive made no difference. I have now recreated most of these lost jobs without the set operator and I ain't going back. Hopefully with the above info tech support can fix it, but they have had no luck thus far. It seems that, for our environment at least, this is just one of many bugs with DI studio and the metadata environment. I recommend others please contribute to this post with issues and contact tech support rather that just put up with it, so that SAS can resolve them. The information you have provided for instance means that this is a more widespread issue, and you have provided a way to replicate the issue. Nick

nrose · ‎06-02-2013

Thanks, I have giving up using this set operator, and rely on the append. Its a shame, because, this is a really good operator (in theory). Hopefully, this information will help SAS troubleshoot - tech support, over to you. Nick

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Re: Whats new for SAS Web Reports Studio???

Re: proc sort data: nodup/nodupkey OR proc sql

Re: proc gchart

Re: How to combine results into a single document in EG6.1

Re: Export to .cvs and others from SELECT?

Re: Assigning a library in Enterprise guide

Re: SAS EG v6.1 - Using Office Files for Input and Output

Re: SAS enterprise guide 6.1 help

Re: Save Enterprise Guide Project to Metadata?

Re: SAS enterprise guide 6.1 help

Re: Assigning a library in Enterprise guide

Re: Dealing with 32 character restrictions

Assign Sequential Numbers

Dealing with 32 character restrictions

Re: Dealing with 32 character restrictions

Registering Custom Tasks

Re: Excel data as input for Custom Tasks

Excel data as input for Custom Tasks

Re: E.G. Displaying the data in a Summary Table Report in Descending o...

Re: Using Import Wizard in SAS EG

Re: Whats new for SAS Web Reports Studio???

Re: Whats new for SAS Web Reports Studio???

Re: Displaying maps within Web Report Studio WITHOUT ESRI Bridge

Re: Displaying maps within Web Report Studio WITHOUT ESRI Bridge

Re: Displaying maps within Web Report Studio WITHOUT ESRI Bridge

Re: Displaying maps within Web Report Studio WITHOUT ESRI Bridge

Re: Displaying maps within Web Report Studio WITHOUT ESRI Bridge

Re: Set Operator Transform issues

Re: Set Operator Transform issues

Re: Set Operator Transform issues