Cannot see "Generated SQl/MDX option" to the report studio report.

[Nani16904]

Hello Experts,

We have a report which is generated long back. We want to see where does certain columns come from database. Report is generated using a package published into Cognos environment. I tried to find the path of the columns using lineage option. But its displaying me path only till the package level. I couldn't see the option of Generated SQL for that report or any of the queries in the report under Tools or under the properties of report. May I know why I am not able to see that option.Or is there any way to check the path till database for particular column in a report.


Thanks