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.

how you create security to cubes ?????

4 Answers   iFlex, iGate,

---

I have to apply drill through 1,2,7 out of 10 in order method, how can i do?

1 Answers   Satyam, TCS,

---

in u r data u having duplicates how to fetch the latest data in our report?

2 Answers  

---

please please give me some banking calculations in framework manager.

0 Answers  

---

set scope level in transformer

2 Answers  

---

describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?

0 Answers  

---

Wt is the Diff between Business Key & member caption?

2 Answers  

---

what is the use of backward drilling in cognos 8?is it possible?whats the uws of it?

0 Answers  

---

what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these

0 Answers  

---

9. What was the most complex type of report you dealt with?

0 Answers  

---

Hi, I have Cognos 7.0 Impromptu reports and these reports have been created with the Mainframe datasource. Now the business needs these reports should be upgraded but with Oracle datasource. So what's the idea, first we should migrate these reports into ReportNet? then in that case what we will do with the Impromptu Catalog? Second, suppose we need to migrate these reports into Cognos 8 (may be 8.4) then how we will do that? do we need to create a FM Model for these reports. Please advice!

0 Answers   Wipro,

---

diff b/w layout calculation and query calculation

2 Answers   Cap Gemini,

---