Interested to Buy Any Domain ? << Click Here >> for more details...
Where do you edit cognos sql in report studio?
- 3 Answers
- 15015 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / srini madhala
1. Pause the pointer over the query explorer button and
click the query you want.
2. In the Properties pane, double-click the Generated
SQL/MDX property.
3. Click Convert.
4. Make the changes you want.
If you are working with MDX, you must be aware of the MDX
syntax that Report Studio
supports.
5. Click Validate to check for errors.
6. Click OK.
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
what is the difference between list report and crosstab report?
What are the considerations regarding performance kept in mind while setting up cognos?
If we are migrating lower version of Cognos reports (e.g. from Ver 7.0 to Cognos 8) then how we migrate Impromptu Catalog (ver 7.0) in Cognos 8? Do we create FM model for that? Please explain.
What are all the types of indexes in Cognos?
What is the difference between static and dynamic conditions?
What do you mean by drill through report?
how you provide security to reports? How you provide security to packages ?
What is zero-foot print?
A product manager is analysing the sales made for each product, he has requested a report containing data for specific products. To do this we will create a report that includes a prompt page that filters on specific products within specific product subcategory and category.
What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.
Name the types of report?
hi my name is siraj i want to know cognos queriy language
What are the services provided in cognos 8?
Cleared COG-112 with 100% score today. What next certification should i go for?
What do you understand by user class in cognos?
