Click Create on any folder page, point to New Report, and select Intelligent Cube Report. Stop the Intelligence Server service of one node of the cluster (in this example, node 2 called “sup-w-006660”). 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. 4. Choose Databases. Choose File > New > Intelligent Cube. Click Intelligent Cube Report. For prior releases, either a cube was loaded, residing completely in RAM, or unloaded. The main thing to keep in mind is that the A,F size is the I-servers best guess as to what the size in-memory will be once it is loadedConsider the following example based on the MicroStrategy Tutorial project. Then click "Save". 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. Configure and start the Intelligence Server using the metadata backup. Integrity Manager can test the SQL of Intelligent Cubes even if they. 4 the connection mapping of the u… Number of Views 1. 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. 5. 3. Click OK. Incremental Refresh Options, General: Use these options to define the behavior of the incremental refresh. Select the data sources to be refreshed. Once this privilege is enabled, the Intelligence Server Administration screen looks like the following: With only these three privileges, a user is able to access the User Manager in Web. 4. Select other schedule options as required, and click OK. To Create a Report that Accesses an Intelligent Cube. 2. 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. Go to MicroStrategy Web 10. Steps to activate CSI Log in Windows: Open the MicroStrategy Diagnostics and Performance Logging Tool. The Intelligent Cube is shared as a single in-memory copy, among the different reports created by many users. Select the "ORDER_FACT" table. From the cube monitor, we could see the. The data used for this example is from a SQL Server 2014 version of the MicroStrategy Tutorial database. To make the Intelligent Cube available for creating reports, publish the Intelligent Cube by choosing Run Report in the toolbar. To Schedule a Cube Refresh. Choose File > New > Intelligent Cube. You can also create Intelligent Cubes by directly querying your data. CSI after fix:The following steps explain how to share a MicroStrategy Intelligent Cube with users between different connections: In MicroStrategy Desktop, open Project Configuration window for a project, uncheck the option "Create Intelligent Cubes by database connection" under Intelligent Cubes > General, as shown below: Restart. CAUSE: This is working as designed. Node 1. 3. RMC on attribute Warranty to Create Attribute named ‘IsWarranty’ with the formula of “IsWarranty: Case(([Warranty]@[DESC]="No"), 0, 1)” as shown below:To update the newly created Super Cube, create a new script starting from repeating steps 3-7. If the Intelligent Cube must be re-processed based on a metric. e. This is set to 32,000 by default. 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. Click All Objects View. The partition attribute is the attribute that is used to divide. For steps to use an existing template to. In MicroStrategy 10. Data access security is maintained. Business users might not want MicroStrategy to build any M:M Relationship tables while publishing the Intelligent Cube In-Memory due to the following reasons: 1) It distorts the actual relationship between a tuple of 3 or more attributes related to each other through M:M relationship in Project Schema by creating individual tables and joining. 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). Complete the "sessionState" field (e. Open the report in Grid View, Design View, or Grid and Graph view. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. This will influence the user experience. First, you open a blank document and select a report to use as the document's dataset. In MicroStrategy Web 9. To schedule updates for an Intelligent Cube, first click the “Data Import” button to bring up the list of existing Data Import Cubes. 2. Visualizations in the dossier that use data from the cube display. Creating Intelligent Cubes is as easy as creating reports. 10 example shows how you can: Generate Auth Token and create an Intelligent Cube containing data. 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. Enable "Create Intelligent Cubes by database connection" (need to reload the project to make it work). 4. At least one MDX cube must be imported into your MicroStrategy project. For steps to create an Intelligent Cube report, refer to the OLAP Services Guide. Create a new report based on the published Intelligent Cubes that are supposed to be made available to your designers. Create a user (tester) and disable the "web publish Intelligence Cube" privileges under Web Analyst. Easily add or change pre- and post- SQL statements. x, create a simple Intelligent Cube with attribute Category and metric Revenue. To add an existing report or Intelligent Cube as a dataset. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. Open the Workstation window. In MicroStrategy Developer, select the Empty Attribute Form Caching Intelligent Cube template when creating a new Intelligent cube. Create an Intelligent Cube with attributes Year, Month and Region; 4. You can use the ACL Editor in -MicroStrategy Web to assign the following permission groups to users, for each Intelligent Cube: Group. x. It does not tell us anything helpful and we should not use it as a point of reference. Assuming that ProjectA and ProjectB are in the same metadata, create a Database Instance to connect to an OLAP data source. In MicroStrategy Web 10, during Data Import, users are able to choose "Connect Live" data sources, which is also known as "Direct Data Access" function, as shown below:. Call this 'Base Report'. In MicroStrategy 11. The visualization data changes when the Data Access mode of an Intelligent Cube is changed from In-Memory to Live mode. Click a catalog. The Modeling service must be configured correctly to use this feature. To Create a Report from Scratch. The default value is 256 megabytes. Community & Support Search Discussions Open A Case View My CasesThis defect is addressed in 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. Modify the list of Report objects (use object browser). However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. The Modeling service must be configured correctly to use this feature. A report accessing the Intelligent Cube includes only Year on the report. Disconnect from the project source and restart both Intelligence servers. Both MicroStrategy Developer and MicroStrategy Web have the ability to incrementally fetch element rows from Intelligence Server. Node 1. MicroStrategy Intelligent Cube Technology™ allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. 2 in Web, navigate to the report in edit mode, right click “customer” and insert metric Count as shown below: 3. PUBLISH INTELLIGENT CUBE "<cube_name>" IN FOLDER "<location_path>" FOR PROJECT "<project_name>"; 8. This is an identified defect in Visual Insight in MicroStrategy Web 10. 1Currently it is not possible to create a cube refresh subscription in Command Manager. Execute. 9 and 10. The view filter cannot filter out other elements as shown below:Use Cube Advisor to create Intelligent Cubes: 1. Designing and creating documents: An overview. Open the. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. Click the “Add history list subscription” link near the bottom of the screen to open the. Whenever a report executes against a data warehouse and returns a new set of data, a personal Intelligent Cube is created automatically. 4. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. At least one MDX cube must be imported into your MicroStrategy project. If. Web Analyst. Integrity Manager can test the SQL of Intelligent Cubes even if they. Create an Intelligent cube with Month and Revenue. Create a filter that qualifies on Quarter and set Quarter = Q2 2011 (or any quarter available). 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. You'll need to provide a name for your cube, as well as a name for the table that will contain the data. Answer: Intelligent Cubes can be created in microstrategy in public objects folder or in a particular user folder. Follow the steps below using the MicroStrategy Tutorial project: 1. This technical note describes a known issue when creating a data import cube in MicroStrategy Web 10. Import “QTR_CATEGORY_SLS” and “LU_QUARTER” Table from the Tutorial warehouse. 2. Login MicroStrategy Web as M20061, go to Add External Data -> Databases -> Select Tables, pick the following tables Follow these steps to reproduce the issue in a MicroStrategy Tutorial Project. Select a schedule from the Schedule drop-down list. HyperIntelligence for Web. The "LP" status of an Intelligent Cube in the Cube Monitor in MicroStrategy Developer stands for "Load Pending". 2 attributes and 1 metric). MicroStrategy Web also uses the history list from Intelligence Server. Right-click the dataset, and choose Schedule. Unable to create Derived Elements in a Report Services document with a dataset that is not based on an Intelligent Cube in MicroStrategy Developer 9. You need the. Create a report off the Cube with Category, and Region attributes and Revenue metric on. 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. com Format: A MicroStrategy Online. The. This KB article shows sample code to get the intelligent cube status programmatically with Web SDK. Prerequisites. IS_CUBE_ACT_ID. In order to set up an incremental refresh report, the user should first right click on the Intelligent Cube and select "Define Incremental Refresh Report":After each unload/reload, and running the Dossiers against the cube, the duplicate Element Block files will be dumped into the same *****_objects folder. In MicroStrategy Developer, select the Empty Attribute Form Caching Intelligent Cube template when creating a new Intelligent cube. Check the location of the new cube cache and notice that it is saved in the default location, i. MicroStrategy Tutorial is used in this example. This chapter provides information on how to deploy and configure MicroStrategy Web and Web Universal on Windows and Linux platforms with various Web and application servers. For steps to use the Derived Elements Editor to create derived elements in MicroStrategy Web, see the MicroStrategy Web Help. From the File menu, select New, and then select Intelligent Cube. 0, the only way to create an intelligent cube (also known as an ROLAP cube or an OLAP cube) was from a report (which is a single table dataset). When an Intelligent Cube is published, the description information for the attributes (all data mapped to non-ID attribute forms) included on the Intelligent Cube is repeated for every row. To Create a Report that Accesses an Intelligent Cube. This issue occurs if the cube that are created with less Attribute Forms as the Element prompt with the same Attribute. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. In this case, the dataset is a MicroStrategy Intelligent Cube. In MicroStrategy Developer, browse to an Intelligent Cube. KB224157: How to Get the Intelligent Cube Status Using MicroStrategy Web SDK. Click the “Add history list subscription” link near the bottom of the screen to open the. Select Intelligent Cubes > General > Intelligent Cube File directory. However, importing data from a Google Drive Spreadsheet requires some additional setup. microstrategy. Right-click an application and choose Properties. In MicroStrategy Web, edit the Cube where users want to enable partitioning. Web publish Intelligent Cube. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. The MicroStrategy SDK allows you to customize several MicroStrategy products and extend and integrate the MicroStrategy business intelligence functionality into other applications. This is an identified defect in Visual Insight in MicroStrategy Web 10. To view an existing cube, you must have the following minimal privileges: Use analytics. Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user. x. A page with report creation options is displayed. You can also select an existing template on which to build your new report. For more details on Intelligent Cube size increase, refer to the following technical note: KB33449: Intelligent Cube size increases over time in the MicroStrategy. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. KB30696: Overview of security filter application to view reports based on Intelligent Cubes in MicroStrategy OLAP Services . Make sure the service is properly configured and running before using the Intelligent Cube Editor. 2. To solve this problem, we introduce a new registry key, " Respect. Set the path for the cube cache file directory to . 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. 11. In MicroStrategy Developer, log in to a project that contains reports connected to active Intelligent Cubes. In Windows choose Start > Programs > MicroStrategy Tools > Cube Advisor. Navigate to the folder location of the Intelligent Cube. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. Browse to an Intelligent Cube, select it, and then click OK. Description. 0 MicroStrategy releases. Remove the prompt from the Base Report and save it as Intelligent Cube. In MicroStrategy Web browse to the Cube location and click on the cube . 11. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. A document is used to format data from multiple datasets in a single display of presentation quality. KB485159: Enable support for Security Filter with Top and Bottom Range Attributes in Data Import Intelligent cubes and Fix the security hole in Connect Live Data Import Intelligent cubes MicroStrategy 2021 Update 3 fixes two workflows related to Security Filter used in Data Import Intelligent cube (aka Super Cube). Delete the cube cache from cube monitor. In the Name field, type the name of the subscription. 1 or above, to pick up the fix, enable project level setting "Data Engine Version" to 11. You must belong to the System Administrators group to use this feature. Complex metrics here refer to metrics which are defined using multiple. 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. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. The Full Refresh option is the default. 1. 1. The History List folder is displayed, with a list of dossiers, documents, reports, and Intelligent Cubes that have been added to the History List. The "Email" column cannot be found in. Check the status of the cubes in Developer. This property can only be enabled through Workstation. 4. Some uses for this data include: •. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. For steps to create an Intelligent Cube report, refer to the OLAP Services Guide . Rather than returning data from the data warehouse for a. In MicroStrategy Web 9. In the Grid/Graph, you can use MicroStrategy Web to create a threshold to change the formatting of the revenue amounts when the profit is greater than a specified amount. Log in to the project in which you want to create a report. 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. Create Schema Objects. This allows for more power and control over data for MicroStrategy users: Leverage data-base specific optimizations. 38K. Navigate to the Intelligent Cube for which you want to define the incremental refresh. 4 the connection mapping of the u… Number of Views 1. Importing MDX cubes is often handled by a MicroStrategy architect. Visit the data visualization and data dashboard galleries for inspiration. Stop the. When an OLAP report is created from an Intelligent Cube, some users may have difficulty adding prompt objects to that report. The following procedure will make cube data accessible to view reports. Choose File > New > Report. Defining the partition for Super Cubes. You need the Use Intelligent Cube. From the Report Selection panel, go to the File menu > Open. Add the report as the dataset for the Dashboard by. Create a new variable and assign SuperCube with two parameters inside – connection and id. STEPS TO REPRODUCE. GUID of the Intelligent Cube instance in memory. 3 - Check the Make Intelligent. In the Navigation pane, click Applications. x, sharing of Intelligent Cube data files is configured similarly. Run a dossier based on the cube. Select the refresh policy. “Intelligent Cube (<Cube Name>) for locale. Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user experience and report performance. Setting Up Documents and HTML Documents: This chapter explains the setup required for the Intelligence Server to create and execute HTML documents and documents. This property can only be enabled through Workstation. 2. After saving the log destination, the File Log column should now read as "CSI" for the Engine Component. On MicroStrategy's business intelligence platform, you have two unique methods to implement Intelligent Cube Technology: Personal Intelligent Cubes: A personal Intelligent. All necessary privileges are included in the Administrator role by default. Save as an In-Memory dataset. 0. ACTION:The procedure below provides steps to create a subscription to schedule the publication of an Intelligent Cube. Personal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. g. Con: The copy of report data in Intelligence Server memory only applies to a single report. PublishCube". The Schedule dialog box opens for your dataset, showing the tables in your dataset. The Subscribe to Cube /Cache Update dialog box opens. If you select Cube B, any dashboards or reports linked to Cube A before the merge may not function correctly. CAUSE: The report on which the action is being performed is a "Standard" report, only OLAP reports can be pointed to Intelligent Cubes. Intelligent Cube IC2 contains attributes 'Country' and 'Region' Create a report services document with the above 2 Intelligent Cubes as datasets. Set the number of partitions equal to the number of CPU cores in MicroStrategy Intelligence Server host computer. x - 10. after executing the Login task), and type the GUID of the. STEPS TO REPRODUCE Use Data Import to bring in an Excel file containing a few columns (i. To Schedule a Cube Refresh. Note that the cube has a neutral data language. Supports derived metric creation. Expand Intelligent Cubes, and then select General. Kickstart Your Career Get. For: "Import data from file or database before using in a Visual Insight analysis", which makes the source an Intelligent Cube, a Web Professional license is required. Notice the attribute forms in the Report Objects pane. The Intelligent Cube Editor uses the new Modeling service infrastructure. It also. 2. 4. Login Web with Administrator, Create a VI Dashboard based on this cube. In certain situations users may want to configure success and failure notifications for the scheduled refreshes of Intelligent Cubes that are created through Data Import in MicroStrategy Web. 2. A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. IS_CUBE_REP_ID. Edit Project-Level Cache and Intelligent Cube Settings. Workaround 2: Create a non-Kerberos authenticated database login. For example, if a user has an Intelligent Cube that contains weekly sales data, the user may want this Intelligent Cube to be updated at the end of every week with the sales data for that week. Execute reports or documents that reference the object. Choose File > New > Intelligent Cube. Faster performance than directly querying warehouse. KB228850: How to migrate published intelligent cubes to a different environment in MicroStrategy Intelligence Server 9. x-10. 4. Personal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. From the Data menu, select Add Dataset. It is very simple to create an intelligent cube, it is same like. In the left panel, click Cubes. Create a report based off the cube in Step 1 that includes the description form for Category. Description. In MicroStrategy Developer, locate the Intelligent Cube that needs to be refreshed. 4. This is the same requirement to create or run a static report in Workstation. 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. How to build and manage Intelligent Cubes. Create an MDX Cube ReportThe option to point a grid to an Intelligent Cube appears disabled, while other options such as "Convert Grid to Intelligent Cube" appear available. Type a name for the derived element, and click OK. This can be seen in the screenshot below. Create a report based on above Cube and add the prompt in view filter. Report Post SQL Statement. How to publish Intelligent Cubes using Task Administrator in MicroStrategy Web. Select the Intelligent Cubes tab. Create Intelligent Cube report with derived metric and derived element as shown below: Create a document with this cube report as dataset. All reports that access Intelligent Cubes allow you to drill within the data included in an Intelligent Cube. They are. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. IS_PROJ_ID. KB441696: Cannot Add Prompts into View Filter of Cube Based Report in MicroStrategy Web. Introduction: Need to create a report with a metric that calculates the number of distinct customers. Click OK to save the Intelligent Cube and return to the Report Editor. First, you open a blank document and select a report to use as the document's dataset. Open the Workstation window. Shut down Intelligent Server node A with command . Purpose of the registry key. The Modeling service must be configured correctly to use this feature. Add Project objects from the All Objects panel. Save the cube, and run it to publish. Under Refresh type, select one of the following options. The Intelligent Cube Monitor is displayed. Create Intelligent Cubes. More than one cube can be used in a single dashboard. 2. You can also modify the properties of. Use the drop-down under the filter summary section to switch the server nodes. INTELLIGENT_CUBE_TYPE: is the type of the intelligent cube, returned as a string value. You must publish an Intelligent Cube to make it available for multiple reports to access and report on its set of data. Create Schema Objects. You can use the ACL Editor in -MicroStrategy Web to assign the following permission groups to users, for each Intelligent Cube: Group. This is because with this feature enabled, the element block ID will be saved to the new cube cache. Create a new File Log and name it “CSI” (or any other name). For Intelligent Cubes that are frequently used, it may be easier to send a URL to users to develop the report object that already contains a cube. Run report off cube. Add Year Id and Quarter. 38K. You must complete a few prerequisites before using Cube Advisor to recommend and create Intelligent Cubes to support a dynamic sourcing strategy. When an Intelligent Cube is published, the Intelligent. Using MicroStrategy Developer, log in to a project connected to an MDX cube source. The following procedure describes how to add or create a prompt in a cube report in MicroStrategy Developer. PUBLISH INTELLIGENT CUBE "C02" IN FOLDER "Public ObjectsReportsSequential Cube Execution" FOR PROJECT "MicroStrategy Tutorial"; The previous commands can be saved in a. 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. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data imported. Sharing data. 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. Afterwards the cube will start executing. 4. Create a report not based on the Intelligent Cube with Year, Quarter, and Revenue . For a MicroStrategy environment configured to use Database level security using MSTR connection mapping, Intelligent Cubes can still be utilized. To publish your cube, see the In-Memory Analytics Help. Other metadata database platforms:Login Developer with Administrator, create a cube and publish it. Create 3 aggregate from base metrics as follows:In MicroStrategy Workstation, right click on any cube created via Data Import and select Properties. Complete the "sessionState" field (e. x, Report Service Document appears to show Null/Empty value for Row Count metric when using Live Connect Intelligent Cube. In the Intelligent Cube Editor, choose Data > Configure Intelligent Cube… In the Intelligent Cube Options dialog box, expand Options and select Data Partition. 1. From the Data menu, point to Intelligent Cube Options, and select Convert to Intelligent Cube. With OLAP Services features, your report designers can create Intelligent Cube reports. After you have created your Intelligent Cube, you can publish its set of data to be shared by multiple reports. Memory mapped files (MMF) can be used for effective RAM utilization. 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. Users can create a Report Post SQL Statement within the Intelligent Cube that updates the value of a flag in the warehouse table. In MicroStrategy 9. Export to MicroStrategy File. 6. Restoring cube files. Create an attribute element prompt for the Year attribute. On the Home screen, select My Subscription. The impact is limited to MicroStrategy Developer 9.