Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Cognos
  2. Suggest New Category

Where do you edit cognos sql in report studio?

Question Posted / vinod

Answers were Sorted based on User's Feedback



Where do you edit cognos sql in report studio? ..

Answer / 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

Where do you edit cognos sql in report studio? ..

Answer / sathish

copy the report to notepad to view the sql query for the
report. then you can play with the queries.

for copying the report to notepad( tools -> copy report to
clipboard)

then after editing import by (tools -> load report from
clipboard)

sathishcnpt.938@gmail.com

Is This Answer Correct ?    3 Yes 4 No

Where do you edit cognos sql in report studio? ..

Answer / 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

More Cognos Interview Questions

What will happen if scheduling a report with a prompt page?

1 Answers   Ness Technologies,

1)How can we do the Union in Report Studio? 2)What is the meaning of Aggregation and Rollup Aggregation? 3)How can we hide the columns in Report Studio and How can we view the hiding Objects? 4)Can we provide joins in Report Studio and in which situation we can go for outer join? 5)If we take a Date Prompt and run it once it will show default data,how can we change it exact 1 month back data?

1 Answers  

what is the role of cognos comsultant?what actually it means?pls reply

0 Answers  

how to create average on totals of different departments employees salary...? consider we have 3 dept and in each dept 10-15 workers i need to get the totals separately for each dept and average of there totals..help me pls

2 Answers   Patni,

-------------How to create a PortalTab?

1 Answers   Cap Gemini,

How do you Parametermap variables in Quiries?

0 Answers   TCS,

what is bobble chart?

1 Answers   Syntel,

What is Cardinality

6 Answers   Cognizant, HCL,

How to connect three fact tables?

11 Answers   L&T, TCS,

Can you define a datastore in cognos?

0 Answers  

-------------Diff b/w Union and Unionall?

3 Answers   Cap Gemini,

Which service handles requests for cognos connection,query studio and event studio.

3 Answers   HCL,

For more Cognos Interview Questions Click Here
Categories