For steps to create database connections in MicroStrategy Web, see Creating Database Connections in Web. In documents, links can be added to objects in a Grid/Graph, and they can link to another document or to a report. Format your heat map visualization. MicroStrategy users can format how the values of metrics and attributes are displayed on their reports. A new drop-down also appears. MicroStrategy Desktop's intuitive toolset and built-in templates make it easy to build compelling analytical books of visualizations, dashboards, and reports in a matter of minutes—we call these MicroStrategy Dossiers TM. choosing metric and condition. MicroStrategy AI is here. Developer enables you to model applications using an intuitive, graphical interface. In the Select Import Options dialog-box, select Build a Query. Different data wrangling and parsing techniques are deployed under this feature to create reports that are insightful and useful. It is important to design the correct filter to retrieve the desired data. Create two Panel Stacks: Grid View and Graph View. Notes This visualization might not auto-size when exporting via PDF. Introduction MicroStrategy Intelligence Server can send email messages in different scenarios such as through Distribution Services email subscriptions, the "Send Now" option on reports or dashboards, administrative notification emails, Collaboration Server notification emails etc. $126,510 - $189,760 a year. 0 workflow with Okta can be seen here. The second most common hard skill for a microstrategy developer is bi appearing on 5. MicroStrategy offers an intuitive way to create and modify business. Headline : MicroStrategy Developer with 8 years of experience in building projects and creating reports and dashboards using MicroStrategy 9. This can be done with MicroStrategy SDK 9. Click Advanced, then New to create a custom subtotal. NET): Program FilesCommon FilesMicroStrategy directory. Welcome to MicroStrategy Developer. You can also create, edit, or delete multiple custom groups at the same time by using a Command Manager script. Enter the definition of the derived attribute directly into the right pane. Web: From the MicroStrategy icon, select Preferences. This video presents how to create a report in the MicroStrategy 9 Developer (here referred to as “Desktop”). Before Customization: After Customization: Launch the Web Customization Editor. For details on how to create a Query Builder. MicroStrategy Embedding SDK allows you to quickly integrate a MicroStrategy dossier into a web application in a responsive manner. Tampa, FL 33601. Experience using MicroStrategy Business. However, when you display the report as a Scatter plot. 2. This will open the app in a web browser or a separate window,. Double-click the attribute to edit. Exit the Web Customization Editor. 0, Genesys CX Insights replaces Genesys Interactive Insights. The following procedure describes how to achieve this: Create the highest level filter. Create a new plugin in the Web Customization Editor. To create a document templateUsers are able to create a metric that will always have a constant value and will be independent of the level on the report. To define a specific subtotal displays for a report like the one shown above, follow the steps below: Select Subtotals from the Data menu. MicroStrategy Certified Engineer (MCE): This certification demonstrates your skills in executing advanced analytics projects using all platform capabilities. The "Refresh Cube Subscription Editor" allows for a "Name", "Schedule", and "Delivery Notification" to be set. The function 'DayOfWeek' will return an integer value which '1' means 'Sunday', '2' means 'Monday' and so forth. Expand Database instances > SQL Data warehouses. 3. seeing alert-based subscription result. A custom group is made up of an ordered collection of components called custom group elements. Report Usage Analysis Dashboard. In this tutorial,. VI dashboards can be viewed in the Dashboard Editor, Flash Mode, or Express Mode in Web, as well as on an iPad. MicroStrategy offers an intuitive way to create and modify business. Open the Workstation window. This can be accomplished by developing. MicroStrategy provides ETL, data warehousing and data mining for data analysis. In MicroStrategy Developer 10. We drag the attributes product - Subcategory and Shipping cost - to the rows box. To Create and Save a Dossier. The course also lets you analyze MicroStrategy data flow. In MicroStrategy Developer, search for the created dashboard. x, the attribute must have an attribute form with syntax similar to the one shown below where Attribute_DESC_A is the attribute form that will be displayed in a grid and Attribute_DESC_B is the attribute form that is. Under 'Level…' choose the attribute. Open a dossier. opening the alerts editor. In Web Preferences under 'Default start page,' choose the report that was just executed as shown in the image below: Click 'Apply,' and this report will now. VI dashboards can be viewed in the Dashboard Editor, Flash Mode, or Express Mode in Web, as well as on an iPad. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. x and 10. 1. It provides a unified environment for creating and. Visit the data visualization and data dashboard galleries for inspiration. MicroStrategy 9 Release 3 lets you explore your data in compelling reports and dashboards via iPhone, iPad, BlackBerry, Web, and more. 2. For example, to export a document to PDF, you need to create a URL that includes the event that accesses the "RW Fast. Business purpose. Power BI: an exceptionally well-designed user interface - everyone familiar with Office products. x, the worksheets in Microsoft Excel will be named 'Sheet 1,' 'Sheet 2,' etc. · How to use all the main visualizations. You create VI dashboards in MicroStrategy Web; for instructions, see the MicroStrategy Web Help. MicroStrategy Desktop provides the ability to connect to a wide variety of relational databases such as Oracle, SQL Server, MySQL, Teradata, SAP HANA, Netezza, IBM Db2, Microsoft Access, etc. Presented during MicroStrategy World, learn how to build an interactive book of your business with an updated Visualization Gallery and enhanced filter options. From Developer, you can manage multiple. When a security filter is used, different users get different report results when the same report is being executed, hence there might be a need to include the name of the user who generated the report in the grid to differentiate the. Locate "frame_vfe_1" and select it. Architect. Source: MicroRooster. 2) Go to the Data menu > Edit Drill Map. 2. Drag the attribute and the metric into the 'Detail' section. You will study the creation of tables, charts, maps and KPI visualization, as well as forecasting data and creating an interactive dashboard. Change the value to 1. From the Graph menu, select Preferences to open this dialog box. x: In document design mode on the existing graph, set 'Show Values' > 'Values on Slices' as shown below:To duplicate a project in MicroStrategy Develper 10. From the Data menu, select Report Data Options. ; Enter the XQuery statement required to connect to the third-party. 4. Accessing an Out-of-the-Box MicroStrategy Web Page. From the Filemenu, point to Schedule Delivery To, and select the type of subscription to create: To schedule a History List message, select History List. Microstrategy Web Advanced . 2. Microstrategy is based on single meta-data repository; Microstrategy can be operated as web based and a desktop tool; There is no cube data-set for Microstrategy, and we obtain latest data-set from data-warehouse automatically; Microstrategy reporting is fast; Cognos has two meta-data repository based database; It can be used as web-base. 1, users now have the ability to enable this behavior at the attribute level, so that when an attribute form is set as a Report Sort form in the Attribute Editor, the attribute will sort by that form in all reports by-default, even if that form is not present on the report at all - not even in. 2. · How to professionally and effectively. How the user answers the question determines what data is displayed on the report when it is returned from your data source. Retrieve a list of user groups and the associated users in MicroStrategy Developer Follow the steps below to create a list of all groups and the users in each group: In MicroStrategy Developer 9. x: Create a metric called A with expression "Min(1){~}" as shown below. xlsx as an example data set. Point to Show Hidden Objects. To see sample dashboards in MicroStrategy Web. 04K subscribers. The report using this metric will now. The formatting options for series values appear. Check other tables and select/deselect correct tables. KB17619: How to create a conditional attribute in MicroStrategy Desktop 8. For example, you can edit all custom groups to use a different attribute element. However when Visual Insight dashboards are converted to RS documents through MicroStrategy Web, the edit option for the RS document is grayed out in MicroStrategy Developer, as seen below. For information on using Visual Insight to create dashboards that contain mapping visualizations, see the MicroStrategy Web Help . Create a heat map visualization using your imported data. The third-party product(s) discussed in this article is manufactured by vendors independent of MicroStrategy. Choose Data > Subtotals. This is a filter which contains a prompt on an attribute element list. Workaround 4: Create a metric based on the attribute Country, for example Max (Country). Open a grid report. This feature can be used in MicroStrategy Developer, MicroStrategy Web, and MicroStrategy Mobile. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. DEFINITION: This custom group is a custom group banding qualification created on the metric, with band size banding type and a step size of '1' (integers). Select Image from the Insert menu, or click the Image icon in the toolbar. setServerName ("servername"); serverSession. serverSession. The cost for taking the MCA exam is $250 USD per attempt. Create, share, and maintain dashboards and dossiers. Then right-click on the right side of MicroStrategy Developer and select New, then select Filter. Navigate to the appropriate location, name the file, and save it. com Format: A MicroStrategy Online Training Video blog. From Developer, you can manage multiple environments, apply and enforce security, and monitor environment usage. The example given will allow you to select a date, and the report will bring back all dates between the date selected and 1 month. You create VI dashboards in MicroStrategy Web; for instructions, see the MicroStrategy Web Help. Microstrategy developer responsibilities. MicroStrategy Developer provides the project designer functionality essential to creating both schema and application objects necessary to serve the user communities of both MicroStrategy Developer and Web. x/8. Add the following Autotext: {&Prompt1&} and {&Prompt2&} as show below: The two prompt AutoText values will correspond with the two Dynamic Dates that. Insert two images in the dashboard: your grid view image and graph view image. ; In the Source area, select the database instance for the data source to be updated using Transaction Services. Assume the target report has a prompt. Once you select the data from the source, the data is automatically added to an interactive grid. Each dot on the graph represents the intersection of the data on the X and Y axes. Add the filter to the report. The following steps will add a toolbar item in MicroStrategy Visual Insight Dashboards using the MicroStrategy Web SDK 10. The following window appears. You can also create, edit, or delete multiple custom groups at the same time by using a Command Manager script. It offers you level metrics, conditional metrics, compound metrics, as well as transformation. 9-10. The object's editor or wizard opens. ANALYST VIDEOS & TUTORIALS. ARCHITECT VIDEOS & TUTORIALS. Depending on how your administrator set up your user account, this may be the same login and password you use to access your computer, or it may be a MicroStrategy-specific. The following steps will add a toolbar item in MicroStrategy Visual Insight Dashboards using the MicroStrategy Web SDK 10. The Preferences dialog box opens. Click Save . MicroStrategy launched MicroStrategy AI, a portfolio of features designed to make data workers more efficient by enabling them to interact with data using generative AI. 06K KB5221: How to create metrics based only on constant values in MicroStrategy Desktop 9. ; On the Freeform Sources tab, select Create Transaction report. Embedding Playground The one-stop shop for developers to build impactful, interactive analytics experiences through drag-and-drop interface and built-in code editor. To open the demo visualization in MicroStrategy Web, choose Create -> Upload MicroStrategy File -> View Dashboard. Then user is able to select the object to display. Rename the panels as: Books and Electronics; On the Books panel, put a grid that only contains the Category attribute and the Profit metric. Step 2: Create a new report that includes the User attribute, the other attribute that you wish to filter. Click the Options icon . Set up the Enterprise Manager. xWhen designing a report's structure, you can use a tabular layout or a cross-tab layout. The Metric Editor opens. See Best practices for creating HTML dashboards: Analytics Module examples for examples from the Analytics Modules that demonstrate. · Tips and tricks on using some not so well know features. Execute the report. The steps below give a detailed explanation on how to. MicroStrategy integration with Kafka. The condition is based on either an attribute or metric. 963. In MicroStrategy Developer, create an attribute mapped to the LU table. Qualify on ID, choose the Operator as `Exactly`, and drag the date prompt created in Step1 in the filter definition. Once you have your design requirements, we can begin looking at the different authoring capabilities between a dossier and a document. The following steps will remove a toolbar item in MicroStrategy Visual Insight Dashboards using the SDK 10. Under 'Source tables', select a table and click 'Set as Lookup'. You should now see the Object Templates folder in your project list. 'This is for testing')in the 'Enter Project Status' filed, and make sure the option 'Display project status' on the bottom is checked. 11: 1. This section describes the ODBC standard for connecting to. First, you'll learn what a dossier is and how to import data into it. Inject, extend, and embed intelligence into custom and third party. In the Run Modes area, select the format (s) in which the document can be exported: •. blogspot. Create a report with 'Year' attribute on rows and 'Category' attribute and 'Revenue' metric on the column as shown. . Figure 1 Administrators MicroStrategy Developer is the Administrator's Home and the primary source of administering MicroStrategy Enterprise. Embedding images using base64 encoding in an HTML Container object has been confirmed to work in MicroStrategy Analytics Enterprise 9. Click an object to add it to the definition. After you install it, you use the Document Editor in MicroStrategy Developer or MicroStrategy Web to access Report Servicesfunctionality. The options for exporting the report to a Microsoft Excel worksheet are displayed. To see which interfaces you can use, refer to the tables under each of the following methods. Enable all users in ‘Managers’ group to use MicroStrategy Desktop to download a dashboard from MicroStrategy Intelligence Server; GRANT USEMSTRDESKTOP, WEBEXECUTEANALYSIS, EXPORTTOMSTRFILE TO GROUP "Managers"; Enable an individual user ‘Jon Snow’ to use MicroStrategy Desktop to import their own data and export a dashboard KB226952: How to create a custom subtotal with values directly retrieved from warehouse instead of being calculated by Analytical Engine in MicroStrategy Analytics Developer 9. MicroStrategy URL Parameters. Open a blank dossier. Developer enables you to model applications using an intuitive, graphical interface. Footnote 3. On the dataset "Generic Metrics List". Select File from Disk and select your Excel project. To open the demo visualization in MicroStrategy Web, choose Create -> Upload MicroStrategy File -> View Dashboard. Each element contains a set of filtering or banding qualifications. After the document is exported, the content of the document is displayed using the default settings in Microsoft Excel. In MicroStrategy Developer, choose File > New > Prompt. Right-click the report whose usage activity you want to view and choose Properties. You can specify whether you will be. Navigate to the appropriate location, name the file, and save it. Open the Create Personal View dialog by doing one of the following: For a dossier: From the File menu, select Create Personal View. x. The MicroStrategy Web JAR files can be found under: MicroStrategy Web Universal (JSP): {web_root}/WEB-INF/lib directory. 7. Users may want to create a report with a metric that has the current date of execution as a column on a report in MicroStrategy Developer 9. Select Image from the Insert menu, or click the Image icon in the toolbar. Step 1: Create a filter that sets a user attribute equal to the System Prompt "User Login". Using machine learning, we determined the following key facts about microstrategy developer job descriptions to get more candidates: The average microstrategy developer job description intro is about 199 words; The responsibilities section of a microstrategy developer job description contains an average of 7 bullet pointsEnrol in this course to become more proficient in data analytics using software like MicroStrategy. 3. To create an attribute in MicroStrategy with a fixed NUMBER value, follow the steps below:. The first is the 'Web User Session Idle Time' setting located in Developer by right clicking the project source -> Configure MicroStrategy Intelligence Server -> Governing -> General The second setting is the session timeout on the web server side. You can also use the Metric Editor to modify an existing metric. Expand General in the list of categories, then select Drilling. x and 10. x. Maintain compliance with company's systems and controls methodologies. Choose a ‘Day’ attribute, and click ‘Next’ 3. Network and computer system administrators: Manage and maintain computer systems. Click User Manager. Click OK. Microstrategy Dashboard performance improvements steps: Many. 4. x, users can import reports or entire modules from third-party Salesforce accounts to build MicroStrategy reports, visualizations, and dashboards via the Data Import tool. In the out-of-the-box MicroStrategy Web product, certain events specified by the evt parameter are automatically mapped to a particular MicroStrategy Web page. The Drill - Advanced pane is displayed. Proficiency in database management systems and BI technologies. To configure:-. 6K views 5 years ago. Matching objects appear in a drop-down as you type. Platform: Edureka Description: After completing the training, you will be able to create the solution for data visualization issues of any size on any platform and create, execute, monitor and schedule BI reports and dashboard processes. Watch on. By being only one page long, an RS dashboard makes it easy to view the entire document at the same time and see all the information. To access the MicroStrategy Developer Zone, you must have access to the MicroStrategy Knowledge Base, you must have purchased. In this example, the Year attribute is used. Companies of all sizes use this platform to assess, visualise, and build dashboards. These RS dashboards include full interactivity, visualization, and data content. Choose Options and the General tab. In MicroStrategy Developer, choose File > New >. Change the device. By this, I mean, that the user should be able to choose which attribute is being displayed on the dashboard, For instance let the report have a structureUnleash the Power of Your Data in Seconds. Add a comment. Apply to apply changes. 2. It provides a unified environment for creating and. MicroStrategy Developer Formerly known as MicroStrategy Desktop, MicroStrategy Developer is an application that gives developers the ability to create reporting and analytics solutions. Enterprise Reporting: It helps you to create enterprise reports with more elegant analysis. Report Objects. Overview of attributes. MicroStrategy - Creating a Dashboard. Supercharge your BI & analytics career with training and professional certifications for developers, architects, analysts, administrators, and data scientists. 0% of resumes included Dashboards, and 4. MicroStrategy makes it easy for you to create dashboards using its simple “drag-and-drop” feature. Ensure that the Tooltips check box is selected. For the sample to work, the MicroStrategy Web JAR files must be accessible by the Java Runtime. MicroStrategy is a business intelligence tool that is widely used for deriving valuable insights from data in the form of visually insightful reports, graphs and charts. Choose Data > Subtotals. MicroStrategy Analytics Enterprise, MicroStrategy Evaluation Edition, MicroStrategy Suite, MicroStrategy Web, MicroStrategy Mobile, MicroStrategy Server, MicroStrategy Parallel Relational In-Memory Engine (MicroStrategy PRIME), MicroStrategy MultiSource, MicroStrategy OLAP Services,Approach. Accessing the Derived Elements Editor depends on what mode you are viewing the document in. This tutorial video explains how to import data from a relational database as a Dataset into MicroStrategy Desktop. Derived elements can be created in the following types of reports and documents: Standard reports. Click the name of a report to execute it. Enter a Form name and Description. ; On the Freeform Sources tab, select Create Transaction report. Enter a Form name and Description. 1. The end results still reflect null values and does not display "0" for empty rows as shown above . Select the check box for the database instance. ; Enter the XQuery statement required to connect to the third-party. Web: From the MicroStrategy icon, select Preferences. Type the text of the desired macro or your own static text. To Create a Transaction Services Report. Choose Pie > Pie Chart or Ring Chart . Maulik Dhandhukia. 4. The following steps show how to create the plug-in and deploy. From your computer's Start menu, go to Programs (or All Programs) > MicroStrategy Products > Developer. Expand General in the list of categories, then select Drilling. ) next to Run this report or document to find and select the target report or document. Create two count distinct derived metrics and places them on the report template. Select the Show Tooltip (Web Only) check box. MicroStrategy is a Business Intelligence software, which offers a wide range of data analytics capabilities. You are a financial analyst and want to build a grid to analyze each region’s performance across different set of products, like home equity loans and certificates of deposit, all in the same view. Browse Library. Pros and Cons. x and 10. Starting from version 2021, an OOTB waterfall visualization is bundled in MicroStrategy. To create a metric: To access the Metric Editor. Create a new threshold defined as 'Revenue exactly 0'. Choose 'New' from the Advanced Subtotals Options window. 1 to see the results as shown below: Right click on Attribute Region in the grid view of the report and click on Derived Elements as seen below: Create a derived element group called DE with elements "Central" and Mid-Atlantic" as seen below:When upgrading a MicroStrategy system to a newer version, it is likely that products will be upgraded across several machines. This dashboard provides an overview of report usage and performance in your projects, including average wait times and number of execution errors encountered. For more information regarding the MicroStrategy Web architecture or the process of customizing MicroStrategy Web, please refer to MicroStrategy Developer Zone (tutorial shows how to create derived attributes and metrics in a dossier. Create a new plug-in and give it a meaningful name: ImageLayoutPlugin (a sample plugin is attached to this article). Here are examples of responsibilities from real microstrategy developer resumes: Develop UNIX shell scripts. In a report using MicroStrategy 10. In this example, the alias table is named 'LU_AIRPORT_ALIAS'. Create a report using the attribute. 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. For details on how to create a Freeform SQL report to access a database, see Access and Analyze Multiple Data Sources with Freeform SQL. blogspot. . Lab 4-3 (Algo) Create Dashboards - LendingClub Saved Help Save & Exit Sub This question will be sent to your instructor for grading. Select the name of the series to define tooltips for a single series. Displays or hides the Notes panel. g. All articles. . Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. The default folder is: C:Program Files (x86)MicroStrategyProduct Name when installed on a 64-bit Windows environment. Hierarchy Qualification Prompt. On the Freeform Sources tab, in the Source area, select a database instance for the data source to access using Freeform SQL. Case ( [Metric Selector]="Rebates", Discount, [Metric Selector]="Sales", Revenue, 0) Creating Dashboards in MicroStrategy: This tutorial shows you how to create dashboards in MicroStrategy. mstr suffix. 4. A business intelligence platform offers a complete set of tools for the creation, deployment, support, and maintenance of business intelligence applications. Creating a metric. This geographical data can. To import data from a Salesforce account, certain connectivity settings must be configured. Description The . The two fundamental parameters are the evt (short for “event”) parameter and the src (short for “source”) parameter. The following steps can be used to concatenate two attribute forms. If a message is displayed asking if you want to use read only mode or edit mode, select Edit and click OK to open the Attribute Editor in edit mode so that you can make changes to the attribute. MicroStrategy makes no warranty, express, implied or otherwise, regarding this product, including its performance or reliability. A dashboard is made up of multiple visualizations. The example provided in this document is provided “as-is” to. 05/2010 - 07/2016. opening the alerts editor. Create a new derived attribute by. If user wants to add more connection parameters other than above, they can manually. The following procedure describes how to add or create a prompt in a cube report in MicroStrategy Developer. Check ‘Filter definition prompt’ -> select ‘Qualify on an attribute’ , and click ‘Next’. In the PDF Options dialog box determine the report scaling and orientation, and press Export. Prompt-in-prompt is a feature in which the answer to one prompt is used to define another prompt. This means you can manually change the suffix to . Drag in the `Day` attribute in the filter. 4. Retrieve a list of user groups and the associated users in MicroStrategy Developer Follow the steps below to create a list of all groups and the users in each group: In MicroStrategy Developer 9. Check out the five modern tools you should be using to ensure you are getting the most out of the MicroStrategy platform: 1. Dossiers. Dashboard execution stages can be represented below: MicroStrategy Intelligence Server When an end user makes a Document Execution Request through any client (a web browser via MicroStrategy Web, the MicroStrategy Desktop/Developer client, the MicroStrategy Mobile app, or the MicroStrategy Office client), the request is. Presented during MicroStrategy World, learn how to build an interactive book of your business with an updated Visualization Gallery and enhanced. Choose 'Month' as the attribute. Right-click in an empty area on the right side of. To Create and Save a Dossier. Introduction to MicroStrategy Desktop. Qualify on 'ID'. At the bottom of the dialog box on the right, select the Display Hidden Objects check box. Related Topics. To create a Freeform SQL report. Tabular Layout Cross-Tab Layout There are some important. Citi 3. Visit the data visualization and data dashboard galleries for inspiration. Basic Report Consumers use the Developer tool to. The following steps may be used as a reference and the result will display the last 3 working days: Create a attribute form for 'Day' attribute using MicroStrategy built-in function 'DayOfWeek' to indicate what day is it. This tutorial steps through how to switch to a compound grid, add column sets within the compound grid, and a simple use case for leveraging this new visualization type. Create a filter (Month) using attribute qualification. How to show hidden objects? In the Datasets panel, click the arrow icon in the top right. Microstrategy Web Visual Insights . Click the down arrow next to data > choose "Hide nulls/zeros" to enable the hide nulls/zero option. Sheet 1. Choose 'Clear All' and choose 'Advanced' in the Subtotals window. Drilling allows you to look at specific data at levels other than that of the originally displayed grid or graph. A cross-tab layout is useful for multi-dimensional analysis and is generated by adding attributes to the column. Place the "Top 10 Customers vs All" (as is done with an attribute), the "Percent to Total Customers Revenue", and "Revenue" on the report and the result will as shown in the screen shot below: Users can create a report. A cloud-native, open architecture platform, it is built on a scalable, future-fit semantic layer designed to inject AI-powered Intelligence Everywhere™. Select the report in MicroStrategy Developer. When this custom group is placed on a report with the metric and an answer of '8' for the prompt, the following results are returned:The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. Oracle 11x database. MicroStrategy Certified Engineer (MCE): This certification demonstrates your skills in executing advanced analytics projects using all platform capabilities. You can format a graph report by adjusting colors, and applying a variety of graphical effects, including gradients, transparency, patterns, pictures, textures, and bevel effects. In this tutorial I show you how to create a beautiful dashboard that incorporates the ESRI mapping widget. 4. In the following example, we will create a dashboard showing some common. To Create a Dynamic Date Based on a Prompt Answer Create the Date Prompt. 4. seeing alert-based subscription result. Create the relationships and hierarchies. In the list of categories on the left, click Subtotals. 4. Click OK.