Neal Waterstreet

  • Home
  • About
  • Book Reviews
    • 2018 Reading List
    • 2017 Reading List
    • 2016 Reading List
    • 2015 Reading List
    • 2014 Reading List
    • 2013 Reading List
  • Projects
    • OBi200
    • DS716+ memory upgrade
    • Cord cutting
  • Presentations
  • Contact

Filtering with MDS Add-in for Excel

April 30, 2018 by neal Leave a Comment

Recently I was asked about filtering data in the MDS Add-in for Excel. The users maintain an entity with a large number of members. New members are entered daily but rarely updated. One way to resolve this is to filter the data in Excel. This simple solution gives users the ability to control the data that they see while giving them the ability to edit if needed.

Here is how to create and remove a filter using the Product sample package that is included in the install.

Adding a Filter
1. Connect to the MDS source.

2. In the “Master Data” tab, click “Filter”.

3. In the “Filter” screen, click “Add”.

4. For “Attribute”, select “Code” from the drop down list. You could use any attribute here. For “Operator” select “is NULL”.

5. Select “Load Data” from the bottom of the screen.  Select “Yes” at the window prompt.

6. The worksheet is now filtered to enter data. The worksheet can now be saved and will filter when the data is refreshed.

Removing a filter
1. To remove the filter, click on the filter to highlight it and select “Remove”. Multiple filters can be deleted by selecting “Remove All”.

2. Select “Load Data” from the bottom of the screen.

2. All of the data is again displayed.

Filed Under: MDS Tagged With: Filter, MDS Add-in for Excel

May 2025
M T W T F S S
 1234
567891011
12131415161718
19202122232425
262728293031  
« Mar    

Blogroll

  • Atlanta MDF
  • Atlanta Microsoft Business Intelligence Group
  • Atlanta Modern Excel User Group
  • Chris Webb's BI Blog
  • codegumbo
  • Lance England
  • PowerPivotPro
  • Prologika
  • SQLBI

Tags

#SQLSatATLBI Aereo at Atlanta Microsoft BI Azure Azure DataFest Backups Batch Certification changeset Chicago Conference CrashPlan Data Modeling Data Quality DAX Deployment DVR Entity-based staging Error Messages Excel Filter Goals Headphones Healthcare Leaf Tables MDM MDS MDS Add-in for Excel Oops! Something went wrong PASS Healthcare VC Power BI Power Pivot review Roku SQLSaturday SQL Saturday 800 SQLSaturday Atlanta BI SSIS Streaming Subscription View Time Training Validation Version Flag

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Copyright © 2025 · Minimum Pro Theme on Genesis Framework · WordPress · Log in