Detail Filters and Slicers behaviour

[cognos05]

Dimension package
Scenario:
Dimension : Location
Level 3: Region
Inside Region there are individual members like West, East, South, Pacific etc...
There is no all regions member at this level3.

Now if I create a value prompt with level 3 as the data and a detail filter adds automatically in my main Query.
[Level3]= ?RegionPropmtName?
Now I run my report, by default the data is shown for all region values with the default value as prompt name selected  ,even i dont have all value as my member and if I click on the drop down there are individual  region items.

Scenario 2:
Now when I add the same prompt and the data being same level 3, I remove the detail filter and Instead add a slicer
[level3]->?RegionPropmtname?

Now this will ask me to select a value say any specific region, but here I don't have a all region value. If I wanted to show the same all as above that happened in case of detail filter, wat  should I do.I want this prompt to be optional and show all values initially and then on click of drop down show the individual regions.
I think in earlier case report studio automatically unions all the values and shows as a default propmt name in the combo and substitiues all for that selection.
How to achieve the same with slicers

I wanted to achieve this in many reports ,because I am not able to remove my detail filters because of this one reason.

Thanks,
Nithya

[MFGF]

Dimension package
Scenario:
Dimension : Location
Level 3: Region
Inside Region there are individual members like West, East, South, Pacific etc...
There is no all regions member at this level3.

Now if I create a value prompt with level 3 as the data and a detail filter adds automatically in my main Query.
[Level3]= ?RegionPropmtName?
Now I run my report, by default the data is shown for all region values with the default value as prompt name selected  ,even i dont have all value as my member and if I click on the drop down there are individual  region items.

Scenario 2:
Now when I add the same prompt and the data being same level 3, I remove the detail filter and Instead add a slicer
[level3]->?RegionPropmtname?

Now this will ask me to select a value say any specific region, but here I don't have a all region value. If I wanted to show the same all as above that happened in case of detail filter, wat  should I do.I want this prompt to be optional and show all values initially and then on click of drop down show the individual regions.
I think in earlier case report studio automatically unions all the values and shows as a default propmt name in the combo and substitiues all for that selection.
How to achieve the same with slicers

I wanted to achieve this in many reports ,because I am not able to remove my detail filters because of this one reason.

Thanks,
Nithya

Is there an "All" member at the top of the hierarchy? You could use this, and change your report expression to be [hierarchy] -> ?RegionPromptName?

Cheers!

MF.

[cognos05]

My Dimensions Level looks like below  DImension Name - YY

1) AllLevel--First Level in Hierarchy

Has one member say Allregions and this will have everything.

2)  RegionLevel -Second Level in Hierarchy
Has members being individual regions like East, West each being a member

3)  Distributor Level - Third Level in Hierarchy
has distributors each being member like A,B,C

4) Rep Level - Fourth level in Hierarchy
has many reps each being single member TOM.JOHN

5) CustomerAccount Level - fifth level in Hierarchy
has many customers each being individual members like 1244545,12121

So If I want to show all distributors and individual distributors in my prompt with respect to slicers how does it work ?

Do you mean the top member here in my Hierarchy is Allregions which will include all the values under this.

So should I do a union of(Allregions,Descendants(Allregions,Distributor Level) and give as use value to prompt and set the expression as
Hierarchy->?propmtName>

Thanks,
Nithya

[cognos05]

Thanks MFGF , It Worked,but the only issue is i have the parent member name as All Regions, which would be great if it is ALL ,so that it is understandable.
Can I change the display name for this All  regions (ie) the parent member .

If I want to use a cascading prompt with the first prompt being distributor and I union and show the values.How will the expression of my cascading propmt be. In case of detail filters I dont need to do anything.It works automatically . I have posted my scenario in the below post.

Thanks,

[cognos05]

I show the Distributor with All member from level1 and individual distributors at level 3.And it works since I gave slicer expression as  Hierarchy ->?Prompt name?
Now If I want to use a cascading prompt with this distributor and  say sales rep which is the next level to distributor.
both these values are now showed in rows nested

Prompt1 - Distributor
Prompt2 - Sales Rep

How should my Slicer expression be, both the prompts  appear in  rows.
I would like to achieve is the value all selected for distributor prompt on running of report. and cascading work on select the reps as well.

Expression for distributor prompt query - union(All Members from level 1 ,Descendants(All Members, Distrbutor Level 3)) and say name the prompt as DistribPropmt
What will my distributor data item expression be and also  I am Stuck here on how to proceed then ->  I should pass this value of distribuotr to sales rep prompt .And the value of distributor propmt has member from level1(all) and level 3(individual distrib)
How will my expression on the row data item for distributor and sales rep  be..Is this possible

Thanks,
Nithya

[navissar]

Hi there,
First, Nithya, I think that three board messages + a PM to me over the course of three hours is awfully close to a forum abuse. Please read the forum etiquette post and refrain from that in the future.

As to your case, why not use a tree prompt on the hierarchy? This will allow users to see the different members in the hierarchy as they are sorted, and to pick whatever they want. 

[MFGF]

First, Nithya, I think that three board messages + a PM to me over the course of three hours is awfully close to a forum abuse. Please read the forum etiquette post and refrain from that in the future.

Nithya, please do not be pushy with other forum members like this. It is not polite and it is not acceptable. Please refrain from this behaviour in future. I'm sure you did not intend any malice, but nonetheless your behaviour in these activities inappropriate. Consider this a friendly steer in the right direction from a forum moderator...

MF.

[cognos05]

Okay . I dint mean to send three posts, but  wanted to explain the issue in clear. I will wait until you guys respond. You guys are my source  of help :)

Thanks,
Nithya