Cascading Drop Downs for Domain Attributes by mecurioJ

Closed

Type:	Bug
ID:	774292
Opened:	12/13/2012 2:03:17 PM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

I have an Entity that has a Domain Attribute of Category with an attribute of SubCategory. I am trying to present two cascading drop downs in the Excel Add-In. It would seem to me that this should be fairly straightforward but I can't see where I can implement it for data quality.

Details (expand)

English

SQL Server 2012 - Business Intelligence Edition

Master Data Services

Windows 7 (all editions)

US English

Create an Entity for Category and populate it with dummy data
Create an Entity for SubCategory and insert a "parent category" domain attribute, then populate with data.
Create a Managed Data Entity that includes Category as a domain Attribute and SubCategory as a domain attribute linked to the SubCategory Entity
Pull the data from Managed Data into an Excel Spreadsheet.
Attempt to cascade choice in Category to limit the Choices in the SubCategory

no cascade of choices

Cascading of Choices

X64

0 attachments

Posted by Microsoft on 12/13/2012 at 3:07 PM

Thanks very much for your feedback – it’s always appreciated and useful.

We’re closing this request as “Won’t Fix” because we do not plan to implement the change in SQL Server 2012 MDS. We will, however, keep it on file for future releases. A custom editor for filtering and choosing DBA values would be a nice addition.

Microsoft