topic Re: Can IM do SAS views as sources in SAS Web Report Studio

Can IM do SAS views as sources

jplarios — Mon, 16 Aug 2010 12:42:18 GMT

Hi:
Can I have a SAS view as a source for an information map?

thanks,
jp

Re: Can IM do SAS views as sources

AngelaHall — Mon, 16 Aug 2010 13:29:47 GMT

Yes.

Information Maps can be created using any data source defined within SAS Management Console (views, references to RDBMS systems, cubes, etc) as well as Stored Processes.

Note - the view must be pointing to a data source that the user can also obtain when running the Information Map from the client applications.

~ Angela
http://sas-bi.blogspot.com

Re: Can IM do SAS views as sources

jplarios — Mon, 16 Aug 2010 13:53:59 GMT

Thanks Angela - what exactly do you mean that the view must be pointing to a source? In DIS, I used the SQL transformation and created a target of View member type.

another related question, what would be the best practice in SAS for Role dimensions?
In a star schema input to a cube , can I have a view as a Dimension?
It seems that a view would work just fine, but I want to make sure that it works across all interfaces.