It is possible to execute a report using URL API in Strategy Web and Web Universal 9x
URL Parameters for report execution:
/MicroStrategy/servlet/mstrWeb?
Server=SERVERNAME
&Project=Strategy+Tutorial
&Port=0
&uid=Administrator
&pwd=
&src=mstrWeb.4001
&evt=4001
&reportID=EB3CD5D14F4C8C77782AC0882C986B8D
&reportViewMode=1
intersect (select ...))
ANSI 92DB2 UDBOracleTeradataSQL ServerRedBrickInformixTandemIntersectYYYYYYNNIntersect ALLYYNYNYNNExceptYYY (minus)YYYNNExcept ALLYYNYNYNNUnionYYYYYYYNUnion ALLYYYYYYYNArgumentDescriptionevt4001 - runReport Executes the report specified by either the reportID or reportName argument.reportIDSpecifies the ID of the report to execute.reportNameCan be used instead of reportID.reportViewModeGrid (1) or Graph (2) Mode.msgIDIf present, the report is fetched from memory and the reportID argument is ignored. | intersect (select ...))
ANSI 92DB2 UDBOracleTeradataSQL ServerRedBrickInformixTandemIntersectYYYYYYNNIntersect ALLYYNYNYNNExceptYYY (minus)YYYNNExcept ALLYYNYNYNNUnionYYYYYYYNUnion ALLYYYYYYYNArgumentDescriptionevt4001 - runReport Executes the report specified by either the reportID or reportName argument.reportIDSpecifies the ID of the report to execute.reportNameCan be used instead of reportID.reportViewModeGrid (1) or Graph (2) Mode.msgIDIf present, the report is fetched from memory and the reportID argument is ignored. |
intersect (select ...))
ANSI 92DB2 UDBOracleTeradataSQL ServerRedBrickInformixTandemIntersectYYYYYYNNIntersect ALLYYNYNYNNExceptYYY (minus)YYYNNExcept ALLYYNYNYNNUnionYYYYYYYNUnion ALLYYYYYYYNArgumentDescriptionevt4001 - runReport Executes the report specified by either the reportID or reportName argument.reportIDSpecifies the ID of the report to execute.reportNameCan be used instead of reportID.reportViewModeGrid (1) or Graph (2) Mode.msgIDIf present, the report is fetched from memory and the reportID argument is ignored. | intersect (select ...))
ANSI 92DB2 UDBOracleTeradataSQL ServerRedBrickInformixTandemIntersectYYYYYYNNIntersect ALLYYNYNYNNExceptYYY (minus)YYYNNExcept ALLYYNYNYNNUnionYYYYYYYNUnion ALLYYYYYYYNArgumentDescriptionevt4001 - runReport Executes the report specified by either the reportID or reportName argument.reportIDSpecifies the ID of the report to execute.reportNameCan be used instead of reportID.reportViewModeGrid (1) or Graph (2) Mode.msgIDIf present, the report is fetched from memory and the reportID argument is ignored. |
intersect (select ...))
ANSI 92DB2 UDBOracleTeradataSQL ServerRedBrickInformixTandemIntersectYYYYYYNNIntersect ALLYYNYNYNNExceptYYY (minus)YYYNNExcept ALLYYNYNYNNUnionYYYYYYYNUnion ALLYYYYYYYNArgumentDescriptionevt4001 - runReport Executes the report specified by either the reportID or reportName argument.reportIDSpecifies the ID of the report to execute.reportNameCan be used instead of reportID.reportViewModeGrid (1) or Graph (2) Mode.msgIDIf present, the report is fetched from memory and the reportID argument is ignored. | intersect (select ...))
ANSI 92DB2 UDBOracleTeradataSQL ServerRedBrickInformixTandemIntersectYYYYYYNNIntersect ALLYYNYNYNNExceptYYY (minus)YYYNNExcept ALLYYNYNYNNUnionYYYYYYYNUnion ALLYYYYYYYNArgumentDescriptionevt4001 - runReport Executes the report specified by either the reportID or reportName argument.reportIDSpecifies the ID of the report to execute.reportNameCan be used instead of reportID.reportViewModeGrid (1) or Graph (2) Mode.msgIDIf present, the report is fetched from memory and the reportID argument is ignored. |
intersect (select ...))
ANSI 92DB2 UDBOracleTeradataSQL ServerRedBrickInformixTandemIntersectYYYYYYNNIntersect ALLYYNYNYNNExceptYYY (minus)YYYNNExcept ALLYYNYNYNNUnionYYYYYYYNUnion ALLYYYYYYYNArgumentDescriptionevt4001 - runReport Executes the report specified by either the reportID or reportName argument.reportIDSpecifies the ID of the report to execute.reportNameCan be used instead of reportID.reportViewModeGrid (1) or Graph (2) Mode.msgIDIf present, the report is fetched from memory and the reportID argument is ignored. | intersect (select ...))
ANSI 92DB2 UDBOracleTeradataSQL ServerRedBrickInformixTandemIntersectYYYYYYNNIntersect ALLYYNYNYNNExceptYYY (minus)YYYNNExcept ALLYYNYNYNNUnionYYYYYYYNUnion ALLYYYYYYYNArgumentDescriptionevt4001 - runReport Executes the report specified by either the reportID or reportName argument.reportIDSpecifies the ID of the report to execute.reportNameCan be used instead of reportID.reportViewModeGrid (1) or Graph (2) Mode.msgIDIf present, the report is fetched from memory and the reportID argument is ignored. |
intersect (select ...))
ANSI 92DB2 UDBOracleTeradataSQL ServerRedBrickInformixTandemIntersectYYYYYYNNIntersect ALLYYNYNYNNExceptYYY (minus)YYYNNExcept ALLYYNYNYNNUnionYYYYYYYNUnion ALLYYYYYYYNArgumentDescriptionevt4001 - runReport Executes the report specified by either the reportID or reportName argument.reportIDSpecifies the ID of the report to execute.reportNameCan be used instead of reportID.reportViewModeGrid (1) or Graph (2) Mode.msgIDIf present, the report is fetched from memory and the reportID argument is ignored. | intersect (select ...))
ANSI 92DB2 UDBOracleTeradataSQL ServerRedBrickInformixTandemIntersectYYYYYYNNIntersect ALLYYNYNYNNExceptYYY (minus)YYYNNExcept ALLYYNYNYNNUnionYYYYYYYNUnion ALLYYYYYYYNArgumentDescriptionevt4001 - runReport Executes the report specified by either the reportID or reportName argument.reportIDSpecifies the ID of the report to execute.reportNameCan be used instead of reportID.reportViewModeGrid (1) or Graph (2) Mode.msgIDIf present, the report is fetched from memory and the reportID argument is ignored. |
intersect (select ...))
ANSI 92DB2 UDBOracleTeradataSQL ServerRedBrickInformixTandemIntersectYYYYYYNNIntersect ALLYYNYNYNNExceptYYY (minus)YYYNNExcept ALLYYNYNYNNUnionYYYYYYYNUnion ALLYYYYYYYNArgumentDescriptionevt4001 - runReport Executes the report specified by either the reportID or reportName argument.reportIDSpecifies the ID of the report to execute.reportNameCan be used instead of reportID.reportViewModeGrid (1) or Graph (2) Mode.msgIDIf present, the report is fetched from memory and the reportID argument is ignored. | intersect (select ...))
ANSI 92DB2 UDBOracleTeradataSQL ServerRedBrickInformixTandemIntersectYYYYYYNNIntersect ALLYYNYNYNNExceptYYY (minus)YYYNNExcept ALLYYNYNYNNUnionYYYYYYYNUnion ALLYYYYYYYNArgumentDescriptionevt4001 - runReport Executes the report specified by either the reportID or reportName argument.reportIDSpecifies the ID of the report to execute.reportNameCan be used instead of reportID.reportViewModeGrid (1) or Graph (2) Mode.msgIDIf present, the report is fetched from memory and the reportID argument is ignored. |
NOTE: The msgID parameter, if available, can be obtained after executing the report and clicking on the File menu of the report and selecting Report Details.
Sample URL to execute in Strategy Web:
http://localhost/MicroStrategy/asp/Main.aspx?server=SERVERNAME&Project=Strategy+Tutorial&evt=4001&src=Main.aspx.4001&reportID=EB3CD5D14F4C8C77782AC0882C986B8D&reportViewMode=1&uid=Administrator&pwd=
Sample URL to execute in Strategy Web Universal:
http://localhost:8080/mstrURL/servlet/mstrWeb?server=SERVERNAME&Project=Strategy+Tutorial&evt=4001&src=mstrWeb.4001&reportID=EB3CD5D14F4C8C77782AC0882C986B8D&reportViewMode=1&uid=Administrator&pwd=
WARNING:This customization is provided as a convenience to Strategy users and is only directly applicable to the version stated. While this code may apply to other releases directly, Strategy Technical Support makes no guarantees that the code provided will apply to any future or previous builds. In the event of a code change in future builds, Strategy Technical Support makes no guarantee that an updated version of this particular customization will be provided. In the event of a code change in future builds, Strategy may not be able to provide additional code on this matter even though this customization is provided at this time for this specific build. For enhancements to this customization or to incorporate similar functionality into other versions, contact your Account Executive to inquire about Strategy Consulting assistance.
