In the Refresh Policy column, choose one of the following options:MicroStrategy 2021 Update 3 fixes two workflows related to Security Filter used in Data Import Intelligent cube (aka Super Cube). 0 MicroStrategy releases. ¶. Defining the partition for Super Cubes. Administer Cubes. The dataset is a set of data that can be displayed on the document. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. You can use Integrity Manager to perform a before and after test to identify which reports actually connect to a suggested Intelligent Cube and also to test data integrity. grouping attributes MicroStrategy Cloud Creating attributes on dossiers Filtering reports, metrics, and attribute groups Filtering dossiers Improving performance with intelligent cubes Preparing complex data for enhanced storytelling Visualizing, filtering, and linking your data Designing documents Building enterprise mobile applications Go to Data -> Configure Intelligent Cube -> General and set both "Make Intelligent Cube available for Dynamic Sourcing" and "Allow Dynamic Sourcing even if Outer Join properties are not set" to ‘Enabled‘. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a red "X" as shown below: However, the images in the report display properly when the report is executed in. The Schedule dialog box opens for your dataset, showing the tables in your dataset. Con: The copy of report data in Intelligence Server memory only applies to a single report. For detail information regarding dynamic sourcing for incrementally refreshed Intelligent Cubes, refer to MicroStrategy 10. The following project governing settings are being retired beginning with MicroStrategy 2020 Update 1. Sharing data. This provides ROLAP-type analysis without having to re-execute against the data warehouse. Reports include Freeform SQL reports, Query Builder reports, MDX cube reports, and reports that access Intelligent Cubes. You can assign related privileges to different user groups on Developer or Web to perform specific tasks. After you have created your Intelligent Cube, you can publish its set of data to be shared by multiple reports. Using MicroStrategy Developer, log in to a project connected to an MDX cube source. Introduction to visual insight microstrategy visual. An Intelligent Cube is a set of data that can be shared as a single in-memory copy among many different reports created by multiple users. It manages high performance interactions involving terabytes of data and tens of thousands of users by leveraging in-memory intelligent cubes, caching, load balancing, resource prioritization, and connection pooling. The governor should be increased to 100GB (to ensure no cube will be swapped out) and you should flush the OS cache frequently. Attributes in the security filter are related to attributes in the Intelligent Cube: No data is returned, to maintain data access security. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. Par défaut, elle est définie sur 32 000. OLAP (In-Memory, Intelligent Cube) MTDI (In-Memory) MTDI (Live Connect) Data Retrieval. Backup frequency (minutes): controls the frequency (in minutes) at which cache, History List messages, and Intelligent Cubes are backed up to disk. From the Partition Attribute drop-down, select the partition attribute for the Intelligent Cube. The Full Refresh option is the default. KB485673: When "Create Intelligent Cubes by database connection" is enabled, the cube published with the latest data can't… Number of Views 157 KB484562: Intelligence Cubes are not published via subscriptions to both nodes of cluster in MicroStrategy 2019 and later. For example, an Intelligent Cube includes the attributes Year and Region, and the metric Revenue. 6, the MicroStrategy PDF Exporter (also known as New Export Engine or NEE) service has been added to support exporting from. Description: Intelligent Cube design and utilization; how to build cubes. In MicroStrategy Developer, browse to an Intelligent Cube. Rather than returning data from the data warehouse for a single report, Intelligent Cubes return sets of data from the data warehouse and saves. Set the number of partitions equal to the number of CPU cores in MicroStrategy Intelligence Server host computer. The ability to view or edit certain settings is determined by a user's privileges. blogspot. Create a Report 'R3' with 'Country' attribute. Since Intelligent Cubes function simply as a set of data, Intelligent Cubes do not need to contain objects that modify the display of data. Publish, unpublish, delete, and update Intelligent Cubes. Create the MIN (CurrentDateTime ()) metric. OLAP cubes make it easy to answer additional questions that will drive strategy with near-instant analysis of large amounts of data. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. 81K. You can update and modify the document in Design View. Intelligent Cubes allow multiple reports to retrieve data from a single shared in-memory set of data. The New Intelligent Cube dialog box opens. Create Cube2 with the Region attribute and the metric created in step 1. From the Data menu, select Configure Intelligent Cube. The New Grid dialog box opens. A document that uses the Intelligent Cube as a dataset. For this reason, it is important to govern how much Intelligent Cube data can be stored on Intelligence Server. The SQL Engine matches a view report, or a report that uses dynamic sourcing, with the corresponding Intelligent Cube. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. Edit the Cube2 , in the Cube editor > Data > Configure Intelligent Cube > Data Partition > Partition Attribute = Region and Number of Partitions = 12. Select the Intelligent Cubes tab. The cube population process could be expensive in time and memory if the cube is large. In a clustered environment, each node in a cluster must share its result caches and intelligent cubes with the other nodes, so all clustered machines have the latest cache information. In MicroStrategy 9. xA report that runs against the Intelligent Cube. Sie können Daten für Ihren Intelligent Cube hinzufügen, indem Sie Objekte wie Attribute, Metriken, Filter usw. If you are upgrading to MicroStrategy 11. This article describes features that are not supported when using Dynamic Sourcing. Localizing Intelligent Cubes in multiple languages. It uses Business Scenarios to provide examples of each concept. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a red "X" as shown below: However, the images in the report display properly when the report is. In this case, the dataset is a MicroStrategy Intelligent Cube. Name the different export. 4. Report is not able to use an Intelligent Cube created with freeform SQL using Dynamic Sourcing in MicroStrategy 9. Right-click the project and select Project Configuration. If you are upgrading to MicroStrategy 11. Users may need to delete several certain rows of data from an intelligence cube, but it is not possible to do so for a cube created by data import on MicroStrategy Web 10. Together with the Reports API, this API is often referred to as the JSON Data API. 15K. . 1, Windows 2003 and UNIX. This property can only be enabled through Workstation. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. Select data population for Intelligent Cubes. An Intelligent Cube is a set of data that can be shared as a single in-memory copy among many different reports created by multiple users. Select an Environment from the upper-left drop-down. You can add data for your Intelligent. MicroStrategy 9. The blog series consists of four blog posts: Unlocking Data Value #1: SAP BTP Data and Analytics overview: Learn about our objectives, SAP products, and real. KB255633. However, users may notice that there is nowhere to specify notifications through the scheduled refresh interface in MicroStrategy Web. Creating Intelligent Cubes The Freeform SQL Editor and the Query Builder Editor provide alternative methods to create reports in MicroStrategy. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. x releases, and the new Multi-table Data Import (MTDI) cubes. Right-click the Intelligent Cube to store in secondary storage and select Save to Disk. Drag and drop the objects into the report grid from the Report Objects pane. In the grid display of the report, press the CTRL key and select multiple attribute elements within the same attribute. In the left panel, click Cubes. Email subscriptions deliver a report or document to one or more email addresses. Server Logout. 0. /ClusterCube. Subsequently the requests made by other users can. Security filters apply to all reports, however, and there is no guarantee that every Intelligent Cube will include security filtering attributes. MicroStrategy’s in-memory cube technology has been generally referred to as PRIME cubes since 10. Created narrowcast services to email /send to a directory either report service documents in PDF or excel files. AboutMicroStrategyOLAPServices 6 OLAPServicesfeatures 7 ThebenefitsofusingOLAPServices 11 PrivilegesrequiredforDeveloperandWebusers 12 Reporttypes. txt file. The initial size of the Intelligent Cube is 11G and can grow to a maximum of 32G while the Maximum % growth of the Intelligent Cube is 50%. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a red "X" as shown below: However, the images in the report display properly when the report is. The Intelligent Cube refresh settings change the way the Intelligent Cube is updated when you re-execute it manually, or when it is published on a schedule, as described in Publishing Intelligent Cubes using a schedule. Before MicroStrategy 10. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. By choosing Automatic, if the largest table is >= 1M rows, MicroStrategy will choose the attribute. Right-click the report and select Edit. Currently, project duplication does not involve Intelligent Cube File Directory. On the Freeform Sources tab, select one of the following options: To create an Intelligent Cube by creating SQL statements using the Freeform SQL Editor. For more information on cache encryption, review the following article: KB31094: New feature in MicroStrategy Intelligence Server 9. The Intelligence Server brings the live-connect intelligent cube definition from the metadata and analyzes the information requested from that definition. 2. . LIST ALL INTELLIGENT CUBES IN FOLDER "Intelligent Cubes" FOR PROJECT "MicroStrategy Tutorial"; ResultSet Columns. A document is used to format data from multiple datasets in a single display of presentation quality. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. 6, users now have the option to select MSTR as the Delivery format for email and file subscriptions as shown below: MicroStrategy Intelligence Server. The Data Partition options are displayed. Create Cube1 with the Region attribute and the metric created in step 1. If the welcome page is shown, review the information and click Next. MicroStrategy will continue to investigate and post updates as soon as they are. 54K KB31040: How to enable font size smaller than. This is due to the fact that adding prompts to Intelligent Cubes is not supported. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. These VLDB properties control the method by which the report data are normalized. 1 and 10. 0: Balance MicroStrategy Server threadsReporting on an Intelligent Cube provides quick access to data, as the data has been pre-aggregated. The Cube API supports DDA cubes and MDX cubes, in addition to Intelligent cubes. Expand Intelligent Cubes, and then select General. MicroStrategy Intelligent Cube Technology allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. The Platform Analytics project comes with three Intelligence Cubes that support nine Dossiers that can be run right after installation to check if everything is functioning properly. Once an Intelligent Cube is stored in Intelligence Server memory, multiple reports can be created to view and analyze the set of published data. Expand Intelligent Cubes, and then select General. Intelligent Cubes are part of the OLAP Services feature in Intelligence Server. In-Memory Intelligent Cube: The request is received by the. 1 and 10. With MicroStrategy OLAP Services, transformation metrics used in standard reports can resolve against Intelligent Cubes under the following conditions: A metric with the same formula and transformation exists in the Intelligent Cube. The personal Intelligent Cube is similar to the report cache; however, it acts as a layer between the report cache and the report itself. Browse to and select a previously saved Intelligent Cube on which to build your report. From the Administration menu, point to Scheduling, and then select Subscription Creation Wizard. Choose File > New > Intelligent Cube. By default, the Partition Attribute pull-down menu is set to Automatic, which allows MicroStrategy Web to set the number of partitions. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a red "X". To review and create recommended Intelligent Cubes using Cube Advisor. Same datasets available for MicroStrategy and TableauCan also be leverage in other analytic applications like SAS and RNo 2 billion row limit. Reports that connect to Intelligent Cubes adhere to many of the same standards of data access security as the rest of your MicroStrategy project. Publish Intelligent Cube statement. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. However, the images in the report display properly when the report is executed in. Notice that "Project" and "Intelligent Cubes" results are blank: CAUSE: This is a known issue in MicroStrategy 10. For more information on how to integrate with Oracle OLAP cubes contact MicroStrategy Consulting. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Select a schedule from the Schedule drop-down list. Microstrategy's Visual Insight is used as a self service tool replacing Pivot tables & graph building in Excel. Download the attached PDF for an in-depth understanding of Object Migration best practices. Cube Advisor opens. Improved cube index memory management and governing using the "Maximum % growth of an Intelligent Cube due to indexes" project configuration setting. To Create a Report that Accesses an Intelligent Cube. The "LP" status of an Intelligent Cube in the Cube Monitor in MicroStrategy Developer stands for "Load Pending". PATH: The path to the Intelligent Cube, returned as a string. 5 GB, the Data Transfer from Datasource(s) time is 77. Under VLDB settings > Query Optimizations > Data Population for Intelligent Cubes admins need to test all the following options: - Normalize Intelligent Cube data in the database. When the subscription has been configured, click. INTELLIGENT_CUBE_FILE_DIR: The path to the disk storage of unloaded Intelligent Cubes, returned as a string. School NIT Rourkela; Course Title DATA ANALYSIS 102; Uploaded By DeanElectronHummingbird14. Comparing OLAP and MTDI cubes. This command will list the table information only when the intelligent cube is a super cube. 0 has a dedicated section to memory used for Intelligent Cubes. Right-click an Intelligent Cube and select Delete. 0. In MicroStrategy, you can also use connection mapping to control the data that users have access to when they run reports. For additional information on how Data Scientists and users of other analytics tools can use MicroStrategy, visit the MicroStrategy Community. Intelligence Server Statistics . Learning Resources. Explain an Intelligent Cube? Instead of returning data from the data warehouse for a single report ,we can return sets of data from our data warehouse and save them directly to Microstrategy. Intelligent Cube data can also be stored in secondary storage, such as a hard disk, on the machine hosting Intelligence Server. x CAUSE: The user is missing the "Administer Subscriptions" privilege under "Administration" in. Cube and Cache Metric Names. Using OLAP Services, you can perform the same multidimensional analysis whether you use MicroStrategy Developer, Office, or Web. 4. The objects in the source cubes will control how the security filter will be applied. Within the Microstrategy platform, the logic to match user requests with the proper intelligent cube is automatically handled. To that end, we’ve designed a program of continuous training and certification for every role in your Intelligent Enterprise. Integrity Manager can test the SQL of Intelligent Cubes even if they have not been published, but cannot test Intelligent Cube reports based on an unpublished Intelligent Cube. For more information on the Intelligent Cube Maximum. In MicroStrategy Developer, browse to an Intelligent Cube. The following project governing settings are being retired beginning with MicroStrategy 2020 Update 1. An Enhancement Request for implementing this functionality is. 40. Published: Nov 19, 2018; Last updated: Nov 18, 2022;MicroStrategy version 9. In HTML View and PDF View, a dashboard is displayed as a static document. 6. You need the Use Intelligent Cube Editor privilege to create Intelligent Cubes. Sharing Sets of Data Among Reports: Intelligent Cubes describes the role of OLAP Services in the overall MicroStrategy architecture and how you can take advantage of Intelligent. This is because with this feature enabled, the element block ID will be saved to the new cube cache. 3. Starting in MicroStrategy 2021 Update 5, you can create Intelligent cubes. Create an Intelligent cube with Year, Quarter, and Revenue with MicroStrategy Tutorial data. Edit Project-Level Cache and Intelligent Cube Settings. The general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. Save the workflow in . 3. An Intelligent Cube is. The Datasets API family allows developers to push external data directly to the MicroStrategy Intelligence Server. For detailed information about Intelligent Cubes, see the In-memory Analytics Help. Both products' features range. Intelligent cubes are generated automatically when a new report is run against the data warehouse. KB441285: Optimization for the Intelligent Cube Data Structure at the time of publication. To create an Intelligent Cube using the Freeform SQL Editor, select Use Freeform. To create an Intelligent Cube based on MDX data in Developer, open the File menu, select New, and select Intelligent Cube. Every time that a user does something in MicroStrategy, like. You need the Use Intelligent Cube Editor privilege to create Intelligent Cubes. Create a filter that qualifies on Quarter and set Quarter = Q2 2011 (or any quarter available). From the Data menu, select Configure Intelligent Cube. Publish the Cube, and create the following Dossier:. 0, you have the option to use Data Import to create an in-memory dataset (sometimes referred to as an super cube) containing data from multiple tables. 0. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a red "X" as shown below: However, the images in the report display properly when the report is. Please contact MicroStrategy Technical Support for an update on this issue. . Watch on. Publishing Intelligent Cubes. Right-click an Intelligent Cube and select Delete. Right-click an Intelligent Cube and select Delete. For example, you can create a card based on an Intelligent, in-memory MTDI, or an in-memory MDX/SAP cube. Whenever a report executes against a data warehouse and returns a new set of data, a personal Intelligent Cube is created automatically. Intelligent Cubes. "Maintaining data access security. Personal Intelligent Cubes are linked to a single report: Pro: The report can use OLAP Services to analyze report data and is always updated with the latest version of the personal Intelligent Cube. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. These restrictions are applied automatically when creating prompts. User specifies the definition of the cube on a Report Template with Attributes, Metrics, and Filter. Intelligent Cubes are part of the OLAP Services add-on to Intelligence Server. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a red "X" as shown below: However, the images in the report display properly when the report is. KB36744: How to restrict a user or user group to build and edit reports only on Intelligent Cubes in version 9. Visit the data visualization and data dashboard galleries for inspiration. The Intelligent Cube Options dialog box opens. To schedule an Intelligent Cube to be updated. Intelligent Cubes can be based on MicroStrategy data or imported data. The Intelligent Cube Monitor is displayed. Intelligent Cubes are multi-dimensional cubes on a BI platform, having two unique methods to implement. For example, analysts can export interactive dashboards and reports to PDF format, allowing executives to access and review critical information without needing direct access to the BI platform. Reporting on Intelligent Cubes also allows you to use all of the OLAP Services features, including derived elements, which allow you to group attribute elements in a report on. The related section is located in. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Click Select. This file stores cache matching. Easily add or change pre- and post- SQL statements. * Details on 2 possible causes for connectivity issues preventing the publication of Platform Analytics Intelligent Cubes. Check the location of the new cube cache and notice that it is saved in the default location, i. Provides the last cube row count. To test the new batch file, the user can execute the batch file by entering its file location in the command line as shown below. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. From the Edit menu, select Training Metric Wizard. Cache Lookup Cleanup Frequency (Sec) The Cache lookup cleanup frequency (sec) setting determines how frequently the CacheLkUp. Personal Intelligent Cubes are linked to a single report: Pro: The report can use OLAP Services to analyze report data and is always updated with the latest version of the personal Intelligent Cube. Learning Resources. To use a personal Intelligent Cube, you can begin by creating reports in MicroStrategy as usual, and then analyze your reports with OLAP Services features such as view filters, derived metrics, and. To schedule an Intelligent Cube to be updated. In MicroStrategy Developer, locate the Intelligent Cube that needs to be refreshed. You can create Intelligent Cubes with data from an MDX data source, such as SAP BW, Hyperion Essbase, or Microsoft Analysis Services. 4. MicroStrategy Intelligent Cube Technology allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. You must publish an Intelligent Cube to make it available for multiple reports to access and report on its set of data. To schedule updates for an Intelligent Cube, first click the “Data Import” button to bring up the list of existing Data Import Cubes. The Subscription Creation Wizard opens. Beginning in MicroStrategy 10. als Berichtsobjekte oder Berichtsfilter einschließen. 0 and later enhances the scalability and manageability of OLAP Services with the addition of sharable Intelligent Cubes. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. 1 and 10. 1 and 10. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. Define the values for the following project governing options: Maximum RAM usage (MBytes): Defines the data size, in megabytes, to limit the amount of Intelligent Cube data that can be stored in Intelligence Server memory for a project at one time. However, Intelligent cube publishing performance may be affected with the agent enabled. All necessary privileges are included in the Administrator role by default. This template includes the following tasks: Creates a new metadata. 10. Export to CSV, Export to PDF, etc). If your MicroStrategy project supports the localization of information into multiple languages, you can also support this localization to provide Intelligent Cubes in multiple languages. x. 4,. Right-click the Intelligent Cube to store in secondary storage and select Save to Disk. To support this configuration, you must ensure that the Intelligence Server host machine uses values greater than or equal to the resource limits described below. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. Click All Objects View. Click OK. The following table summarizes the test results of some test scenarios against Oracle 19c. If you use Enterprise Manager (EM),. To enable. On MicroStrategy's business intelligence platform, you have two unique methods to implement Intelligent Cube Technology: Personal Intelligent Cubes: A personal. x clustered environments. Number of Views 1. A report accessing the Intelligent Cube includes only Year on the report. KB440617: Considerations for using security filters when sharing data import cubes in MicroStrategy. The following diagram depicts the role of the intelligent cube. Add data from existing reports, documents, and Intelligent Cubes. The benefits from using Dynamic Sourcing are: Better performance for all kinds of reports. idx file is cleaned up. In MicroStrategy 10. Save the file in . Published: 4월 6, 2017. For more information on cube partitioning, download this PDF. 7 or later, non-distributive metrics do not return correct data because the Engine does double aggregation due to the optimization done in DE81833. With OLAP Services features, your report designers can create Intelligent Cube reports. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. Ab MicroStrategy 2021 Update 5 können Sie Intelligent Cubes erstellen. A user creates a report that connects to this Intelligent Cube, and includes Year and Revenue on the report. Navigate to the folder location of the Intelligent Cube. Chapter 7: Improving Performance with Intelligent Cubes Chapter 8: Preparing Complex Data for Enhanced Storytelling Chapter 9: Creating Workflows for Efficient. View reports vs Cubes as datasetsTo unpublish an Intelligent Cube. 438832. File subscriptions save the report or document as an Excel or PDF file to a disk location on the network. In the left pane, click Intelligent Cubes. 1 and 10. The Export Engine formats a report or document for export as a PDF, Excel workbook, or XML. Since Intelligent Cubes function simply as a set of data, Intelligent Cubes do not need to contain objects that modify the display of data. Right-click the Intelligent Cube, point to Schedule Delivery To, and then select Update Cube. This can be seen in the screenshot below. MicroStrategy - Intelligent Cubes - Online Training Video by MicroRooster. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and then select Intelligent Cubes. This property can only be enabled through Workstation. This is the most popular MicroStrategy Interview Question asked in an interview. Use MicroStrategy Developer, Office, or Web. Intelligent Cubes erstellen. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. Vn (with metric Mn from source cube Cn). and background information on Intelligent Cubes is in the MicroStrategy In-memory Analytics Help. Features: MicroStrategy and Tableau are two unique tools that offer incredible features. 1 and 10. For detailed information about Intelligent Cubes, see the In-memory Analytics Help. By choosing Automatic, if the largest table is >= 1M rows, MicroStrategy will choose the attribute. Number of Views 1. Datasets API. Save the Report and close. An Intelligent Cube is an In-Memory data structure which. 1 and 10. MicroStrategy Intelligence Server . Intelligent Cubes can be partitioned,. Intelligent Cubes are multi-dimensional cubes (sets of data) that can be shared as a single in-memory copy among many different report created by multiple users. Loading. KB35540: How to publish Intelligent Cubes sequentially using MicroStrategy Command Manager version 10. 2 that allows the user to execute in a sequential order different Intelligent Cube Reports. The Intelligent Cube “xxx” for locale <German (Germany)>has not been published. Exporting a document or report to PDF, plain text, Excel spreadsheet, or XML . 1.