how to know which all tables/cubes the report is referring to

[sumitthakral]

It is very urgent and important. I am new to cognos. I have been given a working report on cognos which has many drop down menus . I want to know which all tables this report is referring to . In other words , i want to know from which tables/cubes this report is fetching data from. All i can see from viewing the html page source of the page is the package my report is referring to.. but there are a number of tables in that package. i want to know specifically which tables is this report fetching data from when it is run. I suppose that it being an active report, was prepared using report studio; but I dont have the cognos report studio installed right now. what is the way out. how to know which tables/cubes the report is fetching data when it is run????? any help is MOST WELCOME

[BigChris]

I can't think of a way to get to that information without access to Report Studio.

[Lynn]

Report Studio is a web based application, so if Cognos is installed and operating, which it must be if your Active Report is running, then all you need to do is have the capabilities for your credentials turned on to allow access to Report Studio.

As BigChris said, I'm not sure there is a way to do it without RS.

[cognostechie]

It is very urgent and important. I am new to cognos. I have been given a working report on cognos which has many drop down menus . I want to know which all tables this report is referring to . In other words , i want to know from which tables/cubes this report is fetching data from. All i can see from viewing the html page source of the page is the package my report is referring to.. but there are a number of tables in that package. i want to know specifically which tables is this report fetching data from when it is run. I suppose that it being an active report, was prepared using report studio; but I dont have the cognos report studio installed right now. what is the way out. how to know which tables/cubes the report is fetching data when it is run????? any help is MOST WELCOME

Double posting is not going to get you answers any quicker and writing in bold is considered rude and demanding. People help others here on a voluntary basis only and are not required to do so.

I can't imagine why your employer would ask you to get the source information without granting you proper access. What's your role in your company?

[sumitthakral]

gotcha...will need to get report studio working now...