BookmarkSubscribeRSS Feed
jplarios
Quartz | Level 8
Hi:
Can I have a SAS view as a source for an information map?

thanks,
jp
2 REPLIES 2
AngelaHall
SAS Employee
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
jplarios
Quartz | Level 8
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.

SAS INNOVATE 2024

innovate-wordmarks-white-horiz.png

SAS is headed back to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team.

Interested in speaking? Content from our attendees is one of the reasons that makes SAS Innovate such a special event!

Submit your idea!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Get the $99 certification deal.jpg

 

 

Back in the Classroom!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 616 views
  • 0 likes
  • 2 in conversation