2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. In MicroStrategy Developer, from the File menu, point to New, and then select Intelligent. The Browse for Folder dialog box opens. The differences between the options. This issue has been classified as a defect by MicroStrategy. x - 9. 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. This technical note describes a known issue when creating a data import cube in MicroStrategy Web 10. For steps to create an Intelligent Cube report, refer to the OLAP Services Guide. Create a new in-memory dataset with the create_dataset() function. 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%. For more information regarding the MicroStrategy products or the process of customizing MicroStrategy products, please refer to MicroStrategy Developer Zone (article describes how to provide Intelligent Cube cache files to MicroStrategy for troubleshooting cases. 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‘. Create a report based on the Intelligent Cube with Year, Quarter, and Revenue. Since Web distributes connections between Intelligence Servers. Ensure that the email addresses can be displayed properly. It retrieves report results from a schema source and stores it in memory. 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. 4. Run the Report and check the SQL View. The display of data is handled by the reports that access the Intelligent Cube. 4 the connection mapping of the u… Number of Views 1. Navigate to the folder location of the Intelligent Cube. 4. The group is created as a derived element and displayed on the report. To subscribe a report or document to a cube refresh. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. For steps to use an existing template to. However, importing data from a Google Drive Spreadsheet requires some additional setup. Create a metric that returns a transformation of last year's. The History List folder is displayed, with a list of dossiers, documents, reports, and Intelligent Cubes that have been added to the History List. x, users will notice that this is not possible due to the mouse pointer changing into a "not allowed" symbol. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. No additional resources are needed to modify the Intelligent Cube or to create a new report. This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. Select the data set and click Prepare Data. 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. In the Dynamic Sourcing area, use the Make Intelligent Cubes available for. The default value is 256 megabytes. 2 attributes and 1 metric). To make the Intelligent Cube available to be reported on, you must publish the Intelligent Cube. When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. access the MicroStrategy Web Administrator page and assign Project defaults: WEBADMIN: Privileges marked with * are included only if you have OLAP Services installed as part of the Intelligence Server. It's basically just a report, and can even start it's life off as a report. 3. Create 3 aggregate from base metrics as follows:In MicroStrategy Workstation, right click on any cube created via Data Import and select Properties. 1. If you are upgrading to MicroStrategy 11. The New Intelligent Cube dialog box opens. Start > All Programs > MicroStrategy Products > Integrity Manager. The act of publishing an Intelligent Cube can require memory resources approximately two times greater than the size of an Intelligent Cube. Right-click your selection and select Group. “Intelligent Cube (<Cube Name>) for locale. com. 11. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. and select the Project-Name. Add Project objects from the All Objects panel. The Modeling service must be configured correctly to use this feature. ACTION:In the Navigation pane, click Monitors. Log into the three-tier project source and choose the project that was analyzed in stage 2. Save as an In-Memory dataset. 3. Use Intelligent Cube Editor. In Developer, log into a project. From the File menu, select Create Test. Click Databases . 0, to pick up the feature, enable project level setting "Data Engine Version" to 11. Check in Developer that the stopped node is in Maintenance Mode. To schedule updates for an Intelligent Cube, first click the “Data Import” button to bring up the list of existing Data Import Cubes. Connection mapping can then be used to map the desired MicroStrategy users to this database login. 4. The current version of MicroStrategy Tutorial is designed using the MicroStrategy URL API with JSP framework, therefore MicroStrategy ASP is not supported for the redesigned Tutorial project. Faster performance than directly querying warehouse. If you select any Intelligent Cube reports, make sure that the Intelligent Cube the reports are based on has been published before you perform the integrity test. It also. Choose File > New > Intelligent Cube. You'll need to provide a name for your cube, as well as a name for the table that will contain the data. In the Intelligent Cube Editor, choose Data > Configure Intelligent Cube… In the Intelligent Cube Options dialog box, expand Options and select Data Partition. For example, you can choose to add or delete data from the Intelligent Cube. 4. 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. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. Create an element prompt that selects elements of Month and the values are restricted by the filter created in step 2. Importing MDX cubes is often handled by a MicroStrategy architect. Open the cube report in Design View. Save the Report and close. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. 4. The following steps can be used to reproduce the issue in the MicroStrategy Tutorial project: 1. This is the same requirement to create or run a static report in Workstation. KB39447: How to Trigger an Event Using the MicroStrategy Web SDK 9. Intelligent cube is a pre aggregated set of data stored in intelligent server memory and it will give very quick access to the data without hitting the data warehouse. Create an Intelligent Cube with "Customer", and add the attribute form "Email" into the cube. Personal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. Create Schema Objects. 2. You can remove the system hierarchy and add your own attributes into the template and include specific attribute forms. 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. 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). microstrategy. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. /ClusterCube. Browse to and select a previously saved Intelligent Cube on which to build your report. To Create a Report that Accesses an Intelligent Cube. Run a dossier based on the cube. Edit Intelligent Cubes from the new editor in Workstation at any time. 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:. From the MicroStrategy Web Home page navigate to the Intelligent Cube (Cube A) you want to merge data into. In the New Intelligent Cube dialog box, select the MDX Sources tab. 0. Select Empty. Rather than returning data from the data warehouse for a. In the Object name field, type a descriptive name for the Intelligent Cube. The Select Intelligent Cube dialog box opens. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. 2. Click here to view details about the Intelligent Cube Monitor. Select the "ORDER_FACT" table. x. Run the report in Grid View. The report opens with all of the objects of the Intelligent. To Schedule a Cube Refresh. In MicroStrategy Web, it is possible to publish an Intelligent Cube using the task "qbuilder. KB441696: Cannot Add Prompts into View Filter of Cube Based Report in MicroStrategy Web. Browse to an Intelligent Cube, select it, and then click OK. 1. The Create Group dialog box opens. 4. Save the cube, and run it to publish. details. All necessary privileges are included in the Administrator role by default. 1 Hotfix 6, it is not possible to use the Attribute Name macro in the filename of a bursted document when the document uses an Intelligent Cube create via Data Import as a dataset as the Intelligent Cube's attributes are not in the actual project schema. Click an MDX cube source. Assuming that ProjectA and ProjectB are in the same metadata, create a Database Instance to connect to an OLAP data source. Login to MicroStrategy Web, create a cube with the function of Data Import 2. When an Intelligent Cube is in this status, any reports based on this cube have. The month ID for 2004 Jan is like 200401. 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. 3. This copy of report data is stored in Intelligence Server memory only. How to build and manage Intelligent Cubes. Drag and drop the objects into the report grid from the Report Objects pane. This Python 3 / MicroStrategy 10. 0 and earlier releases, Outer Join setting for Metrics does not work when there are more than 1 visualizations containing same attributes, metrics, filters but different metric outer join settings when using Live Intelligent Cube as dataset. To Schedule a Cube Refresh. You should see these cubes in the Intelligent Cube cache monitor in Developer. To publish an Intelligent Cube, see. Delete the cube cache from cube monitor. json and has the yyyymmdd suffix automatically set every day, resulting in one log file per day. Execute. Open the cube report in Design View. x-10. 1. MicroStrategy Developer 9. 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). Click “All Objects View”. WORKAROUND: If possible, create a report from the Intelligent Cube, then create the Visual Insight. 3. Modify the list of Report objects (use object browser). 2. The "LP" status of an Intelligent Cube in the Cube Monitor in MicroStrategy Developer stands for "Load Pending". Select data population for Intelligent Cubes. IS_CUBE_ACT_ID. This group also inherits all of the privileges assigned to the Web Reporter group. 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. Refresh Intelligent Cubes manually. 1 product only with documents using view filter qualifications. PublishCube". Incremental Refresh Options, General: Use these options to define the behavior of the incremental refresh. Open the. 4. com. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. 63K. 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. STEPS TO REPRODUCE: 1. Personal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. Normalize Intelligent Cube data in the Database 4. Log into the server and go to the Intelligent Cube monitor (Administration > System Monitors > Caches > Intelligent Cubes). 3. Report Post SQL Statement. 2. If the Intelligent Cube must be re-processed based on a metric. Cube A must be selected here to maintain its attribute IDs after the merge. Under Refresh type, select one of the following options. The report opens with all of the objects of the Intelligent. The Save Intelligent Cube As dialog box opens. The following diagram depicts the role of the intelligent cube. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. This name change is visible in MicroStrategy Workstation and MicroStrategy Web. Click OK. Memory mapped files (MMF) can be used for effective RAM utilization. Click Create on any page, point to New Report, and select Blank Report. On the ODBC Sources tab, in the Source area, select the database instance that connects to the data source to report on using Freeform SQL or Query Builder. The CREATE and INSERT support VLDB property defines whether MicroStrategy can perform CREATE and INSERT statements against the database for a database instance. You can analyze a new set of reports using Cube Advisor or use the results of a previous Cube Advisor analysis: To use Cube Advisor to analyze a new set of reports, choose Tools. A report that runs against the Intelligent Cube. ) As long as each node is using the same server definition, the setting of the cache and history list locations in the Intelligence Server configuration only needs to be done once; however, the creation of the shared folders will need to be done on each node. Publish the cube. Open the Workstation window. In MicroStrategy Developer, log in to a project that contains reports connected to active Intelligent Cubes. MicroStrategy - Intelligent Cubes - Online Training Video by MicroRooster. In MicroStrategy Developer, select the Empty Attribute Form Caching Intelligent Cube template when creating a new Intelligent cube. Once you have reviewed the information, select the check boxes for the Intelligent Cubes to create using Cube Advisor, and then click Create Cube Design. Add ORDER_DETAIL (this tables comes with MicroStrategy Tutorial WH) and click Prepare Data. 1. Intelligent Cubes in MicroStrategy - A Tutorial MicroStrategyBlog 413 subscribers Subscribe 21K views 11 years ago A quick tutorial on how to create and. 3. This allows for more power and control over data for MicroStrategy users: Leverage data-base specific optimizations. Node 2. On MicroStrategy's business intelligence platform, you have two unique methods to implement Intelligent Cube Technology: Personal Intelligent Cubes: A personal Intelligent. jar file to i-server machine. In MicroStrategy Web, create a new Dossier > New Data > Databases > Select Tables. From the File menu, select New,. 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. Go to the Report -> Data->Intelligent Cube Options->Point grid to Intelligent Cube and choose Cube B. 4. In the Refresh Policy column, choose. Create a subset report named R based on Intelligent Cube Q1; drag attribute ‘Brand’, ‘Item’ and ‘Warranty’ to the grid. create(auto_upload=False,. Full Refresh. The Intelligent Cube Editor uses the new Modeling service infrastructure. Node 1. Right-click the cube, and select Schedule. This case is built with the Microstrategy Tutorial project and using the latest version of Microstrategy Web. Choose File > New > Intelligent Cube. Save the Intelligent Cube. create(auto_publish=False). Intelligent cube is an OLAP feature introduced in Microstrategy 9 version. On the Freeform Sources tab, select one of the following options: To. We can create a report and point the report to a cube or right click. However, before changing the way MicroStrategy products look or behave, it is helpful to understand how the application is built. after executing the Login task), and type the GUID of the Intelligent Cube into the "reportid". The steps to use the JDBC driver to connect to Oracle are as follows: Download the Oracle JDBC thin driver. Export to MicroStrategy File. Introduction: Need to create a report with a metric that calculates the number of distinct customers. Use Intelligent Cube Editor. Now we look to leverage operating system capabilities to enable more cubes to be ‘loaded’ between RAM and disk. Export to MicroStrategy File. 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). 9K KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. To create or edit Intelligent cube reports you must at least have the following privileges: Web define Intelligent Cube Report or Defined Intelligent Cube Report. Setting Up Documents and HTML Documents: This chapter explains the setup required for the Intelligence Server to create and execute HTML documents and documents. How to build and manage Intelligent Cubes. To create or edit Intelligent cube reports you must at least have the following privileges: Web define Intelligent Cube Report or Defined Intelligent Cube Report. HyperIntelligence for Web. For steps to create a view filter in MicroStrategy Web, see the MicroStrategy Web Help. The Intelligent Cube Monitor is displayed. Create a report services document or Visual Insight Analysis. Right mouse click on the cube and choose Schedule 3. 2. The following steps demonstrate how to reproduce the issue in MicroStrategy Tutorial: Profit Margin=(Revenue-Cost)/Revenue. 86K KB31566: MicroStrategy 9. How to Import Data from a SAP HANA Database Into MicroStrategy Web. The Browse for Folder dialog box opens. Log in to the project in which you want to create a report. In the left pane, click Intelligent Cubes. 4. Integrity Manager can test the SQL of Intelligent Cubes even if they. Right mouse click on the cube and choose Schedule 3. To view an existing cube, you must have the following minimal privileges: Use analytics. In MicroStrategy Developer, right-click on the intelligent cube and select Edit. Description What's New 2022 Releases Workstation. Create Cube B which contains all objects in the report and publish it . The Intelligent Cube opens in the Report Editor. You can also create Intelligent Cubes by directly querying your data. 2. Architects can design and create Intelligent Cubes to combine attributes, metrics, and filters. Designing and creating documents: An overview. 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. 10 or earlier, outer join to Lookup table in a dashboard/dossier report based on Intelligent Cube with joint element list filter will not work, and incorrect CSI will be generated when both attributes used in the filter are present in visualization. In MicroStrategy 9. 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. Create the metric levels log file used to. In MicroStrategy Web, create a new Dossier > New Data > Databases > Select Tables. Intelligent Cubes. Create an attribute element prompt for the. To Create an MDX Cube Report. Hence, the cube memory usage will easily exceed the limit and the ReduceCubeMemory method can be invoked frequently. This can affect performance of your Intelligence Server as well as the ability to publish the. However, in MicroStrategy Web 10, this 'Link' property is no longer available for Intelligence cubes2. 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. The Report Editor opens with all of the objects of the Intelligent Cube. Add ORDER_DETAIL (this tables comes with MicroStrategy Tutorial WH) and click Prepare. 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. Use OLAP Services. 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. Before MicroStrategy 10. The Subscribe to Cube /Cache Update dialog box opens. 4 using an Excel file and the Connection mapping database connections of the user account which published the cube are listed when checking the Intelligent Cube monitor in Developer. Right-click an Intelligent Cube and select Delete. Complete the "sessionState" field (e. Importing MDX cubes is often handled by a MicroStrategy architect. For more details on Intelligent Cube size increase, refer to the following technical note: KB33449: Intelligent Cube size increases over time in the MicroStrategy. To Create a Report from Scratch. KB441696: Cannot Add Prompts into View Filter of Cube Based Report in MicroStrategy Web. Click OK to save the Intelligent Cube and return to the Report Editor. x: Create a new Intelligent Cube with Attributes Category, Subcategory and Metric Revenue. Stop the. STEPS TO REPRODUCE: 1. Log into ProjectA in MicroStrategy Web. Using MicroStrategy Developer, log in to a project connected to an MDX cube source. Create a Data Import Live Intelligent Cube. Log in to the project in which you want to create a report. 4. Open the. 3) Select the LU_YEAR table from the Tutorial database instance and then select "Connect. The "Refresh Cube. The Modeling service must be configured correctly to use this feature. 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. Total Cubes This section displays the total count of cubes by status. Republish the. With OLAP Services features, your report designers can create Intelligent Cube reports. The New Intelligent Cube dialog box opens. STEPS TO REPRODUCE. Stop the Intelligence Server service of one node of the cluster (in this example, node 2 called “sup-w-006660”). Note: number of columns should be the same as in the original file. In MicroStrategy OLAP Services, Transformation metrics used in standard reports can resolve against Intelligent Cubes only when the same Transformation metric exists in the Intelligent Cube. In MicroStrategy 9. Type of action against the Intelligent Cube: •OLAP (In-Memory, Intelligent Cube) MTDI (In-Memory) MTDI (Live Connect) Data Retrieval. The dataset is a set of data that can be displayed on the document. To view an existing cube, you must have the following minimal privileges: Use analytics. The Modeling service must be configured correctly to use this feature. 3 - Check the Make Intelligent. Right-click the project and select Project Configuration. The Schedule dialog box opens for your dataset, showing the tables in your dataset. Currently, project duplication does not involve Intelligent Cube File Directory. More than one cube can be used in a single dashboard. 0. Select the data sources to be refreshed. 4. In the Intelligent Cube cache monitor in Developer, notice that all cube caches for the project. When an Intelligent Cube is published, the Intelligent. In MicroStrategy Web browse to the Cube location and click on the cube . The Subscribe to Cube /Cache Update dialog box opens. This is a known issue classified as a defect with MicroStrategy Web 9. Republish the same cube, and a new cube instance is generated. To make the Intelligent Cube available to be reported on, you must publish the Intelligent Cube. Defining the partition for Super Cubes. x. Upload Dashboard. In Web, create a new Dossier and click on New Data. Insert one panel stack and add dynamic text with Profit Margin. Hover over a cube, and select the “Schedule” link to bring up a list of existing subscriptions for that cube. When triggering the concurrent subscriptions to publish a cube with different database connections, some of them do not publish. Use the drop-down under the filter summary section to switch the server nodes. The Intelligent Cube opens in the Report Editor. Node 1. In MicroStrategy Developer, log in to a project source with administrative privileges. In MicroStrategy Desktop 9. Check it in the cube monitor and we can see its column Database Connection is not empty. Prerequisites. 0. In the Name field, type the name of the subscription. Once an Intelligent Cube is stored in Intelligence Server memory, multiple reports can be created to view and analyze the set of published data. 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. Select the refresh policy. Create an intelligent cube with Call Center, Quarter and the derived metric 3. Allow reports to drill outside the Intelligent Cube: Select this check box to enable drilling outside the Intelligent Cube to access the full set of data available in the data. Web modify the list of report objects (use object browser --all objects) Web Professional. The steps below show you how to create an Intelligent Cube based on an MDX cube. KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. In the grid display of the report, right-click the attribute for which you want to create or modify derived elements, and click Derived Elements . 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. Regular Intelligent Cubes created on Developer. To review and create recommended Intelligent Cubes using Cube Advisor. STEPS TO REPRODUCE 1. Then click "Save". Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions.