Static Choices creation and auto submit

[srinu_anu2007]

Hi Experts,

I have value drop down values and i want to create here groups like Telecom, IT etc..  Mobility and Network values will comes under Telecom group so i want to create one group here like that i have to create some groups and when i click on Telecom both values should display and when i click on any one of the value that should display. Any ideas would appreciate.

I am getting a picture in mind but how to implement not getting. Create some static choices as groups like IT and Telecom and auto submit and this idea may not be correct also.

Environment: Cognos 10.2.2, Relational Model

Thanks,

[bdbits]

It sounds like you have a hierarchy, and what you really want is a tree control.

[sdf]

or are you talking about two separate value prompts.
the second prompt values depends on the selected item from the first value prompt.

[srinu_anu2007]

SDF, May be your right, can you please explain more how can i procedure.

My Assumption is 1st prompt i have to create with static choices without pointing to a database and i have to create those groups like IT, Telecom, etc..... and i need to enable auto submit yes?
and 2nd prompt pointing to database and cascade to 1st prompt? Is it correct? am i missing something

Please explain your thoughts.

Thanks,

[sdf]

Hi Srinu,

Here are my thoughts,
Since your grouping is not included in the actual database (not part of the hierarchy that's why you want to create static choices) i think you cannot use tree prompt for this.

Theoretically, you can accomplish the cascading prompt. You can create data items for the grouped items.

1. Create static choices for the First prompt.
  e.g
group1,group2,group3

2. Create data items that collects items for each static choice you created for the first prompt.
e.g
set([item1],[item2]..) --> this is for the first prompt <selectedgroup1>
set([item3],[item4]..) --> this is for the first prompt <selectedgroup2>
set([item5],[item6]..) --> this is for the first prompt <selectedgroup3>
*it's up to you how you want to collect your data for grouping.

3. Create another data item work your way with IF or case conditions.
e.g
[setgroup] <--use this for the 2nd prompt's Use Value

if (?Prompt1? = 'group1' )then
([selectedgroup1])
else
...

*this are the first ideas that came to my mind. Im not 100% certain about this.
Actually just now that im typing this, i think you'll be having problems since you really need to auto submit first prompt to pass data for your second prompt. Which i think would force the page to refresh. As i said, im not sure.. but you are free to try.

cheers!

[srinu_anu2007]

Hi SDF,

Thanks for your help. i showed to client and he changed his mind and they want to add different groups in a single prompt whatever i have attached those values are coming from DB apart from i have to add some groups in the same prompt. When they select Telecom group and they want to show Mobility and Network values, when they select IT group, IT related values should come so we have to define Telecom values inside.

What iam thinking for adding Groups i will go and add some static choices like IT, Telecome etc...but these groups related values where i have to define. If you have any thoughts please share with me.

Thanks,

[sdf]

the easiest and fastest way, and i must say the most reliable way to solve this is by adding those Groups to your database.
As to what i understood from your last post is that you're looking at adding user defined items (static choices) to a set of items fetched from your database as value source for your prompt?  Will this not cause redundancy? In the attached file, i can see Mobility and network. So if you add a group "Telecom" in the same prompt, where do you expect it will show mobility and network? to the second prompt? and what happens if user select "Mobility" in the first prompt?

Please clarify and expound.

[srinu_anu2007]

There is no 2nd prompt, only one prompt required i.e. drop down whatever attachment is there those values are coming from DB as explained early.

2. I have added static choices as Telecom group and IT. I have given filter in report query as: ?PArea?='Telecom' or [AREA] in ('Mobility', 'Network', 'Network Architecture') Area is nothing but values and when you click on telecom, expected output iam getting there is no problem.

3. How do i add more groups and i want to add in the same filter like ?PArea?='IT' or [AREA] in ('IT Services', 'IT Initiatives')

4. WHen you click on IT it should show only IT values.

Hope you can understand now. If you get any thoughts further please share

Thanks,

[sdf]

Sorry im really lost with your requirement. I really would like to know what you are trying to achieve.
So let us say you have 1 prompt, let say "Select Area Prompt" which as you said contains all items stated in your attachment as well as the static choices you created (Telecom,IT). I would like to know after selecting "Telecom" where will the output "(Mobility,Network..)" will be displayed or will be used?

What im seeing here is that you need to work your way with conditions, used IF/Else or Case conditions.
Which will show your expected values depending on the selected ?PArea? values.
Like, If ?PArea? = 'Telecom' then use/show [set of values] else if ?PArea? = 'IT' then use/show [set of values 2]... else [AREA].

Im really sorry, i think we really are not into the same point of view with this one.

[srinu_anu2007]

Thanks SDF for spending your time and help. i got the solution.

I have created static choices without using DB values and static choices are All, Telecom and IT groups.

2. I have created filters in my report query as below

?PArea?='Telecom' and [Presentation Layer].[Project Area Dim].[AREA_DESC] in ('Mobility', 'Network')
or
?PArea?='IT' and [Presentation Layer].[Project Area Dim].[AREA_DESC] in ('IT Initiatives', 'IT Services')
or
?PArea?='All' and 1=1

3. I have created a string variable like below and values are 1, 0

case
when ParamDisplayValue('PArea')='All' then 1
else 0
end

4.I have assigned that variable to my conditional block and when i select 1 showing mobility and 0 for network and I did sectioning on 'Area' from my list

5. When i Select All and click on submit, iam showing all values from DB like attached screenshot

6. when i Select Telecom and iam showing those values and same as IT