Interested to Buy Any Domain ? << Click Here >> for more details...
Hi all, I have a list report with Country, City & Revenue. In
the run time i want to hide the particular column. I have
tried using Java script but i didn't get any out comes.
Please any one share steps for me....
- 2 Answers
- 6055 Views
- I also Faced
- E-Mail Answers
Answer Posted / ln
Hi,
Q:-Conditionally Select Country, City & Revenue in a
Report?
Render Variable:-
1.Drag List-Country, City & Revenue;
2.Go Page Explorer, Click on Prompt Pages, Drag page-->
Open Prompt Page;
3.Drag Value Prompt-name as Parm_StaticChoice;
4.Select V.P, in Properties Click on Static Choice - Add
Use&Display Values as Country-Country, City-City & Revenue-
Revenue, Click Ok;
5.Go Condition Explorer, Drag Boolean Variable--> Give
condition as Drag Parameter1 - ParamDisplayValue
('Param_StaticChoice') = 'Country' ;
--Drag Boolean Variable as -- ParamDisplayValue
('Param_StaticChoice') = 'City' ;
--Drag Boolean Variable as -- ParamDisplayValue
('Param_StaticChoice') = 'Revenue' -- Click Ok. ;
6.Add Values as Country, City & Revenue - Click Ok;
7.Go to page1 - Select Entire 'Country' Column - in
properties Render Variable as Boolean1, click ok, Curser
move on Condition Explorer select BOOLEAN1, Double click
on Green colour Vertical bar;
8.Select Entire 'City' - in properties Render Variable as
Boolean2, click ok, Curser move on Condition Explorer
select BOOLEAN2, Double click on Green colour Vertical
bar;
9.Select Entire 'Unit Cost' - in properties Render Variable
as Boolean3, click ok, Curser move on Condition Explorer
select BOOLEAN3, Double click on Green colour Vertical
bar; Save & Run Report.
Do u hve any queries get me in touch ln.cognosbi@gmail.com
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr
How to join multiple db in catalog?
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
Can you define cognos decision stream?
What you mean by drill across and what is the difference between drill through, drill across?
Can you define a catalog and types of catalogs in cognos?
What is the size of database for you project?
What is drill down and slicing and dicing whats the difference between them?
Explain about scorecarding?
What are the steps to import the two data sources in framework manager?
What is the difference between a data mart and a data warehouse?
Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?
What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?
how you provide security to reports? How you provide security to packages ?
How can we Maintain the Cube Security by Category level and Dimension level ?
