3. Report Services Documents in 10. Go to Project access, to give Public/Guest basic access to the project. Transaction Services provide customers a way to modify data in a SAP HANA database online via MicroStrategy Transaction Service documents. Avoid Duplicated Datasets. Click OK. The hostname of the Intelligence Server to connect to. Step 2. MicroStrategy Transaction Services, MicroStrategy Visual Insight, MicroStrategy Web Reporter, MicroStrategy Web Analyst, MicroStrategy Web Universal, MicroStrategy Office, MicroStrategy Data Mining Services, MicroStrategy Narrowcast Server, MicroStrategy Health Center, MicroStrategyThis data is positioned and formatted, resulting in a single display of presentation quality. 4. Ca se functions Microstrategy Case functions return specified data in a SQL query based on the evaluation of user-defined conditions. – Warehouse control. instancename is the name of a server instance, where required. To fully leverage Teradata for analytical SQL requests, the Teradata DSN configuration should be modified from its default values as follows: · Maximum Response Buffer Size - should be increased to an acceptable value. 2. This will prevent table locks from occurring unintentionally during report execution since all the transactions are committed after they are executed without additional commit commands. Step 3: Right-Click in between the single quotes and select Add New Prompt. @Technical Talks Ka Pitara ( TTKP ) MicroStrategy | Business Intelligence | Tableau | Power BI | Datawarehouse#TTKP #MTKP #mstr #Microstrategy #latestvideos. The secret key set on the Library server and Modeling service are the same. Create additional visualizations to display the data in multiple ways. Check the option "Refresh the current document" for the submit button, as shown below: 3. Description: This video is for developers who woul. To view the selector properties for a object selector, see Properties and Formatting Dialog Box: Selector. In fact administration most as often as possible offered due intelligence. 4 million under a previously announced sales agreement with Cowen and Co. Change Journaling is enabled by default since MicroStrategy version 10. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. token" under the MicroStrategy Web Services root deployment directory. Steps to Create: 1. User can either click “Test” to verify the connectivity or just go ahead and click “Finish” to complete the DSN creation. txt file>. 11. Right-click the Grid/Graph, transaction table, or any of the text fields in the panel stack, then select Configure Transaction. There's a reason we're at the top of the list. visible=<Value>. enable to True and provide the hostname of at least 3 Telemetry Server nodes. Return to the Change Journal Manager. In a Transaction Services document, the Action Selector Button behaves differently when logging in via the Guest user who has the necessary “Execute Transaction” privilege. Continue to the steps provided in To select a configuration task. MicroStrategy Transaction Services lets you embed write-back functionality into documents and dashboards for the purposes of decision-making or initiating a transaction. When working with Technical Support, there are multiple logs that may be requested when experiencing problems: The exported PDF file (if available)Below are instructions to achieve this in a Report Services Document. txt. Zendesk. To ensure your enterprise data is secure, Library supports the ability to leverage SSL encryption. 5. 0 workflow with Okta can be seen here. To disable MicroStrategy Messaging Services and configure the Intelligence Server to write directly to the DSSErrors. To select a date from a Calendar control, click the date. 1: Tivoli. CME Overtakes Binance for. com using Transaction Report to configure MicroStrategy transaction document which could update records in Salesforce with XQuery. 3 is able to control the transaction submit order on the Panel Stack level but not on the Panel level. 2. Enter the credentials for the Administrator account on the local Intelligence Server, and then enter the DSN and. 3. txt file. Select the "Configuration" dropdown and choose "CastorServer instance" or "Machine Default". A workaround is available in the current document. b. To select a date from a Calendar control, click the date. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. From the first drop-down list, select Series Values. Choose the transaction report (Transac_Report1) that you want to configure with the dashboard. Notice it runs successfully. To ensure the security of data transfer among the MicroStrategy Services (Messaging services, Intelligence server, Platform Analytics, New Export Engine, and Registration service), we strongly suggest you follow the instructions in this article and enable the security functions. MicroStrategy Intelligence Server 9. Click on "Configure Transaction". Meet the Activity Conditions and add more dynamism to my dashboards while supplying an extras layer from security to. In the Database connection area, select the new database connection that you created, and click OK. Open Workstation (and connect to your environment) 2. Click Create on any page, point to New Report, and then select Blank Report, which provides a blank template to build your report on. ; On the Freeform Sources tab, select Create Transaction report. The following knowledge base article explains the process to modify the diagnostics logging for MicroStrategy components from the command line in Windows and Unix environments. If the attribute in the dataset returns a large number of elements, the input will provide a search box for fast access to the elements. This article describes best practices to be taken when using a Teradata database in MicroStrategy. In this case, when configuring the transaction in the dashboard, the number of Transaction Inputs equals the number of mapping Fields. In a web server cluster running MicroStrategy Web Services 9. Enable partitioning in OLAP cubes. In the Open drop-down list, type cmd and click OK. 4. To have optimal transaction control, a database system must be ACID compliant, which stands for the following properties: Atomicity, Consistency, Isolation. 1 and Dec. Select the chapter that contains the visualization to filter. This demonstrates a huge increase in use, as just a few months ago, in June, it was reported that there had been $300 million in JPM Coin transactions since it first launched. Click on the drop down for the corresponding 'File Log' and choose the log file to which the SQL Trace needs to be written into. 3) Click on Browsing. Run the report services document in MicroStrategy Web. com using Transaction and XQuery Reportexcept where expressly provided otherwise, microstrategy makes no warranty that: (a) the sites or any content, materials, information, software, products and services offered through the sites will meet your requirements; (b) the sites or any content, materials, information, software, products and services offered through the sites will be. This is expected behavior. 2 Jul 2022, 21:22:00 PM:INFO: Schedule to run mstrfixprot again with user mstr. Leave the rest by default and save it. 2: Type "Attribute@ID" in the text box. Enable the option "Flag cells with modifed data" as shown in the screenshot below: Enable the option "Show by default" in the list controler settings for the Metrik "Units_Requested": The third-party product(s) discussed in this article is manufactured by vendors independent of MicroStrategy. 2. Menu. 3. Option 3: Third option to prevent table locks with MySQL database is to use AUTOCOMMIT on the database level. 0. If users have evaluated and deem it is necessary to disable this feature for a specific transaction report, the admin can go to the VLDB Properties at the transaction report, enable "Show Advanced Settings" and find "Parameterized Query Option" and choose the first option. If a name is not specified, the command uses the default instance name. When users add an attribute with large number of elements into the Filter Pane of Dossier/VI Dashboard and set the selector type to Checkbox, a search box will also be displayed so users can search the elements, which is very convenient. If you are configuring MicroStrategy on: Windows, go to Start > Programs > MicroStrategy Tools > Configuration Wizard. Next, navigate to the Theme tab. Upon performing an Audit Report in the MIcroStrategy License Manager 9. xml file under C:Program filesMicroStrategyWeb Services. There's a reason we're at the top of the list. 1 HF1" STEPS TO REPRODUCE: Follow these steps in a MicroStrategy Tutorial Project:KB442534: In MicroStrategy Web, a Transaction Services text box inside a Document shows the value ‘(NULL)’ Description. How to create an Information Window that can be triggered with a neutral button in Flash mode in MicroStrategy Web 9. 6: Link Items are objects that link two or more other objects. Go to Tools > Options > Enable "Show 'Contains' and 'Contained by ' tabs" as shown below: Click OK > Go to "Contains" tab and select Logical Table for "Contains any object of this. In MicroStrategy Web 10. Distribution Services:MicroStrategy is an enterprise BI application software. 0, you need to manually enable extend fetch in Database Instance. A document designer can create a Transaction Services-enabled document to allow analysts to approve requests, track business activity, and execute business decisions by editing their business data in the document and sending those interactions back to the data sources. To enable or disable Smart Totals in MicroStrategy Developer, follow the steps below: Open the compound metric in the metric editor. You will learn how to add and manipulate data, charts, graphs, images, and other elements to design interactive and informative documents. This is where the transaction report is associated with the document. In reality, an . Enable the option "Input is required" in transaction configuration, and submit data. ini configuration file and add the following line: EnableSimulatedTransactions = 1; This will manually override the default driver setting. SAMLAppender. Open the document in Presentation Mode. Find the dataset you want to edit access. Execute transaction. About Us. Even though transaction services in MicroStrategy would work, there is always a risk of making data dirty because of connection or concurrency related errors. Color thresholds enable users to gain insight into a specific metric at a glance. The Grid Settings section allows you to select the Fit to page option, which fits the grid's width onto one PDF page width, or you can select the Allow horizontal pagination option, which breaks a wide grid onto numerous pages. . x and Google BigQuery Whitepaper; Product Documentation: Connect to Google BigQuery from Web or Desktop Two separate MicroStrategy AWS environments with the same system resources were created: one with only basic statistics enabled, and one with advanced statistics enabled. If you opened the Quick Thresholds Editor, select the Advanced Thresholds Editor link to open the Advanced Thresholds Editor. 3. You are returned to the Database Instances Editor. 9 and with MicroStrategy 2019 updates, the MicroStrategy Dossier makes forming visuals and stories a collaborative experience. SAMLAppender. 6, a new micro-service called MicroStrategy PDF Exporter (also known as New Export Engine or NEE) has been added to support exporting from Visual Insight / Dossier to PDF format. Then fill in with the necessary connection parameters. Updating Data by Using a Transaction Services-Enabled Document. blogspot. From the Data menu, select Grid Data Options. Common Privileges. 4, however, the text appears in one line when the Report Services Document is exported to PDF. Uncheck "Enable Change Journal" and check "Apply to all projects" Click OK again. If a user who does not have. The reality is quite different in that the inherent value of MicroStrategy is based on the value of the company's business intelligence software, and the value of the Bitcoin on its balance sheet. Do you see the true potential of Transaction Aids, one of MicroStrategy's flagship features? Locate out what it is, what they can do with it, press. ; Click OK. September 18, 2018. 6. The most common examples where transaction services are used are some of the following: – Stock Management. Click View Certificate. Select 'Yes or 'No' from the drop down list. The hostname of the Intelligence Server to connect to. Open "Item Order Form" in design mode. command is one of the commands from the list below. This not. Version 10. In a Transaction Services document, the Action Selector Button behaves differently when logging in via the Guest user who has the necessary “Execute Transaction” privilege. 11 will support prompts for end users. 4, presentation. To enable dataset transactions, select the Enable local transaction check box. Related articles from the Community: Knowledge Base: KB440975: How to configure MicroStrategy Library to communicate through SSL. Select the 'Advanced' tab, as shown below: Change the setting for 'Attribute element browsing' (circled in red above) to the limit that is desired for the project. Right-click on any text box and select the ‘configure transaction’ option. If the User is logging in via typing Guest, the button appears correctly and can be used to execute the transaction. Menu. Notice it runs successfully. The privileges are grouped by privilege type: Web Reporter privileges. OK. Navigate to "Properties" and swtitch to the "Grid" tab. In most scenarios, this trace will be requested to be logged on the CastorServer instance level. MicroStrategy Tutorial > Shared Reports > MicroStrategy Platform Capabilities > MicroStrategy Transaction Services > Item Order Form, in design mode. The following is a list of the official license types available in Client products: Client - Web: A zero-footprint web interface that allows users to access analytics on multiple browsers and design, interact with, and consume information via pixel-perfect reports, documents, or dossiers. default. Selectors allow a user, in MicroStrategy Web, to. The User Login system prompt can be used as input in the transaction report. Why MicroStrategy Why MicroStrategy; Customer Stories; Platformwhile MicroStrategy maintains the supporting cloud-based infrastructure. Visit the data visualization and data dashboard galleries for inspiration. 1. Log into a MicroStrategy Web project as a user with administrative privileges. 1. 2. Right click on the grid and click Configure Transaction, change the Transaction Input of Comment to editable and control style to Text Area as shown below: 10. x, if the user alters data load by, for example, adding new projects to be monitored, or modifying data load name, the data load is disabled. " on the menu. The report is located under MicroStrategy TutorialPublic ObjectsReportsMicroStrategy Platform CapabilitiesMicroStrategy Transaction ServicesDatasets. With these statistic logs, administrators can see how much time is spent on each. PDS file you just modified in Step 1: Update DATABASE. Even run a store procedure that launches a job (both from the transaction and the VLDBs. In MicroStrategy Web 10. In a Transaction Services document, users can configure a textbox to use one attribute form as the Display Form and a different one as the Writeback Form. x, while ODBC call 2. For example, solutions for a facilities team at a large manufacturing company might include sensors to measure the temperature of key equipment to optimize maintenance schedules. KB484745: How to enable bulk load to improve bulk inserting performance against Azure Synapse AnalyticsOpen the dossier you want to modify. Apply the upgrade to the database instance. (A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. From the pane on the left, select Security. In MicroStrategy Web 9. MicroStrategy Transaction Services, MicroStrategy Visual Insight, MicroStrategy Web Reporter, MicroStrategy Web Analyst, MicroStrategy Office,. It also explains the setting in the Web Admin page Allow automatic login if session is lost. These can be VERY handy for automating your data into a call to action for your users! We will setup a threshold alert on a metric value and set it on a schedule for 5 minutes. STEPS TO REPRODUCE: Create a transaction services document with several metrics. Follow the steps below in order to create a new report template that can be used when creating new reports in MicroStrategy Developer or Web: 1) In MicroStrategy Developer, log onto the desired project. appender. x to change password for login of Salesforce. Click on the button to reveal the panel stack with transaction items. In Web, log on to the MicroStrategy Tutorial project and run the following document: Public ObjectsReportsMicroStrategy Platform CapabilitiesMicroStrategy Transaction ServicesOpportunity Management document. iserver. During card design, select from different widgets, matrix views, and card header formats to best display data. How to identify the MicroStrategy user that updated record using Transaction Services? When running a transaction services report it could be desired to store which user is performing said activity. The Java XML API log will record all the XML communications between Intelligence Server and Web. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform In MicroStrategy Web, edit or execute a report. Right click on the grid and click Configure Transaction, change the Transaction Input of Comment to editable and control style to Text Area as shown below: 10. • This procedure assumes that the Transaction Services report that you want to link to the Grid/Graph, text fields, or transaction table has already been created. Once you add visualizations to your dossier, you can format each visualization individually. 4 HF5 and 10. In order to enable Azure multi-factor authentication (MFA) through Azure Conditional Access policies, the following additional steps must be performed for MFA to be triggered when accessing the environment through MicroStrategy Mobile. The Export Engine (EE) runs as an independent micro-service to export dossiers to PDF that comes with its own logging and troubleshooting steps. pdf. 2) Click on the Tools menu and select Developer Preferences. The impact is from the MicroStrategy Web 10. 3. Today, MicroStrategy released Geospatial Services, a new set of mapping capabilities powered by Mapbox and available across MicroStrategy’s 10. 3. In the layout tab, click "Allow multiple selections". Grant all privileges that will enable the guest user to have, with the minimum of 'Web User' under the Web Reporter privilege group: NOTE: The screenshot. As of July 31, 2023, the company held 152,800 bitcoins acquired for a total cost of $4. To cluster the Telemetry Server, set the property TelemetryServer. MicroStrategy Transaction Services is a very powerful tool that provides write-back capabilities from Report Services Documents both through Mobile BI Apps and Web-based DHTML documents. To access the setting, in MicroStrategy Developer right-click on the project and select Project Configuration…Then, In the Project Configuration dialog box, choose Project Definition >. Search for and select SAP HANA in the Data Source dialog. • This dossier users a feature that is not compatible with MicroStrategy Web. Please refer to below example to see the behavior. 1 app on an iOS device. ; In the Source area, select the database instance for the data source to be updated using Transaction Services. 4: Each time a folder is deleted, the changes are recorded in the. Our Team; Careers: work more adenine business intelligence consultant8. – Surveys. 4-5: Records when saving one or more objects. The " Re - run " ( Re -execute) button. Follow the steps below: Right-click on the project and select 'Project Configuration. This video describes the steps taken to enable seamless login between MicroStrategy Web and Library. Client - Reporter: A consumer license that allows ends. Step 4. This functionality, depending on which field it is, will give us different possibilities of field behavior. Did we mention information windows?Launch the MicroStrategy Workstation application. Link a MicroStrategy user to a windows user in MicroStrategy Developer, by going to Authentication - Metadata, as shown below: Go to the MicroStrategy Web Services machine and locate the ProjectSource. 1669 views · September 04, 2020. This article describes best practices to be taken when using a Teradata database in MicroStrategy. The dossier transaction configuration automatically generates the basic INSERT, UPDATE, and DELETE SQL statements with tokens according to the mapping view configuration. Right-click on the project source and select Compliance Check. Click on " + " next to Datasets and select your environment and project. Create a derived metric(DM) so that it is calculated from current metrics. . Open the Document in Design Mode. Source: MicroRooster. 0:00 / 9:26 Using MicroStrategy Transaction Services MicroStrategy Community 4. This feature is especially useful when users need to call a transaction report to execute a stored procedure. 2. 2) Choose the End Date and set a qualification as End Date less than Start Date as seen below: 3) Double click on the threshold and check Replace Data, type a. • ESRI and Geospatial keys: This section allows Support Liaisons to retrieve an ESRI or GeospatialInstall the Telemetry Server. In Workstation, Privileges and Permissions are used to enable or disable certain actions from being taken by the current User(s). Apr 12, 2019. These transactions can include one-click approvals and denials, notes for tracking and directing business activity, and write-back to data sources in real time. You may have noticed that when you right-click on an object that has a transaction configured, the “Transaction Conditions” option appears. 1. You can allow users to view and edit their business data in a Transaction Services-enabled document displayed on an iPhone, iPad, or Android device, using the options in the. Table-creation-modifying VLDB properties (most settings under the Tables menu) are ignored when 'True Temporary Tables' are chosen. x/10. 4 columns: transaction, project, object, and modification made. Under the Security Tab, ensure Encryption. WORKAROUND: If transactions cannot be enabled on the database side, re-create the report in a different way such that it does not. While dossiers are a great proposition when self-service, collaboration, responsive design, and fast content creation are key requirements; documents are still your best. 1. To make the database instance available for Freeform SQL reports, right-click a project and select Project Configuration. Load Chapters on Demand. Data alerts work as a function of thresholding. 1, after insert, update, delete operations, but the data is not updated. Another common scenario is when users need to review the content and accept it without making any changes to it. Note: The SOAP Header section needs to be empty. Select the Order metric and click the. Instead, users may observe that the tooltip displays, for example, "Metric: Revenue" when hovering over the object in the Report Objects or Datasets pane, or. enable the installation of Product downloads. MicroStrategy Office privileges. Beginning in MicroStrategy 10. Choose the Light Theme from the drop down menu and click the. 53 billion or $29,672 per bitcoin. zip and use 7Zip, or similar tools, to unzip it. 4. Menu. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. x and 11. Go to Project access – General. About Us. 9 release, MicroStrategy introduced the Library application, which allows users to access their MicroStrategy analytics from multiple devices as well as allowing users to collaborate across their organization. For steps to create a Transaction Services report, see the Advanced Reporting Guide. About Uses. mstr suffix. The name of the MicroStrategy user that made the change. To configure the MicroStrategy Mobile Library app, visit the MicroStrategy. When working with Technical Support, there are multiple logs that may be requested when experiencing problems: The exported PDF file (if available) 1. The following options are available: Ø Transaction Mapping options. The team reviewed free-form layout and the process for creating more personalized data experiences—from the ideation phase to final deployment. Access all critical KPIs at a glance, from daily revenue and product trends to employee. 11, users can consume grid. By: Julie Munro. The status should be "Stopped". To create the Enterprise Manager project, run Configuration Wizard on the MicroStrategy Intelligence Server machine that uses the Metadata where the project should be created, and select the Create Enterprise Manager project option. For more details regarding basic versus advanced statistics, see Enable Telemetry Logging for Intelligence Server. Select "Switch" from the Control Style drop-down; Click the Properties icon . In a Transaction Services document, users can configure a textbox to use one attribute form as the Display Form and a different one as the Writeback Form. In the Based On list, select the object to base the threshold on. 1 and above, any changes to the Fill color of an Action Selector Button are not reflected when running the document in Express Mode. Enter text in a Transaction Services RSD and save document. Now open a MicroStrategy Office application, such as Excel, and click on the MicroStrategy button. Part of the subsequent increase may be due to an expansion this year to enable transactions in euros as well as in US dollars. 2. Certified Gateways MicroStrategy 2021 Update 4 Amazon Redshift When a transaction is requested, the inputs are included in the SQL or XQuery statement to update the values in the data source. Re - run against the warehouse. This filter allows administrators to add security at the column level and control which attributes and metrics users are able to see. About Us. instancename is the name of a server instance, where required. On the Freeform Sources tab, in the Source area, select a database instance for the data source to access using Freeform SQL. ENABLING SSL VIA ODBC DATA SOURCE ADMINISTRATOR: If you wish to modify an existing Microsoft SQL Server connection, adjust settings shown in step 3. CAUSE: One possible cause for this issue is Transaction Services is not installed on the Intelligence Server machine. The condition is based on either an attribute or metric. This guide covers the features, benefits, and limitations of OLAP Services, as well as the steps to create, manage, and. In Windows Environments, Run ODBC Data Source Administrator, clicking Add under System DSN. 8. In MicroStrategy 2021 Update 6, dossier users with the proper privileges can modify data and submit data changes to the database. a. Run the RSD in Presentation Mode and note that. It is a Business Intelligence (BI) tool. 4. filename to an absolute path for forward slash. 4) Mark the Display hidden objects checkbox and click on OK:Knowledge Base: KB316480: How to upgrade the Google Big Query Driver in MicroStrategy Secure Enterprise 10. If projects are distributed asymmetrically across the cluster, when you assign an event-triggered schedule to a project, make sure you trigger the event on all nodes on which that project is loaded. Save this insert Transaction. Upgrade to this release to take advantage of this fix. This report must contain the input object for each value that you want to allow users to change. To check the existing logging destinations, run the command: mstrctl -s IntelligenceServer gsc To create the new logging destination use the command: Transaction Types: 1-3: Change Journaling will record any time the user turns it on, off or want to delete the history of the journal. Select the DSN created in the previous steps and click Save . /setup. x and Google BigQuery Whitepaper; Product Documentation: Connect to Google BigQuery from Web or DesktopTwo separate MicroStrategy AWS environments with the same system resources were created: one with only basic statistics enabled, and one with advanced statistics enabled. Click on the calendar selector to expand the. 11 platform. The state of whether MicroStrategy Transaction Services is displayed in the MicroStrategy Installation Wizard: TransactionServices. Follow steps below to find out all the Freeform SQL Reports in a project in MicroStrategy Developer: Log in to the project from Developer and click the search button. If the desired action is to disable for all, but "Enable Change Journaling" is unchecked, perform the following actions in this order: Check "Enable Change Journal" and "Apply to all projects". In. You can connect MicroStrategy reporting tool with any data, including big data, flat files, social media data, and. In this case, Library was deployed through the installer and both the Library and Web servers are on the same. 8, 10. MicroStrategy Transaction Services, MicroStrategy Visual Insight, MicroStrategy Web Reporter, MicroStrategy Web Analyst, MicroStrategy Web Universal, MicroStrategy Office, MicroStrategy Data Mining Services, MicroStrategy Narrowcast Server, MicroStrategy Health Center, MicroStrategyLearn how to use MicroStrategy OLAP Services to enhance your data analysis and reporting capabilities. command is one of the commands from the list below. 2. Transaction Services: Transaction services are third party services gave by an professional service firm, or a venture bank when a business exchange happens. Drag the required objects to the Panel (there should be at least one panel) as shown below. id). visible=<Value>. PDS. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformOpen the odbc. Set ID form as write back form and DESC form as displayed form. Enable the option "Flag cells with modifed data" as shown in the screenshot below: Enable the option "Show by default" in the list controler settings for the Metrik "Units_Requested":The third-party product(s) discussed in this article is manufactured by vendors independent of MicroStrategy. The data loading process gathers and prepares data for analysis and reporting in the Enterprise Manager project. Take the following steps in MicroStrategy Tutorial to see this issue in a Transaction Services document: Navigate to Shared Reports > MicroStrategy Platform Capabilities > MicroStrategy Transaction Services. Case 1: {Category@DESC} Input {Category@DESC} in text box as show below: Configure transactions on this text box. Create Data Load and check EM_Configuration table. Detailed steps to create a Transaction Services-enabled document are below. 12K subscribers 14K views 5 years ago Building Reports and Documents. Drag an attribute from the Datasets panel to the Rows area of the Editor panel to add attributes to the rows. Prerequisites • You must have Transaction Services. 4, line breaks appear when viewing a Report Services Document in MicroStrategy Web 10. To create a Freeform SQL report. Click OK. Open the document on the web in design mode. It collects real-time data (also known as telemetry) which is generated by different components of the MicroStrategy platform like the Intelligence Server. You can use a Transaction Services-enabled document to: Approve requests; Track business activity; Execute business decisions; You can perform these tasks directly from the document in Presentation Mode in Web, and when viewed on an iPhone, iPad, or Android device with MicroStrategy Mobile.