IS_CUBE_INST_ID. Save the Report and close. KB224157: How to Get the Intelligent Cube Status Using MicroStrategy Web SDK. Create a report based off the cube in Step 1 that includes the description form for Category. delete one relation as the following Then click "Save" to go back to the cube editor, click the "Update Dataset" button in the bottom right corner. 1, Data Import allows users to maintain intelligent cubes from external Excel files. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. All necessary privileges are included in the Administrator role by default. Edit Intelligent Cubes from the new editor in Workstation at any time. The user continues to use the report that accesses the Intelligent Cube. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. 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. By default, Intelligent Cubes created through Data Import are saved to the MicroStrategy user's "My Reports" folder. Republish the Intelligent Cube or re-create a report cache, which will be shared with MicroStrategy Technical Support; Send the requested data to MicroStrategy Technical Support; Revert the metric definition back to the original one, or remove the randomized metric from the report (Intelligent Cube configuration is not relevant in MicroStrategy 8. A document is used to format data from multiple datasets in a single display of presentation quality. STEPS TO REPRODUCE 1. Set the number of partitions equal to the number of CPU cores in MicroStrategy Intelligence Server host computer. The Intelligent Cube Monitor is displayed. Create an Intelligent cube with Month and Revenue. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. Create a Data Import Live Intelligent Cube. CAUSE: Starting in MicroStrategy 9. IS_CUBE_ACT_ID. The default value is 256 megabytes. x as Administrator; create a simple Intelligent Cube called Q, and publish it. As shown in the screenshot above, only one cube cache can be loaded in RAM. For the example scenario, log in to the MicroStrategy Tutorial project. microstrategy. The New Intelligent Cube dialog box opens. Both MicroStrategy Developer and MicroStrategy Web have the ability to incrementally fetch element rows from Intelligence Server. x-10. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. In the left pane, click Intelligent Cubes. Expand Intelligent Cubes, and then select General. To Create an Intelligent Cube Using Freeform SQL or Query Builder. STEPS TO REPRODUCE. 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. This can improve the performance of. Log into ProjectA in MicroStrategy Web. 2. The. You can also create an Intelligent Cube that contains data from an MDX cube integrated into MicroStrategy from an MDX source such as SAP BW, Hyperion Essbase, or Microsoft Analysis Services. The MicroStrategy SDK allows you to customize several MicroStrategy products and extend and integrate the MicroStrategy business intelligence functionality into other applications. This issue occurs if the cube that are created with less Attribute Forms as the Element prompt with the same Attribute. KB30711: Security filter application to view reports based on Intelligent Cubes. It is especially useful when data. 2. The "LP" status of an Intelligent Cube in the Cube Monitor in MicroStrategy Developer stands for "Load Pending". Click Databases . Web object search—this enables the user to see the “User Manager” button on the Intelligence Server Administration page. This issue has been classified as a defect by MicroStrategy. 4. Run a Command Manager script to delete the cube cache previously deleted in step 2. Hover the schedule need to be modified,. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. The following procedure describes how to add or create a prompt in a cube report in MicroStrategy Developer. This command will deactivate the Intelligent Cube cache so reports from this Intelligent Cube will not be able to run while it is being re-published. x, when there are multiple fact tables available to perform the fact extension, different fact table are used by the analytical engine for the fact extension in Connect Live and In-Memory Intelligent Cube. The visualization data changes when the Data Access mode of an Intelligent Cube is changed from In-Memory to Live mode. This article describes how to update information in an Intelligent Cube without having to do a full republishUsing Web, create an Intelligent Cube with Add External Data> Databases > Select Tables option and add 1 table Order_Detail using a "Live" connection. KB30711: Security filter application to view reports based on Intelligent Cubes. Create Schema Objects. This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. To publish an Intelligent Cube, see. Ensure that the email addresses can be displayed properly. Follow below steps to achieve that : Create Elements Prompt and add them into Report coming from Intelligent Cube. This KB article shows sample code to get the intelligent cube status programmatically with Web SDK. You can use an Intelligent Cube as a dataset, allowing you to use one Intelligent Cube for many different documents, while reducing access to the data warehouse. Cube Advisor opens. In the Object name field, type a descriptive name for the Intelligent Cube. 9K KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. STEPS TO REPRODUCE Use Data Import to bring in an Excel file containing a few columns (i. All necessary privileges are included in the Administrator role by default. The Subscribe to Cube /Cache Update dialog box opens. 2. Shut down Intelligent Server node A with command . MicroStrategy Intelligent Cube Technology™ allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. Follow the steps below using the MicroStrategy Tutorial project: 1. The Browse for Folder dialog box opens. This property can only be enabled through Workstation. 1. 3. When an OLAP report is created from an Intelligent Cube, some users may have difficulty adding prompt objects to that report. Click an MDX cube source. Select Empty. Select "Add External Data" and connect to an OLAP data source with the Live Connect option. The dataset is a set of data that can be displayed on the document. To make the Intelligent Cube available to be reported on, you must publish the Intelligent Cube. Defining the partition for Super Cubes. x releases, and the new Multi-table Data Import (MTDI) cubes. GUID: is the GUID of the intelligent cube, returned as a string. /mstrctl -s IntelligenceServer. 4. You can use the Import Data feature in MicroStrategy Web to import data from sources such as Microsoft Excel spreadsheets, comma-separated text files, and external databases into your project. The cube now has Year and Category on it. Configure and start the Intelligence Server using the metadata backup. Sharing data. 1. Create an attribute element prompt for the Year attribute. For the example scenario, create a report with Year, Region, and Profit Margin on the report. This can affect performance of your Intelligence Server as well as the ability to publish the. Import “QTR_CATEGORY_SLS” and “LU_QUARTER” Table from the Tutorial warehouse. Click Create on any page, point to New Report, and select Blank Report. Create an intelligent cube with Category, Subcategory and Year in rows and Revenue and Cost in columns. How to build and manage Intelligent Cubes. For the Intelligent Cube that you want to refresh, click the subscription icon. Community & Support Search Discussions Open A Case View My CasesThis defect is addressed in MicroStrategy 11. STEPS TO REPRODUCE: 1. If you've already got a report that you want to create an Intelligent Cube out of, you simply go to. 3. jar file to i-server machine. x-10. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. 1 or MicroStrategy Web 9. Right-click the dataset, and choose Schedule. PRIME stands for Parallel Relational In-Memory Engine, and it engulfs two types of in-memory cubes: OLAP cubes, or the traditional Intelligent Cubes that have existed since 9. MicroStrategy Web is a browser-based client interface that enables IT to satisfy the diverse analytics needs of every enterprise user—consumers, analysts, data scientists, developers, and administrators—without the burden of distributing and maintaining multiple software packages. Select the data sources to be refreshed. 0. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. 2. Create 3 aggregate from base metrics as follows:In MicroStrategy Workstation, right click on any cube created via Data Import and select Properties. They should have the “A, L, F” status (Active, Loaded, Filed). The status of each Intelligent Cube is listed in the. To Schedule a Cube Refresh. Intelligent Cubes. Stop the Intelligence Server service of one node of the cluster (in this example, node 2 called “sup-w-006660”). 2. 38K. Workaround 2: Create a non-Kerberos authenticated database login. 1. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. x Intelligent Cube status indication and workflow To create an attribute form caching cube. Connection mapping can then be used to map the desired MicroStrategy users to this database login. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library;. x, users will notice that this is not possible due to the mouse. These VLDB properties control the method by which the report data are normalized. x, create a simple Intelligent Cube with attribute Category and metric Revenue. Web modify the list of report objects (use object browser --all objects) Web Professional. Create Cube A and a report based on it. In Developer, log in to a project with a user account with administrative privileges. At this point, the Month attribute can be removed from the cube to reduce the publication time and size of the Intelligent Cube within memory. To schedule updates for an Intelligent Cube, first click the “Data Import” button to bring up the list of existing Data Import Cubes. Intelligent cube is an OLAP feature introduced in Microstrategy 9 version. Node 1. Browse to an Intelligent Cube, select it, and then click OK. In MicroStrategy Developer create an Intelligent Cube with any attributes and metrics. From the cube monitor, we could see the. Login to MicroStrategy Web, create a cube with the function of Data Import 2. STEPS TO REPRODUCE: 1) Add external dataset. In MicroStrategy 9. We can create a report and point the report to a cube or right click. In MicroStrategy 10. In the Data Source column, select the checkboxes for the tables to update. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. A list of data sources available in this project appear. This determines the approach to existing data at refresh. 4. Easily add or change pre- and post- SQL statements. Why MicroStrategy Why MicroStrategy; Customer StoriesBelow is an example of a script that can be used to execute the event "Run Reports" after Intelligent Cube "Year Revenue Cube" has published. Check the location of the new cube cache and notice that it is saved in the default location, i. 3. Publish the cube. Visualizations in the dossier that use data from the cube display. The Browse for Folder dialog box opens. 4. Supports derived metric creation. Quickly integrating data into MicroStrategy as part of a proof-of-concept. Login MicroStrategy Web as M20061, go to Add External Data -> Databases -> Select Tables, pick the following tablesFollow these steps to reproduce the issue in a MicroStrategy Tutorial Project. Section 5: Load Intelligent Cube files into the Intelligence Server. In the left panel, click Cubes. The Report Editor opens with all of the objects of the Intelligent Cube. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. Node 2. In MicroStrategy Web 9. 2 release, the driver file is called odbc8. Before MicroStrategy 10. 3. Select or clear the Load Intelligent cubes on startup check box to enable or disable loading Intelligent Cubes when Intelligence Server starts. Integrity Manager can test the SQL of Intelligent Cubes even if they. Share query results in-memory across multiple dossiers and. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data. This allows for more power and control over data for MicroStrategy users: Leverage data-base specific optimizations. In the Navigation pane, click , next to Datasets. Intelligent Cubes are multi-dimensional cubes (sets of data) that allow you to use OLAP Services features on reports, as well as share sets of data among multiple reports. To review and create recommended Intelligent Cubes using Cube Advisor. In the Navigation pane, click , next to Datasets. If. Browse to an Intelligent Cube, select it, and then click OK. This is an identified defect in Visual Insight in MicroStrategy Web 10. This data is stored as Intelligent Cubes. Right-click your selection and select Group. How to configure, monitor, and manage Intelligent Cubes. 3. This procedure assumes that the Linux machines are called UNIX1 and UNIX2. 11. 4. 3. 1. Navigate to the folder location of the Intelligent Cube. Create an Intelligent Cube with attributes Year, Month and Region; 4. Create a report off the Cube with Category, and Region attributes and Revenue metric on. For background. Contact the MicroStrategy Technical Support for an update on this enhancement request. The first step in analyzing the performance of Intelligent Cube Publication is to look at the post-execution SQL view of the initially published Intelligent Cube and understanding the breakdown. The New Intelligent Cube dialog box opens. 4. Set the path for the cube cache file directory to . Click the MicroStrategy icon, and select Create Report. For example, you can choose to add or delete data from the Intelligent Cube. Introduction: Need to create a report with a metric that calculates the number of distinct customers. The Subscribe to Cube /Cache Update dialog box opens. Create an attribute element prompt of Month, and use above filter in "Use a filter to reduce the number of elements", as below picture shown: 3. You can modify the derived element using the Derived Elements Editor (see Using the Derived Elements Editor ). The Select Intelligent Cube dialog box opens. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. Create and publish Intelligent cube called “Cube2” on node B. 3. Click OK. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. There is another reason that the intelligent cube is imported from a local file in the web server machine, and the Web server and the Intelligence Server do not need to be on the same machine. This provides ROLAP-type analysis without having to re-execute against the data warehouse. * Web define Intelligent Cube report: create a report that uses an Intelligent Cube as a data source: WEBDEFINEVIEWREPORT. x - 9. Save as an In-Memory dataset. 4. “Intelligent Cube (<Cube Name>) for locale. Full Refresh. 6. MicroStrategy Web is a browser-based client interface that enables IT to satisfy the diverse analytics needs of every enterprise user—consumers, analysts, data scientists, developers, and administrators—without the burden of distributing and maintaining multiple software packages. In MicroStrategy 9. For Oracle 12. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. Add External Data. Description. 4 the connection mapping of the user account which published the cube are created and database connections are listed in the Intelligent Cube Monitor in Developer. In MicroStrategy Web, edit the Cube where users want to enable partitioning. 2. The group is created as a derived element and displayed on the report. You can use the ACL Editor in -MicroStrategy Web to assign the following permission groups to users, for each Intelligent Cube: Group. When an Intelligent Cube is in this status, any reports based on this cube have. All reports that access Intelligent Cubes allow you to drill within the data included in an Intelligent Cube. The steps below show you how to create an Intelligent Cube based on an MDX cube. Create an Intelligent Cube with attribute Region and metrics, Revenue and Revenue Forecast; Create a subset report based on the above Intelligent Cube; Insert a derived metric DM = Revenue Forecast/Revenue as seen below: Execute the report either in MicroStrategy Desktop 9. The New Grid dialog box opens. Web Analyst. However, the metric must display in the area of subtotal, the total number of customers inserted into the data warehouse, not the sum of. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. g. When attempting to add a prompt directly to an Intelligent Cube in MicroStrategy Developer 9. 4 the connection mapping of the u… Number of Views 1. On the Freeform Sources tab, select one of the following options: To. This name change is visible in MicroStrategy Workstation and MicroStrategy Web. Steps to Reproduce. Create. 1, Data Import allows users to maintain intelligent cubes from external Excel files. Importing MDX cubes is often handled by a MicroStrategy architect. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. Purpose of the registry key. The Intelligent Cube Editor uses the new Modeling service infrastructure. Export to MicroStrategy File. Create a new variable and assign SuperCube with two parameters inside – connection and id. Typically, a long duration is seen in the Data Transfer time which indicates the time it takes to fetch data from the warehouse. In MicroStrategy, users can trace MicroStrategy Intelligent Cube activity via the Cube Server Trace which can be enabled through MicroStrategy Diagnositcs Configuration as seen below: The following section displays excerpt from the Cube Server trace when different actions are performed on the MicroStrategy Intelligent Cube. Right-click the Intelligent Cube, and select Define Incremental Refresh Report. com Format: A MicroStrategy Online. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. Web modify the list of report objects (use object browser --all objects) Web Professional. Create a report not based on the Intelligent Cube with Year, Quarter, and Revenue . 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. This is the same requirement to create or run a static report in Workstation. In the Dynamic Sourcing area, use the Make Intelligent Cubes available for. For instructions on configuring MDX sources, refer to the MDX Cube Reporting Guide. Create an attribute element prompt for the. Create a report services document or Visual Insight Analysis. This permission is checked at design time, and when executing reports against an Intelligent Cube. Quickly integrating data into MicroStrategy as part of a proof-of-concept. Steps to reproduce. From the File menu, select Create Test. Navigate to the Intelligent Cube for which you want to define the incremental refresh. STEPS TO REPRODUCE: 1. In MicroStrategy 2020 Update 2, the size of the Intelligent Cube keeps gradually increasing even after setting the Maximum % growth of Intelligent Cube to 50%. A set of data is returned from the. 86K KB31566: MicroStrategy 9. A warning message is displayed for any mismatch in data between the report and the Intelligent Cube you want to link the report to. Select the "ORDER_FACT" table. Integrity Manager can test the SQL of Intelligent Cubes even if they. Right-click your selection and select Group. HIDDEN: if the intelligent cube is hidden or not, returned as a boolean value. The data used for this example is from a SQL Server 2014 version of the MicroStrategy Tutorial database. To create an Intelligent Cube using the Freeform SQL Editor, select Use Freeform. 1. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. By default, there is a system hierarchy on the cube. Create a standalone Derived metric DM : Create a new Intelligent Cube C01: Add the Quarter, Country, and Region attributes. /ClusterCube. To set refresh filters, or alternate data sources, select Show Advanced Options. Open the report or Grid/Graph (the example scenario uses a report connected to an Intelligent Cube), as follows: To access the Derived Elements Editor for a report connected to an Intelligent Cube: Execute the report. Type a name for the derived element, and click OK. In MicroStrategy Web 9. Import MicroStrategy File. If you are upgrading to MicroStrategy 11. 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. At this time, only one table per cube is supported. Search for prompt answer in report based on Intelligent Cube returns no results on selected ID form in MicroStrategy Web 9. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. Edit Intelligent Cubes from the new editor in Workstation at any time. 4. A possible cause of this issue is that the folder that stores the Intelligent Cube files on the node where the Intelligent Cube is published is not shared with the name 'ClusterCube' on the MicroStrategy Intelligence Server machine(s). Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a great. 438832. The Intelligent Cube opens in the Report Editor. The Intelligent Cube Editor uses the new Modeling service infrastructure. Add DM. The History List folder is displayed, with a list of dossiers, documents, reports, and Intelligent Cubes that have been added to the History List. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. You can edit project-level cache and Intelligent Cube settings. In MicroStrategy Web 10. If you want to create an empty SuperCube, use SuperCube. Run both reports after enabling the metric levels log. STEPS TO REPRODUCE. Start > All Programs > MicroStrategy Products > Integrity Manager. 2. 10, when the "Defect fixes may impact Data, SQL, MDX, CSI" is turned to "On" under Web preferences > Project Default, thresholds for derived metric cannot be properly applied if the condition is based on a cube base attribute. KB441696: Cannot Add Prompts into View Filter of Cube Based Report in MicroStrategy Web. Save the Cube with Connect Live Data Access Mode. How to Import Data from a SAP HANA Database Into MicroStrategy Web. The old cube files don't have this property, so new IDs will be generated every. Dynamic sourcing makes Intelligent Cubes more accessible by allowing regular reports to automatically access published Intelligent Cubes that can satisfy the data requirements of the report. The personal Intelligent Cube is similar to the report cache; however, it acts as a layer between the report cache and the report itself. Navigate to the folder location of the Intelligent Cube. The create_cube() function will return the datasetID and tableID, which can be used to update a dataset with new data. Normalize Intelligent Cube data in the Database 4. Answer: When attempting to add a prompt directly to an Intelligent Cube in MicroStrategy Developer 9. Afterwards the cube will start executing. To accomplish this, the first step is to turn ON this feature by selecting "Create Intelligent Cubes by database connection" in the Project Configuration editor (screenshot below). Reports/Documents not created from Intelligent Cube but meet dynamic sourcing requirements: Additional "Use OLAP services" and "Use Dynamic Sourcing" are required for a user to hit an Intelligent Cube, besides the privileges. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. Refer to the tech note below for more information: KB32502 - Support for transformation metrics for Dynamic Sourcing in MicroStrategy OLAP ServicesIn MicroStrategy Web click Create -> Add External Data -> File from disk; Select the Excel file saved in Documents; Prepare data (Note: Change the data type of “AttributeID” to text) Right click the first attribute "AttributeID" and select "Map to Project Attribute" Search for “AttributeID” in the search bar and hit enter. Create a report with the year and quarter attributes and the profit metric. This " How to" knowledge base article explains cube advisor. 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. HyperIntelligence for Web. The Schedule dialog box opens for your dataset, showing the tables in your dataset. Now, create an hierarchy prompt but before saving , save/overwrite them on top of “Qualification Prompt” that is being used in the Cube – ensure, the hierarchy objects exists within cube. It involves only fetching a portion of the data that the user wants, instead of storing all data in-memory as a normal Intelligent Cube. It retrieves report results from a schema source and stores it in memory. In a clustered MicroStrategy Intelligence Server Universal compounded by two nodes Node A and Node B, a cube test cube is published on Node A and its status can be seen in Administration >> System Monitors >> Caches >> Intelligent Cubes:To view an Intelligent Cube stored in your History List. 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. Do not normalize Intelligent Cube data. Create two Intelligent Cube Reports: C01 and C02 in the MicroStrategy Tutorial project. However, before changing the way MicroStrategy products look or behave, it is helpful to understand how the application is built. However, before changing the way MicroStrategy products look or behave, it is helpful to understand how the application is built. In MicroStrategy Developer, log in to a project source with administrative privileges. 3. Restoring cube files. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. 4. For example, an Intelligent Cube includes Year and Quarter. Add ORDER_DETAIL (this tables comes with MicroStrategy Tutorial WH) and click Prepare Data. IS_CUBE_REP_ID. 3) Select the LU_YEAR table from the Tutorial database instance and then select "Connect. The CREATE and INSERT support VLDB property defines whether MicroStrategy can perform CREATE and INSERT statements against the database for a database instance. Follow the steps below using the MicroStrategy Tutorial project: 1. Create a new Dossier. Click OK. Select Intelligent Cubes > General > Intelligent Cube File directory. Create a metric that returns a transformation of last year's. When an Intelligent Cube is published, the Intelligent. KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. 0. x: Create a new Intelligent Cube with Attributes Category, Subcategory and Metric Revenue. Also enable feature flag called "Always calculate Derived Attribute at source for Connect Live Intelligent Cubes Datasets". In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit.