Interested to Buy Any Domain ? << Click Here >> for more details...
how to get the all values from a prompt using 'ALL' use and
display value in prompt
- 3 Answers
- 7363 Views
- I also Faced
- E-Mail Answers
Answer Posted / venkatesh
In your value prompt add the static chioce as 'All'
and in filter put the expression as....
(column in (?Parameter1?)) or (?Parameter1?='All')
| Is This Answer Correct ? | 12 Yes | 1 No |
Post New Answer View All Answers
Can you define cognos impromptu?
What is the importance of having monitor service in cognos?
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)
When we save a report in report studio with what extn it save?
I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?
1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?
What are the methods by which it non-durable model could be changed into the durable model?
How can we Maintain the Cube Security by Category level and Dimension level ?
Can you define a catalog and types of catalogs in cognos?
What DB View and Bus View?
------------ Diff b/w MemberCaption and MemberDescription?
Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.
I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.
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?
Can you define cognos decision stream?
