Static Choices

[srinu_anu2007]

Hi,

I have two prompts and in first prompt 1. i have added 4 static choices, Infra, Apps and IT Risk, WaaS and Social , Business Operations and All, I have enabled auto submit to Yes and parameter for this P_area
2. 2nd prompt i have assigned a query, and parameter is Parameter1 and assigned cascade to prompt1 i.e p_area

3.  When i select any one of the static choices from 1st prompt i have to display those values as per attachment and whatever i select those value only should display in output
4. I have written a case statement in main query like below

case when (?PArea?='Infra, Apps and IT Risk') then ([Presentation Layer].[Project Area Dim].[AREA_DESC] in ('IT Initiatives', 'IT Services', 'IT Security and Compliance'))
when (?PArea?='WaaS and Social') then ([Presentation Layer].[Project Area Dim].[AREA_DESC]='Social')
when (?PArea?='Business Operations') then ([Presentation Layer].[Project Area Dim].[AREA_DESC] in ('Sales Connect', 'Sales Transformation'))
when (?PArea?='All') then (1=1)
else ([Presentation Layer].[Project Area Dim].[AREA_DESC]=?PArea?)
end

5. same statment i have used in 2nd prompt also. as per requirement iam getting but when i select any one of the values in 2nd prompt iam getting all values

ex: I am selecting in 1st prompt: Infra, Apps and IT Risk and values displaying according to that static choice and when i select 'IT Initiatives' and iam getting whole values whatever coming under that.

Kindly correct where iam doing wrong, I want to show output as whatever i select that value one only i have to show in output.

and I have to add some security for static choices and areas whatever mentioned in Notes. Please find the attachement more clarification.

Would appreciate if i get any suggestions or if anybody done this in your experience.

I am giving explanation watever ihave done to understand more and to get reply from experts. don't misunderstand iam giving my requirement.

Thanks,
Sri

[srinu_anu2007]

anything wrong while asking help from experts. nobody replying to my post.

Thanks,

[MFGF]

anything wrong while asking help from experts. nobody replying to my post.

Thanks,

Not even three hours elapsed before you started pressing for an answer? People on here will reply if they have anything valuable to contribute and if they have time. if you try to push people for answers, you run the risk of them not bothering because they feel they are being taken for granted.

MF.

[srinu_anu2007]

not like that MF. I am just asking whether it's understandable language or not, if anybody not understanding i can't get suggestions.

Thanks,

[BigChris]

Forgive me if this seems obvious, but it looks like you need two prompts. The first one needs to have your static choices, and your second one needs to select the values from the database, based on the first prompt.

I think you need the logic switched round for the second filter - something like:

case
when [Presentation Layer].[Project Area Dim].[AREA_DESC]  in ('IT Initiatives', 'IT Services', 'IT Security and Compliance') then 'Infra, Apps and IT Risk'
when [Presentation Layer].[Project Area Dim].[AREA_DESC]='Social' then 'WaaS and Social'
when [Presentation Layer].[Project Area Dim].[AREA_DESC] in ('Sales Connect', 'Sales Transformation') then 'Business Operations'
else 'All'
end = ?pArea?

[srinu_anu2007]

Thanks Chris for your suggestion. I got the solution after struggling and it's a small thing and it may be silly also.

above mentioned Point no 4. that is main list report based on that one only iam developing report so there i have given one more filter as:

?Parameter1?='All' and 1=1
or
[Presentation Layer].[Project Area Dim].[AREA_DESC]=?Parameter1? so iam getting correct values. if i select single value that value only iam showing and if select All, iam showing those.

Thanks,

[srinu_anu2007]

these 3 iam showing in my static choices prompt and each static choice will have one head
Prompt1(groups)
----------
Infra, Apps and IT Risk,----------- headed by x
WaaS and Social , --------headed by y
Business Operations ------------headed by z

Prompt2:(Areas)
------------
when they select 'Infra, Apps and IT Risk' and i will get values in 2nd prompt those are IT, ITES etc. IT is having one head

ex IT----headed by K
     ITES----headed by L

when they select 'Waas' and i will get values in 2nd prompt those are Social etc. Social is having one head


as per my requirement/understanding: when area head selected by K that will show by default in 1st prompt. This is what iam thinking. Please correct me if iam wrong/ any more details.

Requirement:
============================

1. Each tower lead should by default have his/her tower selected in Cognos. If required, tower lead can select other tower / area to see the report

2.  Each area lead should have his/her area selected in cognos. If required, area lead can select other area to see the report. 

3. Each area lead should have read and write access to his/her area and read only access to all other areas.

4.  In Cognos, while displaying reports for multiple areas,  tower to which the user is associated, should be selected first, by default. User would have an option to select other towers or simply "All" areas. 

I am not getting any ideas, can some one help me to get out of this.

Thanks,
         

[srinu_anu2007]

Any  idea's

[Lynn]

I'm not sure I understand your question. You can use a session parameter to figure out who the user is but you'd need something in your data source with the same information in order to figure out what tower or area that person is responsible for.

What is meant by read/write access in point 3? Reporting is generally about reading only unless it is in reference to saved output or content in Cognos Connection, both of which are unrelated to prompts in a report.

[MFGF]

Any  idea's

Hi srinu. I already asked you once in this thread not to be pushy, but here you are doing it again? I'm going to ask you nicely one more time - please stop trying to push people into answering your questions. Members will post if they have something useful to say and at a time that suits them. You need to be respectful of others and their commitments. Just saying "any ideas" is equivalent to saying "come on - give me an answer". If you want to bump a post, add some useful information on what you have tried in the meantime and how successful / unsuccessful it was. Show other forum members that you are trying to work the problem and put in effort on your own part. The impression you give here is that you are posting questions then sitting idly waiting for someone else to hand you the answer, posting periodic "hurry up" messages when you don't get instant solutions. While I'm sure that's not the case in reality, it could certainly be inferred by some people based how you posted your bump messages. I'm sure you can see how off-putting this could be to anyone who might be initially tempted to help you, so in the end it works agains your original intent.

MF.