action - Remove duplicates from OLAP Drill in SSAS -

i using visual studios bids modify existing olap cube.

in ssms: there underlying fact table (facttablemain) fine grain contains 10 different measures track status of application (they act flag). measures either have individual's id value or null.

in ssas visual studio olap:

1. there 10 measure groups. each measure group based on dsv named query selects 1 of facttablemain measures measurename is not null.
2. a drill action each measure group personname , personid columns being returned.

the drills each measure group:

1. shows duplicates (as not fact table columns return columns drill)
2. do not return expected number of rows measure count displays

i have tried:

1. multiple mdx conditions using filter , distinct on drill through action, either make no difference or action disappears entirely
2. create junk drill dimension selects distinct ids facttablemain , set return column drill through action (made no difference drill through return rows)
3. creating new (standard) action rowset , dataset, using mdx action expressions

i think need new (standard) action mdx action expression these properties:

• target type = cells
• target object = cells
• actions content type = rowset

my current mdx query return results, first measure's overall total , not formatted correctly @ all. not work if select different measure in client application, rerun query, , drill again. have searched , searched, out of ideas , sitting in black pit of doom. :(

my current mdx query is:

with    set [person]      nonempty([person].[person].[person])    member currentmeasure      [measures].currentmember  select    nonempty   (     filter     (       [quarter].[quarter].[quarter].members      ,[quarter].[quarter].currentmember     )   ) on columns  ,(     [person]    ,nonempty([person].[person id].[id])   ) on rows [applications]; 

goal: drill action dynamic enough know current measure user selecting , filtered user's dimension selection rows/columns.

questions:

1. is there way filter distinct or non empty rows using condition original drill through action? know there drill limitations, there workaround drill's limitations?
   2. how can create standard rowset action dynamically user's selections (my goal).
   3. any ideas?

a url action type not option our business needs.

edit: removed unnecessary dsv , selecting distinct rows. each id can have more 1 application , application can have more 1 area of interest. drills return 1 row per id, application, , area of interest. want drill return distinct ids, no matter number of applications or areas of interest. not sure go here. can filter our application number and/or areas of interest dimensions in drill?

i believe going fast quick. dsv should show data without duplication in browser. if it's not, go dsv , check is. maybe create view (an indexed view) on top of fact table, can make sure query data want. also: sure dimensions linked correctly? duplication appears due dimensions not being set correctly wrong keys linkage.

in mdx: if create calculation in calculation tab can drill in it. otherwise, you'll have write correct mdx query each , every time.

hth.