![]() If the report is not in Design view, switch the report to Design view.įrom the Data menu, select Freeform SQL Definition. In MicroStrategy Developer, right-click a Freeform SQL report and select Edit. To access the Freeform SQL Editor to edit a Freeform SQL report For steps to create a Transaction Services report, see the Advanced Reporting This option is not available for Intelligent Cubes. You can use XQuery statements to retrieve data from a web service.Ĭreate Transaction report: To create a Transaction Services report, which can be used to update data in your various data sources. While database instances commonly point to a relational database, you can also create Freeform SQL reports from database instances connecting to text files or Excel files.Ĭreate Freeform SQL report: To create a report using custom SQL statements.Ĭreate Freeform XQuery report: To create a report using custom XQuery statements. Under Show templates for the following objects, select the Report check box. The Object Template - General pane opens. SQL Editor type an SQL statement into the text box and click on Run (or F5) build SQL with minimal amounts of typing. In the Developer Preferences dialog box that opens, select the Object Template category. In MicroStrategy Developer, from the Tools menu, select Developer Preferences. If the New Grid dialog box does not open when you select Report, you must modify a MicroStrategy Developer setting. ![]() On the Freeform Sources tab, in the Source area, select a database instance for the data source to access using Freeform SQL. In MicroStrategy Developer, from the File menu, select New, and then choose Report. To access the Freeform SQL Editor for a new report If there is no database instance defined in the metadata, the Freeform SQL Editor cannot be loaded and a message is displayed.ĭatabase instances are available for selection only if they have been set up correctly for use with Freeform SQL (select Project Configuration, then Database instances, and select the check box for the database instance from the Database Instance list). You must have the Define Freeform SQL report and Create schema objects privileges to access and use the Freeform SQL Editor. You can access the Freeform SQL Editor in one of the following ways, depending on whether you are creating a new Freeform SQL report or editing an existing Freeform SQL report. The Freeform SQL Editor is where you create and define your SQL statement to generate a Freeform SQL report.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |