'Microstrategy using SQL Server stored procedures
I am trying to see what stored procedures in my database (using SSRS) are being used in the reports from MicroStrategy.
Is there a way to extract a list of reports from MicroStrategy?
Additionally, can I extract a list of which reports in MicroStrategy is using a stored procedure?
Solution 1:[1]
In MicroStrategy, the list of reports can be extracted from Project Documentation, Enterprise Manager or using normal Search in Developer tool.
In case you are specifically trying to find MSTR reports that use a stored procedure, then you only need to look for Freeform SQL reports (or Logical Views), since they are one of few objects where MicroStrategy allows to specify stored procedures or custom SQL statements.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | badprogrammer |