Interested to Buy Any Domain ? << Click Here >> for more details...
suppose a value prompt contains 100 values and i want to
select all values in that prompt....i want ALL option in
the value prompt? how can u keep this option in value
prompt?
- 5 Answers
- 16992 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / hannah
To create an All static choice in the Year parameter follow below steps:
1. Create a Static Choice with Use value as 1 and Display value as All.
2. Create a query for the prompt with the following definition
[Year] <= {year(getdate())}
Run the report and your report works as if all the years were selected.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?
Can you define framework manager?
What is set to be Cognos configuration?
What do you mean by query studio?
Explain the difference between native sql and cognos sql?
what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)
Name the types of gateway?
Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?
Explain difference between powerplay transformer and power play reports?
How create measures and dimensions?
Can you define drill down and drill up?
--------------Diff b/w ODS and OLAP?
Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?
what are the names of the reports that you prepared?
i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..
