Interested to Buy Any Domain ? << Click Here >> for more details...
suppose there are 15 countries like (US, UK,
ENGLAND,INDIA,JAPAN.......)i want a value prompt in the
report and this value prompt should contain groups like
group1(US,UK,ENG), group2(INDIA,US,UK), group3
(ENG,JAPAN,INDIA)and in the value prompt the values should
be group1,group2,group3 how can we do this?
- 4 Answers
- 7821 Views
- I also Faced
- E-Mail Answers
Answer Posted / abhay puranik
Create a query,drag the Country column,Drag data item from
the tool,name this as Group,Now in the expression
corresponding to this data item,write if(geography contains
('','','') then 'Group1' elseif(Country contains('','',''))
then 'Group2'......And use this query for the query
property of value prompt and use Group as column diplayed
under value prompt.Now,in filter for the main page use if
(Group='Group1') then (Country in ('','','')) else
if.....save report and run.
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
Can you define framework manager?
What is the model filter?
Which studio is used to create reports?
3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.
What condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)
What is the complex report you faced in real time?
I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?
hi i need to rename a file in cognos8? can anyone help me out how 2 do it? pls suggest some solution such as using a batch file or using a procedure node or anything to rename the file
What is the difference between the content store and content manager?
What are all types of Batches?
What is the difference between set functions and filter function in dimensional data?
What actually a project contains?
Define olap designer?
Define the cognos reporting tool?
Explain what is the difference between microstrategy and cognos reporting tool?
