how can you restrict the number of values available for a
prompt?
i tried this by using static choices property, but i dint
get result... so pls explain in detail steps....
Answers were Sorted based on User's Feedback
Answer / chandra
when you create prompt report studio create a separate query
for that prompt. in this query write the filter condition.
It will filter the prompt values in prompt.
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / vij
hi
Click that particular prompt and go to the Properties
pane , in that select the property Rows Per Page and set
the value that u want e.g. 5000,100000 etc.
Hope it will help u
Thanks,
vij
:)
| Is This Answer Correct ? | 4 Yes | 10 No |
hi How Can we create rank in our report?i feel difficulty pls expain me with ex,pls pls........
what is the difference between native sql and cognos sql?
hi, i am Having 2 Reports one list report,one crosstab report if i put 2 querys for 2 reports which query will execute first?if i put same query for both 2 which report i will Get?pls pls pls Explain me...
What is a Complex report and explain?
Did you find any differences in bursting feature between reportnet 1.1 & cognos 8? what are the differences?
It is possible to select more query items in value prompt? i.e when i use drag down i want to display these items like customerid in customer query subject, employeeid in employee query subject and orderid in order query subject..?becoz i want u display when i select a value(ex:customerid)in value prompt ,i need to display another report for all details customer.So, i need how to link for that process...? pls tel me any one knows ,i want to create that report..? thanks , basha
How do you schedule process automatically in cognos.I.e we have 50 reports and 100 users that will schedule daily, weekly, and monthly basis? Pls, give the answers the query early on.
What is the basic relationship between measures and dimensions in transformer modelling
If anyone need COGNOS 8 Certification Dumps of any "COG - Code", u can get from S_Cog@Yahoo.Com, i scored 100 % with these Dumps
10. How many queries did you use in the complex reports? 11. How will you use the joins in the queries used in your report? 12. How many reports did you create in your project? 13. How many cubes did you create in your project? 14. How will you create .iqd file in FM. 15. Was your package multilingual or single language? 16. If you have created a single language package…and you have a client who need to access that in other language…how will you do that? 17. How many dimensions and facts did you use in your reports? 18. How will you use your package in Analysis studio? 19. Something like types of files in power play like pyi..i don’t remember this question. 20. If you want to create a prompt with 4 list, not containing any value using value prompt, which when we will see in the run time…if we will select any list, it should show us the data related to that list. 21. What all kind of packages you can create using FM. 22. In your project was your cube a relational or multidimensional? 23. I replied MD for the above question then they asked why did you use that? 24. How do you publish a cube? 25. Slicer and dicer….its use…where is it used? 26. Bursting…. 27. How many types of query subjects are there? 28. Difference between before and after aggregation?
can any body clesrly explain about types of query subjects.that is data source query subject,model query subject,stored procedure query subjects?
What is slowely changing dimensions?why we are used SCD?