Filter on All Member top level in union query

[cognos05]

Hi All,
I have All Regions at my first level of hierarchy and there are few more levels.

first all regions
Second Individual regions
Individual Distributors.

I used union(Allregions (top most Member),Descendants(Set(East,West),Distributor Level))

so my prompt will have values all regions, Distributors from East and west region)

I will give my default value of prompt to be the mun value of all region member.

Hierarchy-> prompt value.

Now this All regions member will refer to all the regions , can i add any filter to show only specific regions when this is selected.
Exmple - All Regions selection will pull only for records of east and west

Thanks,
Nithya

[adik]

so...what is the question?

[cognos05]

All regions member will refer to all the regions , can i add any filter to show only specific regions when this is selected.
Exmple - All Regions selection will pull only for records of east and west /

Thanks,
Nithya

[cognos05]

I have all items at my top level and I am using this in my propmt
like propmt query - union(all items, Descendants(all items, Level3)

Now If I select all items in my prompt it will show data for all the regions, but I want this to show only for few regions on All items selection.

Can I apply some filter on this, is it possible to achieve this.

Thanks,
Nithya

[cognos05]

Hi All,

Any suggestions on the below issue.

I appreciate your help.

Thanks,
Nithya

[sujitgouda]

You can create your own filters or Parameterize the same, might as well use cascading prompts.

[cognos05]

How to create own filters, can you let me know the code.

my current query to prompt is

union(allitems,descendant(all items, level3))

Now all item members has different regions say a,b,c,d
and on selection of allitems  i wish to show only data for a,b,c.

where should i write my filter.

Thanks,
Nithya