Get the report list from SSRS ( Sql Server Reporting Server)
SELECT
SUBSTRING([PATH],1,LEN([PATH])-CHARINDEX('/',REVERSE([PATH]))) AS REPORT_FOLDER,
NAME
FROM CATALOG
WHERE TYPE = 2
ORDER BY [PATH],[NAME]
Tutorial for Denodo,OBIEE 11g, SQL, PLSQL, Datawarehousing beginners.
Subscribe to:
Posts (Atom)
Featured post
Snowflake - Creating warehouse in Snowflake
Creating warehouse Login to Snowflake and click on warehouse and click on Create fill the necessary details and click Finish We can also c...
-
We can use call NQS_GetAllCacheEntries(); command to get all the cache entries available in server. steps to use: 1. Login to analytics as... -
We can use call NQS_GetAllCacheEntries(); command to get all the cache entries available in server. steps to use: 1. Login to analyt...
-
Variable Description USER Holds the value the user enters as his or her logon name. Thi...