Hi Experts,

I have a below requirement for a project, I need all your support and help to complete the tasks.

 I have following dimension (Dim Emp) with multiple attributes

I have several measures in cube, my requirement is If I have both Large and Small attributes in the filter in cube. If I select "Y" in Large and "N" in Small. The measure should display values only for "Y" not for the "N" flag.

Filter:

Filter:

Please let me know the solution for my requirement.

Thanks in advance !!!

Regards,

Hi,

something like this:

SCOPE([Dim Emp].[Large].[Y]);

[Dim Emp].[Small].[N]=NULL;

END SCOPE;

SCOPE([Dim Emp].[Small].[Y]);

[Dim Emp].[Large].[N]=NULL;

END SCOPE;

Thank you for your reply !!!

It will apply to all the measures in my cube?

Regards,

Hi Siva,

If you want to apply your condition to all measures, you can limit the scope for all measures.

SCOPE(Measures.Allmembers);

   SCOPE([Dim Emp].[Large].&[Y]);

   [Dim Emp].[Small].&[N]=NULL;

   END SCOPE;

   SCOPE([Dim Emp].[Small].&[Y]);

   [Dim Emp].[Large].&[N]=NULL;

   END SCOPE;

END SCOPE;

Regards,