![How to find out schema name in Cognos Report Studio Report issues-after-qlikview-version-upgrade-on-passive-node-of-production-servers](https://www.s-squaresystems.com/wp-content/uploads/How-to-find-out-schema-name-in-Cognos-Report-Studio-Report.png)
Please find the below steps to find out the Schema name of the Query Subject or Report Item:
-
- Open report with report studio
- Go to the Source Tab and select the Query subject or data item as shown in below screenshot
- Right click on the Query subject or data item to know from which schema it is coming from
- Click on the Lineage property as shown in the below screenshot.
![Picture145](https://www.s-squaresystems.com/wp-content/uploads/Picture145.png)
-
- Here it opens a separate window which provides the Business view and Technical view of the selected item coming from the Data Source.
- Under Business View tab à Data Sources, Data Source Name will be available.
![Picture146](https://www.s-squaresystems.com/wp-content/uploads/Picture146.png)
-
- After getting the Data Source Name, In Cognos Connection, Go to Launch à Click on IBM Cognos Administration
![Picture147](https://www.s-squaresystems.com/wp-content/uploads/Picture147.png)
-
- Click on Configuration Tab, On Data Source Connections, All the Data Sources will be available.
![Picture148](https://www.s-squaresystems.com/wp-content/uploads/Picture148.png)
-
- Please follow the below steps on Configuration Tab
- Click on the data Source name.
- It will be redirected to Data Source Connection name:
- Please follow the below steps on Configuration Tab
![Picture149](https://www.s-squaresystems.com/wp-content/uploads/Picture149.png)
-
- Click on the Data Source Connection (which lies inside the Data source name)
![Picture150](https://www.s-squaresystems.com/wp-content/uploads/Picture150.png)
-
- Click on the properties of the Data Source Connection, As shown in the screenshot.
![Picture151](https://www.s-squaresystems.com/wp-content/uploads/Picture151.png)
-
- Click on the Edit Signon under Signon Tab.
![Picture152](https://www.s-squaresystems.com/wp-content/uploads/Picture152.png)
-
- Here a window opens, where it consists of UserID and Password. The user ID is here as Schema name:
![Picture153](https://www.s-squaresystems.com/wp-content/uploads/Picture153.png)