Create a dossier and add subset R from Existing Dataset. Intelligent cube is an OLAP feature introduced in Microstrategy 9 version. 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. For steps to use the Derived Elements Editor to create derived elements in MicroStrategy Web, see the MicroStrategy Web Help. Create a report not based on the Intelligent Cube with Year, Quarter, and Revenue . The following steps can be used to reproduce the issue in the MicroStrategy Tutorial project: 1. Complete the "sessionState" field (e. 1. A page with report creation options is displayed. 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. create() will create a SuperCube, upload the data to the Intelligence Server and publish it. Go to the "All Objects View" option in the top left corner. This data is stored as Intelligent Cubes. Login to MicroStrategy Web, create a cube with the function of Data Import 2. The Modeling service must be configured correctly to use this feature. By default, there is a system hierarchy on the cube. In the dashboard, create a derived metric, RankBy using the Rank function based on profit for Top10. To Create a Report Using Both Report Objects from a MicroStrategy Project and MDX Cube Data. You can also modify the properties of. For steps, see the Upgrade Guide. This determines the approach to existing data at refresh. First, you open a blank document and select a report to use as the document's dataset. Navigate to the folder location of the Intelligent Cube. 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. 4 the connection mapping of the u… Number of Views 1. Create an Intelligent Cube, with Region, Category, Cost and Profit. 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. Add a dataset. Create an Intelligent Cube, with Region, Category, Cost and Profit. 2. Permanent Table: When the queries for a report or Intelligent Cube are performed in parallel, any intermediate tables are created. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. 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. Create a cube report based on the cube. The view filter cannot filter out other elements as shown below:Use Cube Advisor to create Intelligent Cubes: 1. KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. Create a Visual Insight dashboard and add the above cube as the dataset: 3. 2. Users of the OLAP Services Intelligent Cubes feature in a MicroStrategy 9. Architects can design and create Intelligent Cubes to combine attributes, metrics, and filters. Browse to an Intelligent Cube, select it, and then click OK. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. In MicroStrategy Web, log in to a project. In the Name field, type the name of the subscription. Under Refresh type, select one of the following options. 2 release, the driver file is called odbc8. 63K. Import MicroStrategy File. Click Select. Open the Workstation window. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a. Log in to the project in which you want to create a report. Open the Workstation window. Right-click the cube, and select Schedule. Create a report off the Intelligent Cube in step 1 with Year and Month in the rows and Revenue in the columns. Description MicroStrategy 10 introduced a new option on the Intelligent Cube called Data Partition. Select the refresh policy. In MicroStrategy Web, create a new Dossier > New Data > Databases > Select Tables. The Create Group dialog box opens. In Project B, create and run a new Intelligent Cube. 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. Right-click your selection and select Group. The search directly uses the attribute form from the attribute definition, instead of form from the intelligent cube. The Intelligence Server generates various indexes that allow it to speed up performance for the various reports that would use the cube. To view an existing cube, you must have the following minimal privileges: Use analytics. Execute reports or documents that reference the object. For Oracle 12. Navigate to the Engine Component with CSI Dispatcher. How to publish Intelligent Cubes using Task Administrator in MicroStrategy Web. Intelligent Cubes act as a set of data for other reports to connect to and use OLAP Services to report, analyze, and display data. Execute ‘Report_Tutorial’ returns data as shown below: You can edit project-level cache and Intelligent Cube settings. Steps to reproduce. Click OK to save the Intelligent Cube and return to the Report Editor. 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. The Browse for Folder dialog box opens. For steps to use the Derived Elements Editor to create derived elements in MicroStrategy Web, see the MicroStrategy Web Help. (Titled: "Cube broken aplysimple") No data is returned the following SQL view is seen: Report: cube broken applysimple Job: 198 Total Number of Passes: 1 Number of Intelligent Cube SQL Passes: 1 Number of Analytical Passes: 0 Intelligent Cubes Accessed:The steps below show you how to create an Intelligent Cube based on an MDX cube. To set refresh filters, or alternate data sources, select Show Advanced Options. In the Dynamic Sourcing area, use the Make Intelligent Cubes available for. x. Select the refresh policy. The impact is limited to MicroStrategy Developer 9. This Python 3 / MicroStrategy 10. x. Easily add or change pre- and post- SQL statements. The Intelligent Cube opens in the Report Editor. Prerequisites for using Cube Advisor. The Intelligent Cube opens in the Report Editor. Click Intelligent Cube Report. The Schedule dialog box opens for your dataset, showing the tables in your dataset. In MicroStrategy Web, create a new Dossier > New Data > Databases > Select Tables. • You need the Publish Intelligent Cube (Developer) and/or Web Publish Intelligent Cube (Web) privileges. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. After refreshing an Intelligent Cube that had columns added to it, the newly created attributes do not show up in the document's Dataset Objects pane in MicroStrategy Web 9. 11. Navigate to and select the report or Intelligent Cube to use as the dataset, then click OK. Documentation on the REST API is at developer. Select the data set and click Prepare Data. Now we look to leverage operating system capabilities to enable more cubes to be ‘loaded’ between RAM and disk. 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. Answer: When attempting to add a prompt directly to an Intelligent Cube in MicroStrategy Developer 9. 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. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a great. Open the. 1. The Modeling service must be configured correctly to use this feature. . Navigate to the folder location of the Intelligent Cube. Create a standalone Derived metric DM : Create a new Intelligent Cube C01: Add the Quarter, Country, and Region attributes. First, you open a blank document and select a report to use as the document's dataset. This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. Connection mapping can then be used to map the desired MicroStrategy users to this database login. Prerequisites. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. Execute. 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). This status can appear due to a n environment issue such as the network, database connection, or a PC resource usage issue. From the Data menu, select Add Dataset. From the Data menu, select Configure Intelligent Cube. Type of action against the Intelligent Cube: •OLAP (In-Memory, Intelligent Cube) MTDI (In-Memory) MTDI (Live Connect) Data Retrieval. How to build and manage Intelligent Cubes. Publishing an Intelligent Cube retrieves data from the data warehouse and stores this data as an Intelligent Cube in Intelligence Server memory. The Schedule dialog box opens for your dataset, showing the tables in your dataset. x-10. Navigate to the Intelligent Cube for which you want to define the incremental refresh. g. 1, users could right click an Intelligence cube to create a URL API call that would allow users to automatically create a Visual Insight dashboard using that same cube. Select an existing schedule or create a custom one. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. Use OLAP Services. To add an existing report or Intelligent Cube as a dataset. Type a name for the derived element, and click OK. From the File menu, select New,. 3. Log in to a project connected to an MDX cube source. Run the report, notice that the filter does not work, all. 1. 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. x. Architects can now create, edit, and publish Intelligent Cubes with the new editor in Workstation, streamlining overall creation workflows. HIDDEN: if the intelligent cube is hidden or not, returned as a boolean value. Set the number of partitions equal to the number of CPU cores in MicroStrategy Intelligence Server host computer. These VLDB properties control the method by which the report data are normalized. 2. Right-click your selection and select Group. Create a new dossier: Create a new metric M01=Case: Create a new metric. Workaround 2: Create a non-Kerberos authenticated database login. Browse to and select a. In MicroStrategy Developer, log in to a project source with administrative privileges. CubeServerDefinition, and this folder should be shared as 'ClusterCube'. This name change is visible in MicroStrategy Workstation and MicroStrategy Web. To Create a Report Using Both Report Objects from a MicroStrategy Project and MDX Cube Data. 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%. In this case, the dataset is a MicroStrategy Intelligent Cube. Visualizations in the dossier that use data from the cube display. The MicroStrategy SDK allows you to customize several MicroStrategy products and extend and integrate the MicroStrategy business intelligence functionality into other applications. Create a second Intelligent Cube C02: Add the Year, Quarter, and Category attributes. 3. Select the Intelligent Cubes tab. 4. Select the environment and project where you want to save your. Under Refresh type, select one of the following options. This is possible because when the Intelligent Cube refresh job finishes, a record is logged in the IS_REPORT_STATS table. PublishCube". Click a catalog. When an OLAP report is created from an Intelligent Cube, some users may have difficulty adding prompt objects to that report. 5. From the File menu, select New, and then select Intelligent Cube. This status can appear due to a n environment issue such as the network, database connection, or a PC resource usage issue. Select a schedule from the Schedule drop-down list. Save as an In-Memory dataset. In the Data Source column, select the checkboxes for the tables to update. Save the Report and close. * Web define Intelligent Cube report: create a report that uses an Intelligent Cube as a data source: WEBDEFINEVIEWREPORT * Web publish Intelligent Cube: publish an Intelligent Cube to Intelligence Server: WEBEXECUTECUBEREPORT * Web save derived elements: save stand-alone derived elements, separate from the report: WEBSAVEDERIVEDMETRICS In MicroStrategy Web, log in to a project. Click All Objects View. 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. Shut down Intelligent Server node A with command . 0. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. 1. 4. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. The default value is 256 megabytes. Hence, the cube memory usage will easily exceed the limit and the ReduceCubeMemory method can be invoked frequently. The group is created as a derived element and displayed on the report. Under Cube Update, click Cube Update. This issue has been classified as a defect by MicroStrategy. "In MicroStrategy 10. Then click "Save". Create a new File Log and name it “CSI” (or any other name). From the Report Selection panel, go to the File menu > Open. Add DM. By default, this is set to 32,000. Create a new File Log and name it “CSI” (or any other name). Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. For background. From MicroStrategy Education, this lesson teaches you how to create an Intelligence Cube in MicroStrategy Desktop, then use that Intelligence Cube to create. 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. Prerequisites. Common Privileges. Remove the prompt from the Base Report and save it as Intelligent Cube. 1. In MicroStrategy Web 9. The predefined MicroStrategy Web Analyst group is assigned the set of Web Analyst privileges by default. WORKAROUND: As workaround, add or edit View Filter conditions in MicroStrategy Developer or after running the Intelligence Cube Report in. You should see these cubes in the Intelligent Cube cache monitor in Developer. 3. Publishing an Intelligent Cube retrieves data from the data warehouse and stores this data as an Intelligent Cube in Intelligence Server memory. The Incremental Refresh Options dialog box opens. Right-click the dataset, and choose Schedule. Integer ID of the project where the Intelligent Cube is stored. g. In the Object name field, type a descriptive name for the Intelligent Cube. When an Intelligent Cube is published, the Intelligent. Open the cube report in Design View. For steps to create a view filter in MicroStrategy Web, see the MicroStrategy Web Help. x, Report Service Document appears to show Null/Empty value for Row Count metric when using Live Connect Intelligent Cube. You must complete a few prerequisites before using Cube Advisor to recommend and create Intelligent Cubes to support a dynamic sourcing strategy. In MicroStrategy Developer, right-click on the intelligent cube and select Edit. You cannot create or edit a card based on an unpublished cube. The Intelligent Cube Editor uses the new Modeling service infrastructure. You can also select an existing template on which to build your new report. In MicroStrategy Web 10. Create a cube report based on the cube. STEPS TO REPRODUCE: 1. Complex metrics here refer to metrics which are defined using multiple. To define an incremental refresh report. The Modeling service must be configured correctly to use this feature. 3. 2. Report Post SQL Statement. Create Cube A and a report based on it. Log file The log file, located in <path>/mstr_cube_trigger/log is called mstr_cube_trigger_log_<yyyymmdd>. 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. This must be done by the DBA and MicroStrategy Technical Support will not assist with this. However, users can achieve this functionality by creating a cache update subscription to refresh Intelligent Cubes. The Save Intelligent Cube As dialog box opens. A quick tutorial on how to create and Intelligent Cube, and how to schedule it to be refreshed. Run report off cube. You can use the ACL Editor in -MicroStrategy Web to assign the following permission groups to users, for each Intelligent Cube: Group. txt file. In MicroStrategy Developer, select the Empty Attribute Form Caching Intelligent Cube template when creating a new Intelligent cube. Export to MicroStrategy File. Number of Views 1. Starting in MicroStrategy 10. Save the cube, and run it to publish. Browse to and select a previously saved Intelligent Cube on which to build your report. MicroStrategy Web and Mobile deployed in a JSP server like Tomcat. Create a report off the Cube with Category, and Region attributes and Revenue metric on. Note: number of columns should be the same as in the original file. This is set to 32,000 by default. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. This procedure assumes that the Linux machines are called UNIX1 and UNIX2. In MicroStrategy Web 9. Integrity Manager can test the SQL of Intelligent Cubes even if they. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. Create an Intelligent cube with Year, Quarter, and Revenue with MicroStrategy Tutorial data. For a MicroStrategy environment configured to use Database level security using MSTR connection mapping, Intelligent Cubes can still be utilized. 0. Importing MDX cubes is often handled by a MicroStrategy architect. Save the Report and close. Enter a name for your new schedule into the. The object Type is listed as Super Cube: This can also be seen when editing or authoring a dossier. The Incremental Refresh Options dialog box opens. The Intelligent Cube opens in the Report Editor. 438832. 2. Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user experience and report performance. How to configure, monitor, and manage Intelligent Cubes. Select the data sources to be refreshed. x. Create a Visual Insight dashboard and add the above cube as the dataset: 3. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. 7. 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. Right-click the project and select Project Configuration. In MicroStrategy Developer, log in to a project that contains reports connected to active Intelligent Cubes. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library;. Rather than returning data from the data warehouse for a single report, Intelligent Cubes return sets of data from the data warehouse and saves. 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. The visualization data changes when the Data Access mode of an Intelligent Cube is changed from In-Memory to Live mode. However, users may notice that there is nowhere to specify notifications through the scheduled refresh interface in MicroStrategy Web. This technical note describes a known issue when creating a data import cube in MicroStrategy Web 10. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data imported. 4. A user with Use but not Execute permission for an Intelligent Cube can create and execute reports that use that Intelligent Cube, but cannot publish the Intelligent Cube. 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. 3. However, importing data from a Google Drive Spreadsheet requires some additional setup. It is especially useful when data. 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. For the Intelligent Cube that you want to refresh, click the subscription icon. 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. 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. after executing the Login task), and type the GUID of the. 2. 2. If. All articles. 2. Export to MicroStrategy File. create(auto_upload=False,. Create a user (tester) and disable the "web publish Intelligence Cube" privileges under Web Analyst. Run a dossier based on the cube. In the Dynamic Sourcing area, use the Make Intelligent Cubes available for. A document is used to format data from multiple datasets in a single display of presentation quality. Navigate to Administrator -> System monitor -> Cube monitor both nodes, and check all cube are “active, load, file” status. For more details on enabling the setting. 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. Introduction: Need to create a report with a metric that calculates the number of distinct customers. Create two Intelligent Cube Reports: C01 and C02 in the MicroStrategy Tutorial project. This KB article shows sample code to get the intelligent cube status programmatically with Web SDK. Restoring cube files. This allows for more power and control over data for MicroStrategy users: Leverage data-base specific optimizations. This data is stored as Intelligent Cubes. Import MicroStrategy File. CAUSE: The report on which the action is being performed is a "Standard" report, only OLAP reports can be pointed to Intelligent Cubes. In the user interface, specify the partition attribute and the number of partition . All necessary privileges are included in the Administrator role by default. This is the same requirement to create or run a static report in Workstation. In the dashboard, create a derived metric, RankBy using the Rank function based on profit for Top10. The steps below show you how to create an Intelligent Cube based on an MDX cube. Create an Intelligent cube and add subscriptions for all 500 users to publish the cube. The following procedure will make cube data accessible to view reports. Select an MDX cube. Select the data sources to be refreshed. Choose File > New > Report. The Full Refresh option is the default. 2. Expand Intelligent Cubes, and then select General. The Intelligent Cube Monitor is displayed. The status of each Intelligent Cube is listed in the. Make sure the service is properly configured and running before using the Intelligent Cube Editor. Go to the Report -> Data->Intelligent Cube Options->Point grid to Intelligent Cube and choose Cube B. 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. Both types of subscriptions when targeting intelligent cubes will submit the same SQL statements to the database. Steps to Reproduce. From the cube monitor, we could see the. Click Create on any page, point to New Report, and select Blank 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. This permission is checked at design time, and when executing reports against an Intelligent Cube. You need the Use Intelligent Cube. Click “All Objects View”. 4. x checks for 'Execute' access to the managed column object being used in the metric when adding it to the report, which is not required for regular non-mnanaged metrics. x, sharing of Intelligent Cube data files is configured similarly. Click Create on any page, point to New Report, and then select Blank Report, which provides a blank template to build your report on. MicroStrategy URL Structure The following table summarizes the root URL structure used for every request to MicroStrategy Web. Some uses for this data include: •. Right-click the cube, and select Schedule Data Refresh. Modify the list of Report objects (use object browser). 1. In the Data Source column, select the checkboxes for the tables to update. 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. Follow below steps to achieve that : Create Elements Prompt and add them into Report coming from Intelligent Cube. IS_CUBE_REP_ID. As shown in the screenshot above, only one cube cache can be loaded in RAM. Save the Intelligent Cube generated. Complete the "sessionState" field (e. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or 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. This determines the approach to existing data at refresh. 11. We use MicroStrategy Tutorial objects in the following steps. For example, you can restrict some users to only create reports based on an Intelligent Cube, but not re-execute the Intelligent Cube. To set refresh filters, or alternate data sources, select Show Advanced Options. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. x Intelligent Cube status indication and workflowTo create an attribute form caching cube. 2. 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. Create 3 aggregate from base metrics as follows:In MicroStrategy Workstation, right click on any cube created via Data Import and select Properties. In MicroStrategy Developer, log in to a project source with administrative privileges. 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. “Intelligent Cube (<Cube Name>) for locale. Create a report based on the Intelligent Cube. Edit Intelligent Cubes from the new editor in Workstation at any time. Steps to activate CSI Log in Windows: Open the MicroStrategy Diagnostics and Performance Logging Tool. STEPS TO REPRODUCE: 1. 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. Refer to the following tech note, KB37431 for a list of Licenses and privileges required for different actions related to Visual Insight in MicroStrategy Web 9. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. x, users will notice that this is not possible due to the mouse pointer changing into a "not allowed" symbol.