The MicroStrategy Tutorial project includes examples of Transaction Services. The derived metric value calculated from transaction is not updated to dataset via local transaction services in offline mode for MicroStrategy Mobile 10. Grid columns with zero width still appear on a Transaction Services Document in MicroStrategy Web 9. 10, continued. MicroStrategy Transaction Services. In the Operator list, select a comparison operator (Greater Than, Less Than. Transaction Service with Toggle or Switch control style is not working for computed calculations on iPad in MicroStrategy Mobile 9. After configuring a grid to use transaction SQL, an error is. For instructions, see the MicroStrategy Web Help or the MicroStrategy Mobile Analysis Help. The following steps will clear the text displayed in the popup titlebar:Analytics Processing) rather than OLTP (Online Transaction Processing). – Sales register. PostgreSQL can be used as a repository for the metadata, history list, Platform Analytics, Collaboration server. 29KB. By default, the Zookeeper transaction log switch will happen after “snapCount(100000)” transaction happens. The Snowflake ODBC driver version 2. Using either SQL for databases, or XQuery for Web Services applications, transactions trigger new business processes, re-allocate resources, and accelerate business activity. You'll find user-generated examples showcasing a variety of use cases such as financial or retail sales analysis. Desktop Designer. 6: Link Items are objects that link two or more other objects. 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. x / 10. Note: The user also needs to have View access in the transaction report’s ACL. Once the administrator sets it up, the end user has to just log in with their Okta or Azure AD email credentials to start using MicroStrategy with Snowflake. 0 MicroStrategy Transaction Services and Express Mode documents Patch. To do so, you must link a Transaction Services report to a grid or to text fields in a panel stack. 5 when the Submit button is configured with mor…4. MicroStrategy makes no warranties or commitments concerning the availability of future products or versions that may be planned or. 2. Related Topics. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformDetails: MicroStrategy supports both Azure AD and Okta Authentication with Snowflake. x. 4. Description: This video is for developers who woul. Narrowcast Server, MicroStrategy Object Manager, MicroStrategy Office, MicroStrategy OLAP Services, MicroStrategy Parallel Relational In-Memory Engine (MicroStrategy PRIME), MicroStrategy R Integration, MicroStrategy Report Services, MicroStrategy SDK, MicroStrategy System Manager, MicroStrategy Transaction Services,. See demos of MicroStrategy implementations such as social media sentiment analysis and big data integrations for self-service analytics. 1 and above, any changes to the Fill color of an Action Selector Button are not reflected when running the document in Express Mode. Eileen Kolev (EOP) ·. 0 workflow with Okta can be seen here. You create a transaction-enabled document by performing the following high-level steps in MicroStrategy Web: 1 Link a Grid/Graph or the text fields on a panel stack (called a field group) to a Transaction Services-enabled report. Dear MicroStrategy Customer, We’re excited to officially kick off the summer season with the latest release of MicroStrategy — and it’s coming in hot. In MicroStrategy Web 9. To set a column to be optional, configure the transaction in MicroStrategy Web and uncheck the option ‘Input is required’. Example user without Execute transaction privilege. 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. 9 and with MicroStrategy 2019 updates, the MicroStrategy Dossier makes forming visuals and stories a collaborative experience. 4-5: Records when saving one or more objects. There isn't any video. Map the Attribute Forms and Metrics from the dataset to the Transaction Services Report "Insert Item Order". MICROSTRATEGY FREEFORM SQL ESSENTIALS Course Guide. Objective : Micro Strategy professional with almost 7+ years of result-driven experience in Data Modeling, Designing, Architecture Data Warehouses and BI applications in diverse industrial sectors like manufacturing, pharmaceutical, banking, retail and insurance. In the Source area, select the database instance for the data source to be updated using Transaction Services. Upgrade to this release to take advantage of this fix. . The MicroStrategy Connect series allows you to connect and learn with teams across MicroStrategy. 5. 2. ACTION: The issue has been fixed in MicroStrategy Web 10. 1. Run the Monthly Regional Sales Targets Planning document. SYMPTOM: When running a Transaction Services document and clicking submit to execute the transaction against the data warehouse, it is seen that the data is not inserted to the warehouse. Introduction to MicroStrategy engine • SQL generation process 2. You could use the ODBC Test Tool to test the validity of the procedure before creating the Freeform SQL report. Add a metric which is based on the transaction field. 4. 2 hotfix1 and 10. MicroStrategy Architecture , Development & Design of new MSTR Projects and to provide fixes and enhancements to complex MSTR Mobile Applications and Dashboards. x-10. MicroStrategy Transaction Services lets you embed write-back functionality into documents for the purposes of decision-making or initiating a transaction. Easy 1-Click Apply Atria Group Microstrategy Transaction Services Contract ($119,700 - $175,100) job opening hiring now in Dallas, TX 75234. sh -silent -options <path of the options. You can perform these tasks directly from the document in Express Mode in MicroStrategy Web, and when you view the document on a mobile device with MicroStrategy Mobile. It allows users to update data, insert new information or delete existing records from the database. For example, type the command: . x supports INSERT, UPDATE, and DELETE DML. This issue has been classified as a defect by MicroStrategy. Open "Item Order Form" in design mode. x or higher, it can be seen that Transaction Services licenses are enabled on the key as shown below. 이러한 트랜잭션은 원클릭 승인 및 거부, 비즈니스 활동의 추적 및 지시를 위한 참고, 데이터 소스에 대한 실시간 다시. xThe report can be executed in MicroStrategy Web. Presto is NOT ACID compliant. a. Create a transaction document, as is shown below: 7. Create a button that uses panel stack 76 as its information windows. MicroStrategy is not responsible for errors or omissions. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . To view the selector properties for a object selector, see Properties and Formatting Dialog Box: Selector. in trading Thursday. mstrc file from an empty text file #mstrc #mstrcconnectionfile; #Creating a Microcharts widget in. 4, presentation. TYSONS CORNER, Va. Click Load to load the DATABASE. The user privileges that take up a Transaction Services license are denoted by 4 asterisks (****) in the User Editor under User Manager > User Definition > Project Access. Advanced MicroStrategy users take full advantage of Oracle SQL capabilities, like querying data based on table index. Below are the new features exclusive to. Basic optimizations • Multi -SELECT statements • Composing optimized SQL/PRNewswire/ -- MicroStrategy® Incorporated (Nasdaq: MSTR), a leading worldwide provider of business intelligence (BI) software, today announced an array of. This will remain until the user clicks within the text. /PRNewswire/ -- MicroStrategy® Incorporated (Nasdaq: MSTR), a leading worldwide provider of business intelligence (BI) software, today announced the general. Views 1543. Edit the Item Order Form document in Shared Report > MicroStrategy Platform Capabilities > MicroStrategy Transaction Services. Select "Switch" from the Control Style drop-down; Click the Properties icon . x and 11. Common Privileges. MicroStrategy's mobile intelligence platform helps companies and organizations build, deploy, and maintain mobile apps across a range of solutions by embedding intelligence, transactions, and. Specifications subject to change without notice. Consulting, MicroStrategy Customer Services, MicroStrategy Education, MicroStrategy University, MicroStrategy Managed Services, BI QuickStrike, Mobile QuickStrike, Transaction Services QuickStrike Perennial Education Pass, MicroStrategy Web Based Training (WBT), MicroStrategy World, BestNote: The steps provided in this Technical Note assume users already have a Transaction Services Document setup. in database. Dante Klz. 5. Intelligence; BI & Analytics; Hyper; Embedded; What's NewA MicroStrategy Report Services document contains datasets from one or more reports. pdf. 1:36:01. MicroStrategy, MicroStrategy Business Intelligence Platform, MicroStrategy Cloud, MicroStrategy Mobile, Cloud Personal, MicroStrategy Transaction Services, Wisdom, MicroStrategy Wisdom and Emma. Pull down list selectors in Transaction Services documents always display the first element of a search result as the selection made by the user, regardless of which element was selected in MicroStrategy Analytics Enterprise 9. x-10. This feature is especially useful when users need to call a transaction report to execute a stored procedure. MicroStrategy Customer Services, MicroStrategy Education, MicroStrategy University, MicroStrategy Managed Services, MicroStrategy Business Intelligence QuickStrike, BI QuickStrike, Mobile QuickStrike, Transaction Services QuickStrike, Retail Vendor Portal, Perennial Education Pass,This Video shows how you can use MicroStrategy 10 Transaction Services for the implementation of Planning Processes. In this video tutorial, Doug Terbush from our Customer Education team describes the process of building a Transaction Services-enabled document. 6/9 videos | 5H 34M 40S total runtime. Starting in MicroStrategy 2019 Update 3, both ODBC and JDBC drivers are supported. Below is some information on stored procedure execution for some major databases: DB2. 24 :This issue has been classified as a defect by MicroStrategy. Open the document in Presentation Mode. When users run this transaction document through MicroStrategy Mobile 9. SUMMARY. MicroStrategy Announces . TransactionServices. Ø Local Transaction options. Related Topics. Click More in the upper right corner of the visualization and choose Configure. Create a freeform SQL with Select CAT_ID, SUB_CAT_ID, MONTH_ID, SALES, SALES * [?ValuePrompt] 2. SQL for Oracle (PL/SQL) MicroStrategy Mobile Dashboard development. For example, a user configures the Transaction Services Document to refresh the current document as shown below: Apply the upgrade to the database instance. PDS. Execute transaction. 5. Inject, extend, and embed intelligence into custom and third-party applications. A professional Microstrategy Consultant. In MicroStrategy Web 10. In MicroStrategy Web 9. MicroStrategy makes no warranties or commitments concerning the availability of future products or versions that may be planned or under development. When a transaction is requested, the inputs are included in the SQL or XQuery statement to update the values in the data source. 1 and above, any changes to the Fill color of an Action Selector Button are not reflected when running the document in Express Mode. MicroStrategy Transaction Services lets you embed write-back functionality into documents for the purposes of decision-making or initiating a transaction. This topic provides guideline for Transaction Services reports defined with a star rating as the input method. With MicroStrategy transactions services support for PostgreSQL, users can record selections in a PostgreSQL table. 3. Then fill in with the necessary connection parameters. In this video tutorial, Doug Terbush from our Customer Education team describes the process of building a Transaction Services-enabled document. Edit the "Unites Requested" control style and set it to text field. 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. 5. a. Extensive experience with Developing MicroStrategy Transaction Services, Visualization, Mobile dashboards, cubes, MDX reports , MTDI, Multi source Dashboards using HANA,. where is the video? Expand Post. This Knowledge Base article describes a known issue that calendar in Transaction Services set to Spanish reverts to English on MicroStrategy Android Mobile 10. 11. 3. 95K. txt. Another common scenario is when users need to review the content and accept it without making any changes to it. The state of whether MicroStrategy Transaction Services is displayed in the MicroStrategy Installation Wizard: TransactionServices. Please submit "rock star" candidates. This technical note documents an issue with MicroStrategy Mobile app Android 9. Viewing and interacting with. Example: Use live connect if you're trying to look at certain transaction details, such as transactionsWhen building a Transaction Service document in MicroStrategy Web 9. Hitting ´shift + tab´ keys on the keyboard does not take the cursor backwards as expected in Transaction Services enabled documents in MicroStrategy 9. Note: If a user enters more than 15 digits for a. Source: MicroRooster. Open the document in Presentation Mode. If user wants to add more connection parameters other than above, they can manually. 1. The document will get refreshed automatically after the submit button is clicked. This supports the scenario that a user only wants to update values for certain metrics or attributes, while leaving the other. Related Topics. Here t he transaction document shows the editable elements and the submit button. Run the Opportunity Management document. With MicroStrategy Transactions services support for SQL Server, users can record selections in a SQL Server table. To learn more about ACLs in BigQuery, see the BigQuery ACLs documentation. You can perform these tasks directly from the document in Express Mode in MicroStrategy Web, and when you view the document on a mobile device with MicroStrategy Mobile. Video Tutorial - Visualizations in MicroStrategy Dossier, Part 2: The Editor Panel. 10. MicroStrategy 11. Unlock the ultimate power play of data creativity and data horsepower to develop applications that transform. This issue is fixed in MicroStrategy Mobile 9. x and 10. Dante Klz. Financial Services Healthcare Retail Government Resources Connect Events World 2024. 4. This is relevant to MicroStrategy Web 9. Save the FreeForm SQL and Run the report. Labels: #Creat transaction services photo uploader. Navigate to and select a Transaction Services report, then click OK. SYMPTOM: A Transaction Services configuration that works with another supported DB instance, when reconfigured to point to an Impala instance, will cause MicroStrategy to stay in the “loading” state indefinitely and the same line will be written to the database repeatedly. It all starts with the highly anticipated debut of the transactional grid for Dossier, providing actionable analytics for improved efficiency and. 3329 views | June 24,. If an Universal version of the Intelligence Server is used, the Query Engine is a 64-bit component and will not encounter the same memory limitation as the 32-bit version of the Query Engine that. Upgrade to this version or later to resolve this issue. This article notes a defect where data blending changes the datatype of input metrics preventing decimal inputs to transaction services input metricsIn MicroStrategy Web 9. txt file. 4. Creation of system documentation and status reports. The solution is provided along with screenshots and the specific values for each number of stars. ir@microstrategy. 23 : Click OK to save your changes and return to the document. KB442298: Transaction services updated the data unexpectedly when multiple records are modified and submitted in MicroStra… Number of Views 3. 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. 9 product when trying to run a Transaction Services report in which a grid is being used to configure the transaction. xml administrators can add any formatting they want but if the formatting entered does not match the formatting specified in the LCID list the prompt. x. Browse and incorporate these templates into your own data dashboards. SYMPTOM: In a Transaction Services Document, after searching for elements in a pull down list selector and choosing one from the results set, if the users then clears the selector, the selector results will continue to be filtered by the previous input and would not allow the user to change the selection, in MicroStrategy 9. 4, presentation. This feature is available when you install Transaction Services. Updating Data by Using a Transaction Services-Enabled Document. 4. Right click the transaction field and select "Configure Transactions". 2. x If the issue is observed with transaction configured to update ID forms for attributes, this might be a known limitation in MicroStrategy 10. Investor Relations . Repository. Login to vote. 2. 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. MicroStrategy Parallel Relational In-Memory Engine (MicroStrategy PRIME), MicroStrategy R Integration, MicroStrategy Report Services, MicroStrategy SDK, MicroStrategy System Manager, MicroStrategy Transaction Services, MicroStrategy Usher, MicroStrategy Web, MicroStrategy Workstation, MicroStrategy World, Usher,. Leverage embedded analytics to enable your organization to build robust, feature-filled business intelligence-enabled applications. When a new attribute form is created in a Transaction Services report, although its form format type is set to Number, the Data Type is automatically set to Integer. . 1. Transactions from Transaction Services are not Getting Inserted to the Data Warehouse, but MicroStrategy Web Shows that it was Successful. The format of the DECODE function is as follows: DECODE (<value>, <statement1>, <directive1>, <directive_default>) To understand the meaning of and the construction of DECODE, look at how the previous query would have been written using. 05/2010 - 07/2016. Traditionally, you use the MicroStrategy Engine to generate SQL to run against one specific relational database for a report. without importing the data back into MicroStrategy. 0. Right-click the grid report, transaction table, or any of the text fields in the panel stack, then select Configure Transaction. Details: BigQuery and MicroStrategy both support ACLs. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. Any web service that uses the REST architecture or SOAP protocol can be accessed by. Learn more Enterprise Data Management. Interacting with data sources. . 1 Update 1, where a date submitted through a transaction services document is stored in an unexpected format in the transaction database table. x, the last. Viewing and interacting with. visible=<Value> The selection state of MicroStrategy Transaction Services. 2. The steps below show you how to create a Transaction Services report using the Freeform SQL Editor. . Navigate to and select a Transaction Services report, then click OK. To learn more about the Required column, refer to article KB207490. A transaction services document displays the value from a transaction with a manual input upon exporting to Excel, even though the label is what displays when viewed in MicroStrategy Web 9. Microstrategy Dossiers With the release of MicroStrategy 10. This article outlines that Hive does not fully support transaction services, and MicroStrategy does not allow the use of transaction services for Hive. Check the "Input is Required" option for the "Oppty_name" and "Oppty_desc" fields to make them required fields. Keynotes and sessions presented at our annual user conference, MicroStrategy World 2022. In MicroStrategy Developer, edit the Hive database instance used for transaction service and click Upgrade . It allows users to update data, insert new information or delete existing records from the database. Consulting, MicroStrategy Customer Services, MicroStrategy Education, MicroStrategy University, MicroStrategy Managed Services, BI QuickStrike, Mobile QuickStrike, Transaction Services QuickStrike Perennial Education Pass, MicroStrategy Web Based Training (WBT), MicroStrategy World, BestMicroStrategy, MicroStrategy Business Intelligence Platform, MicroStrategy Cloud, MicroStrategy Mobile, Cloud Personal, MicroStrategy Transaction Services, Wisdom, MicroStrategy Wisdom and Emma. 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. Financial Services Healthcare Retail Government Resources Resources Connect Events World 2024 Community & Support Partner Network. #Creat transaction services photo uploader #transaction services; #Create Email Subscription in Microstrategy #email subscription; #Create your own Open source Agile boards; #Creates a schedule Microstrategy #schedule; #Creating a . Please refer to below example to see the behavior. Refresh. 4. This knowledge base article describes an intermittent behavior in MicroStrategy Web 10. Get inspiration at the MicroStrategy data dashboard gallery. 4. Transaction Services 対応ドキュメントを使用して以下を行うことができます。. 4. 4. In MicroStrategy Developer 9. #Creat transaction services photo uploader #transaction services; #Create Email Subscription in Microstrategy #email subscription; #Create your own Open source Agile boards; #Creates a schedule Microstrategy #schedule; #Creating a . Click the text field or grid cell of the value to edit, then do one of the following: To edit a value in a Text Field or Text Area control, type a value in the field, then press Enter. 1 iOS app. 4. To increase the number:With MicroStrategy Transactions services support for Oracle, users can record selections in an Oracle table. Users can use the Freeform SQL editor on Developer to create Transaction Service reports and then trigger the reports through documents. Apply now! Skip to. This is expected behavior. x, users will come across two similar settings in Developer and Web in regards to. 1, after insert, update, delete operations, but the data is not updated. Option 3: Third option to prevent table locks with MySQL database is to use AUTOCOMMIT on the database level. If the transaction services enabled grid is long enough, like shown above, as the user scrolls. In MicroStrategy Web 10. Navigate to Shared Reports > MicroStrategy Platform Capabilities > MicroStrategy Transaction Services. ACTION: 1) Right mouse click on the transaction grid, choose Thresholds->Advanced. 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. Run the document using the MicroStrategy Mobile 9. This is fixed in MicroStrategy Mobile Android application 10. A product called MicroStrategy Transaction Services will allow mobile applications to talk to transactional systems back at the home office. The input for this can be set to a dataset. 1, in a Transaction Services document users can configure the transaction input as a List control style and pull down display style. Run the document in Express mode. a. …The Freeform SQL functionality adds great flexibility to MicroStrategy's query and reporting capabilities. This issue only occurs when answering the Subcategory prompt with more than one answer. View the following image for reference: Why is this happening? Smart Metric calculations take place in the Analytical Engine, while all transactions must, by definition, take place on the database. Production support including user training. 1m and above Loading × Sorry to interruptFollow the steps below to reproduce the issue with MicroStrategy Tutorial project: 1. The impact is from the MicroStrategy Web 10. 20 — The high share price for Tysons software company MicroStrategy Inc. TransactionServices. MicroStrategy Transaction Services lets you embed write-back functionality into documents and dashboards for the purposes of decision-making or initiating a transaction. x. The dossier transaction configuration automatically generates the basic INSERT, UPDATE, and DELETE SQL statements with tokens according to the mapping view configuration. MicroStrategy Transaction Services를 사용하면 의사 결정 또는 트랜잭션 시작을 위해 다시 쓰기 기능을 리포트와 대시보드에 포함할 수 있습니다. 4. Transaction Services Calendar has no arrows to change months in MicroStrategy Web. Throughout the workflow of setting up and using a Transaction Services document in MicroStrategy 9. It was the highest price for the. x to change password for login of. 1 that supports write-back (Insert, Update and Delete) from a Report Services Document to a Data Warehouse or Transaction Database. Visualizations in MicroStrategy Dossier, Part 4: The Presentation Layer. The Configure Transactions Editor opens. If the User is logging in via typing Guest, the button appears correctly and can be used to execute the transaction. 4. In MicroStrategy 10. 5. When creating a Transaction Services report, you can make some of the inputs optional. Dossiers go beyond traditional dashboards and reports by adding collaboration, responsive design, and a variety of different content such as charts, grids, visualizations, images, reports,. Enable the option "Flag cells with modifed data" as shown in the screenshot below: Transaction services updated the data unexpected when multiple records are modified and submitted in MicroStrategy Web 10. DBMS Update Note: The new setting is only applicable if you are upgrading from MicroStrategy 2021 Update 2 to MicroStrategy 2021 Update 3. It all starts with the highly anticipated debut of the transactional grid for Dossier, providing actionable analytics for improved efficiency and. MicroStrategy Transaction Services lets you embed write-back functionality into documents and dashboards for the purposes of decision-making or initiating a transaction. . Why MicroStrategy Why MicroStrategy; Customer Stories; Platform. 4 HF2. To retrieve a list of services on a machine, use the command mstrctl -m machinename ls. If the Action Type choices are Select Attribute Element, Select Attribute, Select Metric, Select Panel, and Select Metric Condition, you are working with an object selector. 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. 5 million initially recognized for the ShopKo transaction in the fourth quarter of 1998, and recognized only $934,000, because the transaction had required MicroStrategy to provide software licenses, extensive consulting and development services that could not be accounted for. When building a Transaction Service document in MicroStrategy Web 9. KB442534: In MicroStrategy Web, a Transaction Services text box inside a Document shows the value ‘(NULL)’ Description. A product bundle (including Web, Intelligence, Analytics, and Distribution) designed to meet the specific needs of power users who create, design, analyze, share, and save MicroStrategy Dossiers, reports, and documents. Most frequent use cases. Web Professional. For jobs executed in MicroStrategy Web, the Query Engine of the Intelligence Server is used. 4. Number of Views 6. Consulting, MicroStrategy Customer Services, MicroStrategy Education, MicroStrategy University, MicroStrategy Managed Services, BI QuickStrike, Mobile QuickStrike, Transaction Services QuickStrike Perennial Education Pass, MicroStrategy Web Based Training (WBT), MicroStrategy World, BestDossier Design: Unlike MicroStrategy Mobile, Library supports dossier, which allows authors to design with free-form layout and everything that comes with dossier authoring. 1. Enables write-back capabilities to capture user input into databases. Select "Configure Transaction". 3. 2. 1 and above, any changes to the Fill color of an Action Selector Button are not reflected when running the document in Express Mode. x and 10. Add a transaction field (and submit button) 4. blogspot. Hee-Wei Tan (Inactive) · May 1, 2017 ·. To ensure that you are using the documentati on that corresponds to the software you are licensed to use, compare this version n umber with the softwareYou can connect to third-party web services to retrieve data and report on that data within MicroStrategy. mstrc file from an empty text file #mstrc #mstrcconnectionfile; #Creating a Microcharts widget in. XQuery is a language for processing XML data. Optimal performance for your PostgreSQL data. The most common examples where transaction services are used are some of the following: – Stock Management. . MicroStrategy Parallel Relational In-Memory Engine (MicroStrategy PRIME), MicroStrategy R Integration, MicroStrategy Report Services, MicroStrategy SDK, MicroStrategy System Manager, MicroStrategy Transaction Services, MicroStrategy Usher, MicroStrategy Web, MicroStrategy Workstation, MicroStrategy World, Usher,. 4 HF5 and 10. Course 107 provides a general introduction to transaction services, and teaches you how to use a wide range of transactional input forms to change and add ne. Create a derived metric(DM) so that it is calculated from current metrics. .