How to Filter out a Field Within a Multi Dimensional Cube

[Cognos Peasent]

Hi All,

I have a report that contains a slicer set that looks like this

set([France],[Belgium],[Netherlands],[Italy],[Spain],[Portugal],[Germany],[Austria],[Switzerland Cluster],[Sweden],[Denmark],[Finland],[Norway],[Czech Republic],[Hungary],[Poland],[UK])

My stakeholder mentions that they want France's data but excluding a field called "Regional Management" from the following hierarchy member for France (see attached image)

I've tried researching on the internet and found the following .PDF but I'm having trouble applying it to my problem http://public.dhe.ibm.com/software/dw/dm/cognos/reporting/dimensional_queries/advanced_multidimensional_reporting.pdf

Can anyone give me a hand?

Thanks!

EDIT:

Also contains a slicer that looks like this

#promptmany(
      'pDepartments',
      'MUN',
      '[Perspective_1].[Departments].[Standard Dept Hierarchy].[(All)]->:[YK].[Departments].[Standard Dept Hierarchy].[All]',
      'set(',
      '',
      ')'
)#

[MFGF]

Hi All,

I have a report that contains a slicer set that looks like this

set([France],[Belgium],[Netherlands],[Italy],[Spain],[Portugal],[Germany],[Austria],[Switzerland Cluster],[Sweden],[Denmark],[Finland],[Norway],[Czech Republic],[Hungary],[Poland],[UK])

My stakeholder mentions that they want France's data but excluding a field called "Regional Management" from the following hierarchy member for France (see attached image)

I've tried researching on the internet and found the following .PDF but I'm having trouble applying it to my problem http://public.dhe.ibm.com/software/dw/dm/cognos/reporting/dimensional_queries/advanced_multidimensional_reporting.pdf

Can anyone give me a hand?

Thanks!

EDIT:

Also contains a slicer that looks like this

#promptmany(
      'pDepartments',
      'MUN',
      '[Perspective_1].[Departments].[Standard Dept Hierarchy].[(All)]->:[YK].[Departments].[Standard Dept Hierarchy].[All]',
      'set(',
      '',
      ')'
)#

Hi,

You haven't indicated if the members in your set are members of the hierarchy you posted (Standard Dept Hierarchy), and if so at which level they reside?

As you've mentioned a slicer set, can we assume these members are just used for context (ie filtering the measure values) rather than being displayed? How does the set of prompted-for members relate to the set in your slicer filter? It looks like the same hierarchy? Do you have both a prompt and a hard-coded set? Can you explain the logic?

It's hard to know how to advise you without knowing any of this. I'd guess the attribute in your attachment relates to members lower in the hierarchy than yours? Probably you'd need to use a filter function in your expression, based around that attribute, but without knowing the situation it's just a guess.

Cheers!

MF.