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.

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

Answer / raju

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

is it possible to display the column names in first page but not in remaining pages i.e if a report contains 10 pages column names should be displayed in 1st page but not remaining pages ( 2 to 10)

2 Answers  

---

Can you explain cognos planning?

0 Answers  

---

what is #prompt and #promptmany, runningtotal in report studio

1 Answers  

---

Hi i want know mean and difference b/w render variable,conditional block and style variable please reply about them please be kind towards me

3 Answers  

---

pls any body give the cognos 8 versions release year.

3 Answers  

---

What are slice and dice?

0 Answers  

---

---------- Purpose of Factless Facttable?

2 Answers   Bank Of America,

---

what are typees of dimensions

11 Answers   HCL,

---

How can we convert imr report into Impromptu web report?

3 Answers  

---

which table we load first in DW. dimension or fact? why?

4 Answers   IBM, JPMorgan Chase,

---

I have 3 dataitems in a list username,transaction type,transaction amount. In transaction type i have 3 types 'add','update','delete', i have almost 750 rows. After displaying the list report i want to know no. of add's,update's,delete's in 3 different rows

2 Answers  

---

What are products of cognos?

0 Answers  

---