BookmarkSubscribeRSS Feed

Visual Analytics Data View Enhancements – Take your pick!

Started ‎03-02-2021 by
Modified ‎03-02-2021 by
Views 4,243

The January stable release of SAS Viya (2020.1.2) adds a much-anticipated Data View enhancement that allows you to select how you would like duplicate data items from an applied Data View to be used.

 

Check out this article if you’d like to learn the basics of Data Views.

 

This post will focus on the new enhanced user interface since the other Data View features and management remain the same.

 

Apply a Data View

When you go to apply your Data View you will see the menu option renamed from Data views... to Manage data views....

 

01_ManageDataViews.png

Select any image to see a larger version.
Mobile users: To view the images, select the "Full" version at the bottom of the page.

 

Then select the Data View you wish to apply.

 

02_ApplyDataView.png

 

New Apply Data View Options

Next you will be prompted to select how you would like to apply the Data View.

 

03_ApplyDataViewOptions.png

 

Notice the * on the third option. If you decide to Keep existing data items in the report this means that the Data View you selected will not impact your current data items. However, if that data source has a Default Data View assigned via the Administration Settings then when that data source is selected the Default Data View will be applied as the data source is added to the report. The Keep existing data items in the report only applies to the current Data View attempting to be applied.

 

Let’s take a look at the new user interface (UI) for the last option Let me decide how to apply each data item. There is a selection box at the top of the UI which allows you to Include unchanged data items or not. This way you can easily identify which data items the Data View wants to add or modify.

 

In this Data View named CARS_AVG_MPGs_WithHierarchy I have three data items that differ from the original data source.

 

  • MPG(City) - the data view data item uses an Average aggregation
  • MPG(Highway) - the data view data item uses an Average aggregation
  • Origin - Type - Make - Model - a new hierarchy defined in the data view

04_ApplyDataFilter.png

 

Looking at the first line item, MPG (City) here are the available options. If you want the data item duplicated with the (1) as a suffix, then you do not need to select anything from the menu.

 

05_AddDataViewItem.png

 

Here’s an example of how the Apply Data View options look and the result in the Data pane. Notice the hierarchy and MPG(City)(1) were added to the data item lists. For the MPG(Highway) data item, notice there is only one listed; this is because we opted to Replace the data item that came in with the original data source.

06_Results.png

 

Summary

The new Apply Data View user interface available for Data Views will give you the granular precision to decide how you want data item changes applied. For additional Data View information see these articles:

 

 

Find more articles from SAS Global Enablement and Learning here.

 

 

Comments

Looks great.  Thanks to SAS Prod Dev and SAS Canada team for making this happen.  Can't wait to upgrade to newest version and test it out.

Version history
Last update:
‎03-02-2021 11:41 AM
Updated by:
Contributors

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

Free course: Data Literacy Essentials

Data Literacy is for all, even absolute beginners. Jump on board with this free e-learning  and boost your career prospects.

Get Started

Article Tags