In this MicroStrategy tutorial you will learn MicroStrategy from the basics to help you learn this top Business Intelligence tool. 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. Every MicroStrategy BI application requires at a minimum: 1. Community. MicroStrategy is a Business Intelligence(BI) and On-line Analytical Processing (OLAP) software which allows reporting and analysis of data from a variety of sources, including data warehouses, Excel files, and. This provides data scientists access to trusted, operational. Using real-world BI scenarios, this book helps you to implement Business Analytics solutions in big e-commerce companies. Alteryx Analytics allows users to organize, clean, and analyze data in a repeatable workflow. Create a grid report with the all_sales. 629 views · January. Following are the three report types used in MicroStrategy Desktop. MicroStrategy Tutorial Reporting. Viewing the Query. Hover over the Properties column and click Open Intelligence Server Administration Portal . The modeling tool allows architects to transform a complex enterprise data environment. Best Practices. An Introduction to MicroStrategy and offers a comprehensive library of analytic functions, MicroStrategy was established in 1989 learn more. Easyreport is an easy-to-use Web Reporting tool (supporting hadoop,hbase and various relational databases) whose main function is to convert the row and column structure queried by SQL statements into an HTML table (table) and to support cross-row (RowSpan) and cross-columns ( ColSpan). 8. CONTENTS BookOverviewandAdditionalResources vi 1. You can also select an existing template (see How to Create a Report Based on an Existing Template ). Introduction. 4. It started in 1993 and now it is one of the most popular Business Intelligence tools in the world because it is simple, intuitive and friendly. Easy to use data analysis and dashboard creation. MicroStrategy is a business intelligence platform that enables customers to make informed decisions through unified dashboards, reporting, analysis, and real-time monitoring. 2. MicroStrategy 8 ships with a stand-alone Crystal Converter Utility. MicroStrategy - Rollup. This allows enterprise BI developers and administrators to build and administer sophisticated enterprise and mobile analytics applications, at a fraction of the effort it traditionally takes. MicroStrategy is a global leader in business intelligence technology. It is recognized as a visionary by Gartner Magic Quadrant. Build critical, in-demand skills and accelerate your career. Right-click on the right-hand side of Desktop, select New, and then select Report. In MicroStrategy Desktop, log in to a project. The following table lists folders and files of interest that are included in the default directory structure after an installation of Developer. 2. Check out the five modern tools you should be using to ensure you are getting the most out of the MicroStrategy platform: 1. Enterprise can choose from in-center training, live online lectures, on-demand learning, and private on-site engagements to meet their training requirements. 7. A business intelligence platform offers a complete set of tools for the creation, deployment, support, and maintenance of business intelligence applications. Dossier. It provides the capability for complex calculations, trend analysis, etc. Dossiers. 4. MicroStrategy is a business intelligence (BI) and analytics platform that provides organizations with tools to analyze and visualize data, make informed decisions, and drive business growth. MicroStrategy - Configuration Objects. By presenting dashboard with geography map and grid, the video describes. We have MicroStrategy one of the leading and fastest growing tool. The Performance Analysis folder in Enterprise Manager has reports that measure such metrics as average job execution time and other job performance trends, cache analysis, longest executing reports, and so on. # Create a new User. The Slicing operation of a data set involves creating a smaller data set by filtering one dimension. Tableau Desktop provides a considerable big set of visualizations. Interestingly, it also shows the icons of data sources for quicker identification of data. When the request is received, MicroStrategy Web application uses this value to redirect the request to the target associated with this event. This section describes how to create a report using the quick report creation tool called Report Builder. The sample reports illustrate various reporting concepts such as the difference between report filters and report limits, while showing you how reports are built and generated. . No license is granted for any other purpose. . The Basic Report is used as a foundation report to create the more advanced reports used as examples in this section. 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. Take your reports one step f. Analytical methods. The MicroStrategy Tutorial is a MicroStrategy project, which includes a warehouse, and a set of demonstration applications designed to illustrate the platform's rich functionality. It takes care of extraction, translation, and loading of data from source to the target destination. Schema objects are building block objects; they are. . Navigate to MicroStrategy Tutorial and expand the Schema Objects option. already tried with the solution mentioned before with no results. It has a simple menu to import data for analysis and export the result of analysis. Rollup is the process of moving up in the hierarchy of dimensions in a given data set. eBook Preview – First Chapter FREE. Platform Analytics collects data from 10 areas of the. Click Create on any page, point to New Report, and then select Blank Report, which provides a blank template to build your report on. These are discussed below. It is a Business Intelligence (BI) tool. Stand out in a crowd. Right-click the metric sales, and we get the option to choose the threshold as shown in the following screenshot. It also has features to create complex features, which willThe following table lists folders and files of interest that are included in the default directory structure after an installation of Developer. 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. Creating a powerful dossier is as simple as importing. We performed a comparison between Microsoft BI, MicroStrategy, and Tableau based on real PeerSpot user reviews. 4. To Create a Report from Scratch. Graph Reports − These reports show various graphs created from the data sets. Building upon your existing knowledge, the book will teach you advanced techniques for building documents and dashboards. subscribe. You can easily copy a threshold to multiple metrics on a. Click 'Prepare Data' if further processing is required or click 'Finish' if it is not required. Log in to the MicroStrategy Tutorial sample project. Log in to the project in which you want to create a report. The information in a dataset can include MicroStrategy objects such as attributes, custom groups, consolidations, and metrics. MicroStrategy is very easy to use for end-users—polyvalent and versatile. We provide high earning skills MicroStrategy and live project. MicroStrategy Report Optimization. The default folder is: C:Program Files (x86)MicroStrategyProduct Name when installed on a 64-bit Windows environment. Reports. xml, contains information about which MicroStrategy-defined events are mapped to which event codes. In Program. Salesforce Reports Homepage. Pivoting of data in tables is done when we want to swap the position of columns and rows. In this new article, we will show how to call REST API in MicroStrategy. MicroStrategy's Report Builder steps you easily through the process of quick report creation, and lets you access a wide variety of report objects in your project to define your report. In this MicroStrategy (MSTR) tutorial, we will learn What is MicroStrategy, How go install it, history, architecture, features, advantages, & solutions. MicroStrategy facilitates data-driven decision-making by supporting data analysis, reporting, dashboarding and analytics capabilities. . MicroStrategy's software allows reporting and analysis of data stored in a relational database, multidimensional database, or flat data file. )MicroStrategy is a business intelligence (BI) and analytics platform that provides organizations with tools to analyze and visualize data, make informed decisions, and drive business growth. Professional Summary. In those MicroStrategy (MSTR) tutorial, we will learn What is MicroStrategy, How to install to, history, architecture, features, advantages, & applications. subscribe. The MicroStrategy Tutorial - Delivery project contains sample services that demonstrate many of the features of MicroStrategy Narrowcast Server. It integrates seamlessly with Salesforce CRM, Microsoft Dynamics ERP and SAP; plus, all major business intelligence. To log in to a specific project, see Starting MicroStrategy, page 2. Click Enter. Click ' Choose files' and select your Excel file or drag and drop the Excel file into the window. 最新の日本語版が提供されている場合. Additionally, this article make related to. These tools and capabilities include interactive dashboards, scorecards, ad hoc queries, automated report distribution. Saylor, Sanju Bansal, and Thomas Spahr, the firm develops software to analyze internal and external data in order to make business decisions and to develop mobile apps. Best practices and tools and tips for connecting to SAP. x. It is possible for the users to use it as a web-based or a desktop tool. Architect allows you to define all the required components of your project from a centralized interface. These are the objects which are decided during the creation of a MicroStrategy project. Interact with the engaged MicroStrategy Community to get answers to all your. With MicroStrategy Web, business users perform any of or all the major styles of BI - Scorecards and Dashboards, Enterprise Reporting, OLAP Analysis, Predictive Analysis, and Alerts and Proactive Notification - within a single, unified Web interface. An architect also provides a visual representation of your project as you create it, which helps to provide an intuitive workflow. Comprehensive analytical capabilities and Automated reporting: MicroStrategy offers wide range of analytical features including data visualizations, advance analytics, data discovery and predictive modeling. Online training and video tutorials are available free of cost. MicroStrategy’s OLAP Services is an expansion of MicroStrategy Intelligence Server. mobile devices, and the Cloud. Advanced. PDF. x: Navigate to Programs -> MicroStrategy -> Tools -> Project Mover. This 1-day course provides an overview of enterprise reporting using MicroStrategy Report Services™ in Micr oStrategy Web. · Tips and tricks on using some not so well know features. Add the attribute Subcategory and metric Revenue to the report template. txt). Robust architecture. Microstrategy Power Users & Analysts use the Developer tool to execute reports and dashboards created by the Microstrategy Development Team. Dossier. This course covers advance topics like Data Marts, Data Lakes, Schemas amongst others. We will cover MicroStrategy Report components, Report types and cover few examples. Click the link for the. MicroStrategy tutorial curriculum A MicroStrategy tutorial can help professionals build the skills to use business intelligence tools effectively. On-demand Webinars. Business Objects provides tools for data mining and quality and helps in better profiling because of too many acquisitions of other companies. This section provides guidance on upgrading to a newer version of MicroStrategy Web, so you can start using the Web SDK to adapt and integrate MicroStrategy functionality into your application or modify the standard interface or functionality. It is a. Dossier’s intuitive, drag-and-drop interface enables you to display and explore your data in seconds. . 1. Top Ways Microstrategy Outperforms Power BI Created Date: 5/18/2023 2:11:03 PM. x: //Create an empty report. . In this MicroStrategy (MSTR) tutorial, we bequeath learn What is MicroStrategy, How to install it, account, architektonisches, features, advantages, & applications. Enable users to interact with personalized chat for further product discovery. Help your customers get more out of the app experience with an engaging AI assistant that provides automatic answers or outputs in real time. Save and run the report. To start MicroStrategy Web: 1 In ampere my, enter the URL von your company’s MicroStrategy Web place. 014 Data Scientist ANALYST (ANL) DATA SCIENTIST (SCI) DEVELOPER (DVL) 2022. Scorecards, dashboards, and reports can be explored and delivered on desktop, the Web, mobile devices, and the Cloud. evt. MicroStrategy’s semantic graph is built on data abstraction, which decreases your enterprise’s data complexity with a consolidated. It gives you the leverage of generating real-time reports and monitoring data. BI reporting is involved with helping the end-users visualize data, analyze it, gain new insights to make informed and data-driven business decisions. Enter project name and choose runtime module version 2. If you are using the MicroStrategy Tutorial project and its sample data, log in to the Tutorial project. Hi experts, we are planning to convert existing BO 4. . A project is the highest-level of intersection of a. In its most basic form it consists of two parts: A report template (usually simply called a template), which is the underlying structure of the report. View changes and push updates to end users in seconds. Intermediate. Its core analytic pr. · How to professionally and effectively. It also has features to create complex features, which willLooker is a tool that creates SQL queries and passes them against a database connection. The latest information on the data including the addition of new objects, modifications can automatically be derived from the warehouse directly. MicroStrategy 10 is an optimized easy-to-use analytics platform that consolidates analytics, mobility, and security in a single integrated platform and delivers dashboards and compelling visualizations to enable data driven decision making to organizations and end-users through the AWS market place. MicroStrategy: Tool Description: It is a data visualization tool: It is much more than just data visualization and offers a complete package for enterprise analytics. Make sure to select the correct DSN for the text file. Founded in 1989 by Michael J. Drag and drop the attribute Category from the Object Browser into the Report View: 'Local Template' section to break the report into pages. Data Warehouse Tutorial Summary. The ACL you define here is applied as the default ACL for the project and all of the objects within the project, excluding the objects mentioned in the following option. Automation Testing is a software testing technique that performs using special automated testing software tools to execute a test case suite. Financial Services, 201-500 employees. . Power BI desktop is the primary authoring and publishing tool for Power BI. MicroStrategy Tutorial Reporting is a sample MicroStrategy project with a warehouse, and a set of demonstration dossiers, reports, and other objects, designed to illustrate the platform's rich functionality. MicroStrategy Creating Filters - Filtering data is a very important part of data analysis and visualization. Machinery, 5,001-10,000 employees. 1 WEBI reports to microstrategy reporting tool. Executes the report services document specified by the documentID argument. In MicroStrategy Web, log in to the Tutorial project. See how MicroStrategy changes the way people work through Analytics, Mobility, and HyperIntelligence. The three parts into which this comprehensive Microstrategy Interview Questions blog is divided are as follows: 1. For an introduction to prompts, how prompts save the report designer time, and how prompts work with MicroStrategy security filters, see the. Combined Reports − These reports can show the combination of both the Grid. EN. 旧バージョン（9. VLDB Properties. Cognos BI offers real-time events, alerts, and notifications. Here is a demo (using MicroStrategy Tutorial): Image the possibilities! If a client has a BI tool that wants to migrate to MicroStrategy, this could be used as a conversion tool and save hundreds. Description: Alteryx is a self-service data analytics software company that specializes in data preparation and data blending. Access – LifeTime Download. In save MicroStrategy (MSTR) tutorial, ourselves will learn Which is MicroStrategy, What to position it, show, architecture, visage, advantages, & applications. MicroStrategyの各マニュアルは、以下のページをご覧ください。. MicroStrategy comes with a sample project called MicroStrategy Tutorial. BIRT (Business Intelligence and Reporting Tools) can pull data from many different sources including databases, Web services, and Java objects to create a report. Use ODBC Test Tool to test connectivity to the Statistics database: Assuming that the DSN is correctly configured to connect to the Statistics database, try connecting to the Statistics database using ODBC Test Tool from the Intelligence Server machine. If you want to see the Microsoft Access database, it is located within the Tutorial Reporting folder (in Windows C:Program Files (x86)MicroStrategyTutorial Reporting) with the name TUTORIAL_DATA_7200. Professional Summary. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. (Note: Target runtime should default to Apache. With the diverse range of courses, Training M. 3. It also provides many examples using the sample Tutorial project that comes with MicroStrategy. A MicroStrategy tutorial can help professionals build the skills to use business intelligence tools effectively. To get the report objects of a report, open the report and click the. It gives you an opportunity to familiarize yourself with the Web interface and learn some basic functionality. 2. KB20124: Best practices to migrate cubes (SAP BW, MSAS or Essbase) and cube objects (attributes) using MicroStrategy Objec… Number of Views 2. xlsx as an example data set. API Management and Testing. MicroStrategy Architect is a project design tool. Non-administrative users can only view and use the objects from the public folder, but they cannot delete or create new objects under the public folder. In this MicroStrategy (MSTR) tutorial, are become students What is MicroStrategy, Select to install it, history, architecture, features, advantages, & applications. Introduction to Dossiers. Empower branch managers and advisors with the tools to power growth. 2 Get the project to enter in at. AnsweringQuestionsaboutData 111 Filteringdata 112 Understandinghierarchies 117 Designing Reports, guides you through advanced reporting concepts in a hands-on way, providing a tutorial experience. Verified reviewer. The fuel for business dashboards is data, so each one needs to have one or more data sources. Moreover, MicroStrategy Developer is a simple, but expansive tool geared towards MicroStrategy Administrators and. The default behavior if a report is exported from MicroStrategy Web is to name each Excel. On the contrary, Manual Testing is performed by a human sitting in front of a computer carefully executing the test steps. Right-click in an empty area on the right side of. MicroStrategy Tutorial ️What exists MicroStrategy ️Data Uncovering ️Architecture ️Installation Guide ️Features and continue. MicroStrategy 9, MicroStrategy Distribution Services, MicroStrategy MultiSource Option, MicroStrategy Command Manager, MicroStrategy Enterprise Manager, MicroStrategy Object Manager, MicroStrategy Reporting Suite, MicroStrategy Power User, MicroStrategy Analyst, MicroStrategy Consumer, In this MicroStrategy (MSTR) tutorial, we will learned Something is MicroStrategy, Like to install it, history, architektonischer, features, pros, & applications. BI products can now seamlessly generate regular reports for internal stakeholders,. Following are the three report types used in MicroStrategy Desktop. In this MicroStrategy tutorial you will learn MicroStrategy from the basics to help you learn this top Business Intelligence tool. In MicroStrategy Developer, choose File > New > Report. It is recommended that, if you plan to try the Tutorial - Delivery sample project to learn about Narrowcast Server, you perform theScalable MicroStrategy was a helpful tool for providing daily, monthly, and quarterly reporting due to the ability to build automated reports that can be sent to large groups of people using distribution lists. In this MicroStrategy (MSTR) tutorial, we will learn What is MicroStrategy, Wie up install it, history, architecture, traits, advantages, & applications. The MicroStrategy Tutorial is a MicroStrategy project, which includes a warehouse, and a set of demonstration applications designed to illustrate the platform’s rich functionality. This course is $44. To Create a Report from Scratch. # Create a new User Group. From the list of document templates, click Blank Document. MicroStrategy Web is an interactive, easy to use interface for all Business Intelligence (BI) reporting, analysis, and monitoring. Finally, This Dossier makes our analytics powerful. This course covers advance topics like Data Marts, Data Lakes, Schemas amongst others. Click any of the documents listed on the right side of MicroStrategy Web, to execute it and see the results. The goal is to derive profitable insights from the data. . The course introduces the many features that enable you to create sophisticated, boardroom-quality documents. Bounce to content. For steps, see Starting MicroStrategy Web. Because the ID of the event associated with the "RW Fast Export PDF" page is "3069", the evt parameter in the URL is set to "3069". A cloud-native, open architecture platform, it is built on a scalable, future-fit semantic layer designed to inject AI-powered Intelligence Everywhere™. Data Mining is a process of finding potentially useful patterns from huge data sets. x. See screenshot below for an example. They can take input data from sensors, CRM systems, web traffic, and more to measure KPIs. True responsive designs. Open the project and add a new folder called “ Reports . MicroStrategy is usable in both forms, web and desktop tools, whereas Cognos is a web-based reporting tool mechanism. | Meet MicroStrategy AI on the road. On the toolbar, click the drop-down arrow on the Create a New Object icon, and select the type of object to create. MicroStrategy Desktop provides a variety of options to filter data in a report. 38K KB441856: In MicroStrategy 10. To access the public folder, login to MicroStrategy developer as administrator and go to option Public Objects. MicroStrategy Creating Filters - Filtering data is a very important part of data analysis and visualization. Click Shared Reports. ”. In MicroStrategy Developer, choose File > New > Report. 40. Hive. MicroStrategy tutorial curriculum. MicroStrategy offers one of the most comprehensive ABI platforms, supporting both Mode 1 and Mode 2 analytic and reporting requirements. So is there any way to migrate those reports to MicroStrategy directly or just if I can migrate the dimensions and measures created in SAP BO to Attributes and metrics in MicroStrategy. Skip for content. security features to allow the report to be. Tekslate’s MicroStrategy training will make you an expert in creating reports and dashboards using the Microstrategy BI tool. 9、MicroStrategy Distribution Services、MicroStrategy MultiSource Option、MicroStrategy Command Manager、MicroStrategy Enterprise Manager、MicroStrategy Object Manager、MicroStrategy Reporting Suite. The MicroStrategy Tutorial Reporting metadata is provided as part of the MicroStrategy Analytics Module metadata. Click within the Dataset Objects area to add datasets for the document. Select the metadata databases that contain the source project. MicroStrategy’s gateways span more than 99% of the data ecosystem your organization has, and MicroStrategy is always committed to expanding these gateways to meet—or exceed— your enterprise data needs. The broad range of features is beneficial to users since it does not require advanced. · How to use all the main visualizations. The default folder is: C:Program Files (x86)MicroStrategyProduct Name when installed on a 64-bit Windows environment. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. Click the MicroStrategy icon and select Create Report. Grid Reports − These reports display only textual information in the form of grids showing rows and columns of data. With IBM acquiring DataStage in 2005, it was renamed to IBM WebSphere DataStage and later to IBM InfoSphere. 👉SV Tech Hub - Online global training platform connecting individuals with the best trainers around the globe. A prompt is a question the system presents to a user when a report is executed. x and 10. Familiarize yourself with data science tools, such as Jupyter Notebook and mstrio-py. Generally, a report designer places various MicroStrategy objects such as filters. 9、MicroStrategy Distribution Services、MicroStrategy MultiSource Option、MicroStrategy Command Manager、MicroStrategy Enterprise Manager、MicroStrategy Object Manager、MicroStrategy Reporting Suite. It helps in analyzing the relationship between a given dimension and all the remaining variables of the data set. Click any of the documents listed on the right side of MicroStrategy Web, to execute it and see the results. Microstrategy Interview Questions MICROSTRATEGY REPORTING SUIT - MicroStrategy Reporting Suite is a free, commercial reporting tool for developing and delivering operational and analytical reports. ,data from multiple SOR sources in the organization helped in monitoring our SLA management. Set Freeform SQL and MDX objects default security. 2. Visit the data visualization and data dashboard galleries for inspiration. Platform Analytics is the next-generation monitoring tool that captures platform data (also known as telemetry) from your MicroStrategy environments in real-time, and uses this data to enable a smarter administration and to provide a better experience to your MicroStrategy users. Community. The REST API is designed to help developers build data-driven client applications quickly. Privileges are given on a per-user basis, some of which are also per-Application. Combined Reports − These reports can show the combination of both the Grid. 最新の日本語版が提供されていない場合. Sample URLs for exporting a Report Services document to PDF are shown below. x, MDMover should be used to migrate the Metadata database between database server. As part off these MicroStrategy tutorial you will learn whereby to get started with MicroStrategy reporting, how to start which MicroStrategy Desktop, go the MicroStrategy Web, opening a tell, building von one report, row and columns, grids and graphs, OLAP services and more. MicroStrategy Developer is the business intelligence software component that provides integrated monitoring, reporting, powerful analytics, and decision support workflow on an intuitive Windows-based interface. 10. As member of this MicroStrategy tutorial you will lern how to acquire started with MicroStrategy reporting, how to start who MicroStrategy Desktop, starting the MicroStrategy Web, opening a report, components of a report, set and columns, grids and graphing, OLAP offices and more. Enter the Intelligence Server address (IP or FQDN): Enter the port that the Intelligence Server service is running on. One of the most popular MicroStrategy courses on Udemy is this Business Intelligence with MicroStrategy 10 Analytics course. MicroStrategy has a metadata-driven architecture. Without data, the dashboard will not show the user anything. Another benefit is the consistency of information and calculations. 2. IBM’s Cognos BI is a web-based reporting and analytics tool. Also you will learn how to get data from Excel, create various types of visualization available and convey the right message . MicroStrategy Web is a user-friendly environment for interactive analysis. How data is stored and managed for exploration by the BI and Analytics platform. All articles. On the windows machine, open the start menu and select Programs > MicroStrategy Tools > Cube Advisor. 2 Click the project to log in to. MicroStrategy is a Business Intelligence(BI) and On-line Analytical Processing (OLAP) software which allows reporting and analysis of data from a variety of sources, including data warehouses, Excel files, and. Data Warehouse is a collection of software tool that help analyze large volumes of disparate data. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Interact with the engaged MicroStrategy. Note: In order to avoid any unpredictable behavior, it is highly recommended that users not use the Microsoft ODBC Data Source Administrator for creating DSNs for the MicroStrategy drivers. Developer enables you to model applications using an intuitive, graphical interface. Now in this Power BI desktop tutorial, we will learn about types of Power BI tools. - Head of BI Department, Major Retailer in FranceTypes of Power BI tools. Data Warehouse Tutorial Summary. Presented during MicroStrategy World 2021, hear best practices and tools and tips for connecting to SAP. An object is a basic building block in MicroStrategy. AboutMDXCubeSourcesinMicroStrategy 4 UnderstandingMicroStrategyArchitecture 6 RelatingObjectsfromMDXCubeSourcestoMicroStrategy 10 ConnectingtoMDXCubeSources 43The Python script below can be used for such an automation. MicroStrategy Workstation radically simplifies enterprise analytics by bringing all key workflows into a single user experience. It will enable you to gain in-depth knowledge on MicroStrategy architecture, designing schema objects using MicroStrategy web and desktop, scorecards, etc. Our analytics and mobility platform transforms data into actionable insights that help people make better business decisions. src. Open Table. Course Categories.