Where do you edit cognos sql in report studio?
Answer Posted / raju
copy the report to notepad to view the sql query for the
report. then you can play with the queries.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is looping and how to avoid it in framework manager?
What are slice and dice?
Explain difference between powerplay transformer and power play reports?
What are the ways to import data into catalog?
How is cognos model organization works?
Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?
what are the dimensions that you have in your current project?list them?
In my report i want display sales rep name, country ,city how to achieve this by using repeater table
What DB View and Bus View?
Can you define folder?
explain how to create powerplay reports?
What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.
what is the difference between filter and condition?
Can you define query studio?
how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.