How to display which reports in Reports Studio are accessing specific cube?

[abcuser]

Hi,
using Cognos v8.4.1 Report Studio accessing Cognos TM1 v9.5.2 cubes there are a lot of reports. Many of this reports were made by end-users. In one of the TM1 cube I have to rename the measure. This change will influence on reports made by Report Studio. Is there any way I could get the information which reports are accessing specific cube? (Or even specific measure in cube?). Before renaming a measure in cube I would like to see the number of reports that needs changes to make an estimate of time needed for making this changes. There is probably some way to get this info like writing some SQL to Cognos BI content store. Any idea, suggestion?
Thanks

[Prerna Chaudhary]

Hi,

Though,I have never worked with cubes but have tried the following steps in Report Studio to know the server name of the reports.This procedure requires selecting the appropriate DSN of your report.Please find the steps below:
Go to the Query Explorer in the report Studio
Click on Queries
Drag a SQL component from the left hand side pane
In the properties pane of the SQL component appearing at the left hand side ,select the datasource appropriate to your report
Type the following SQL within the component:
Select @@servername as server
Click on Validate and then OK
Then view the tabular data of the Query.
You can then come to know the server name that your reports are pointing to.
In this way,you can come to know the number of reports that are using the same DSN as that of the cube...
The number of reports using the same DSN as that of the cube one.. will be the number of reports impacted.
Then you can plan your estimates accordingly required for the changes

Hope this works for you

Thanks and regards
Prerna
pchaudhary@infocepts.com