Include only these Dimensions in Set Analysis

[Anonymous]

=count(distinct{<[Enrollment Counter Date]={'>$(vPriorMonth12Max)'},[Eligibility Benefit Type]={'Medical'},[Claim Paid Period]=,[Enrollment Period]=>}[Member Months Counter]),

I have this formula in my application and I want to only include current selections from two of my possible dimensions to determine my chart output.  I have 100 dimensions in my app and want to ignore current selections from any others.

I know how to exclude specific dimensions in Set Analysis by using      [Claim Paid Period]=   It obviously is not practical to add all of them in this matter.

How do I specify in Set Analysis to only include selections from my two desired dimensions  [Name] and [Group Number] and ignore the rest?

[swuehl · Accepted solution]

Try something like

Count( {1<[Name] = $::Name, [Group Number] = $::[Group Number] >} FieldName)

[sfatoux72]

swuehl is right.

Just to explain her solution :

Count( {1<[Name] = $::Name, [Group Number] = $::[Group Number] >} FieldName)

1 To specify that we use the entire set of data without take care of the user selection

[Name] = $::Name To specify that we will assign to the field "[Name]" of the Set Analysis values of the field "Name" defined by the user selection ($)

[Anonymous]

I am testing this right now.  As you can see, I have a variable filter and a static filter in my example above.  Can this solution work in conjunction with those?

[sfatoux72]

Yes, without problem

[Anonymous]

Thanks to both of you!   I was able to make it work!  I looked pretty extensively through the forum and did not find anything like this.  This looks like a good topic for the resource library.  One of the two of you should create a document to post on this.

[sfatoux72]

You could find information about this solution here:

• Set analysis and set expressions about the identifier 1
• Examples of Alternate States in Chart Expressions about the selection [Name] = $::Name