Create a new report based on the published Intelligent Cubes that are supposed to be made available to your designers. All Intelligent Cube operations are listed below: 1. On MicroStrategy's business intelligence platform, you have two unique methods to implement Intelligent Cube Technology: Personal Intelligent Cubes: A personal Intelligent. PUBLISH INTELLIGENT CUBE "C02" IN FOLDER "Public Objects\Reports\Sequential Cube Execution" FOR PROJECT "MicroStrategy Tutorial"; The previous commands can be saved in a script that also requests the Command Manager console to be open through the command prompt. Both properties are located in the Query Optimizations folder in the VLDB property editor. 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. 1. 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. The History List folder is displayed, with a list of dossiers, documents, reports, and Intelligent Cubes that have been added to the History List. To create a card, ensure we are connected to an upgraded version of the metadata or upgrade your metadata to 2019 or above. Web modify the list of report objects (use object browser --all objects) Web Professional. in MicroStrategyIntelligence ServerCube<Server_Definition_Name>. 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. 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. ACTION:The Data Transfer Rate varies from 27 to 28 Mb/s. ACTION: Currently this issue is still being reviewed for feasibility by our Technology team and it is not scoped for any upcoming scheduled MicroStrategy release. Select an MDX cube. 4. 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. Go to the Report -> Data->Intelligent Cube Options->Point grid to Intelligent Cube and choose Cube B. Since Web distributes connections between Intelligence Servers. KB30711: Security filter application to view reports based on Intelligent Cubes. Architects can design and create Intelligent Cubes to combine attributes, metrics, and filters. The data used for this example is from a SQL Server 2014 version of the MicroStrategy Tutorial database. At least one MDX cube must be imported into your MicroStrategy project. 3. 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. Create a report off the Intelligent Cube in step 1 with Year and Month in the rows and Revenue in the columns. Execute. Login MicroStrategy Developer, create User M20061 with security filter defined as: Month in {20061} Create Intelligent Cube C01 with: Attribute Quarter, Month, Country, Region and Metric Cost, Region, and publish the cube. Open MicroStrategy Web. If you've already got a report that you want to create an Intelligent Cube out of, you simply go to. Later the user can poll for the change in the value of the flag. To Schedule a Cube Refresh. For steps to use an existing template to. 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. IS_CUBE_REP_ID. 4 the connection mapping of the u… Number of Views 1. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. Edit Intelligent Cubes from the new editor in Workstation at any time. Create a report not based on the Intelligent Cube with Year, Quarter, and Revenue . Navigate to the Intelligent Cube for which you want to define the incremental refresh. Create a report off the Cube with Category, and Region attributes and Revenue metric on. How to build and manage Intelligent Cubes. 38K. Run the report in Grid View. Create a new dossier: Create a new metric M01=Case: Create a new metric. Complete the "sessionState" field (e. Refresh Intelligent Cubes manually. If you have a MultiSource Option license, you can include MDX cube data along with data from your relational project. From the. Import MicroStrategy File. Number of Views 1. It is very simple to create an intelligent cube, it is same like. create(auto_publish=False). Add Year Id and Quarter. This copy of report data is stored in Intelligence Server memory only. Then click "Save". Click Create on any page, point to New Report, and then select Blank Report, which provides a blank template to build your report on. 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. In the New Intelligent Cube dialog box, select the MDX Sources tab. IS_CUBE_ACT_ID. Connection mapping can then be used to map the desired MicroStrategy users to this database login. Allow reports to drill outside the Intelligent Cube Select this option to enable drilling outside the Intelligent Cube to access the full set of data available in the data. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. This allows for more power and control over data for MicroStrategy users: Leverage data-base specific optimizations. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. Intelligent Cubes. This VLDB property has the following options:. In MicroStrategy Web, click "Access External Data"; In the "Connect to Your Data" window, click the "Manage Your Datasets" link in left-bottom corner, as shown below: In Data Storage window, right mouse click the cube and choose "Schedule", a sub context menu displays all the existing schedule. This Python 3 / MicroStrategy 10. create() will create a SuperCube, upload the data to the Intelligence Server and publish it. See Importing MDX cubes in the MDX Cube Reporting Help for more information. The visualization data changes when the Data Access mode of an Intelligent Cube is changed from In-Memory to Live mode. (MicroStrategy AE) spends more time searching and fetching the report definition and then applies that definition to the intelligent cube. Stop the Intelligence Server service of one node of the cluster (in this example, node 2 called “sup-w-006660”). Number of Views 2. Rather than returning data from the data warehouse for a. To Create an Intelligent Cube Using Freeform SQL or Query Builder. 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. x Intelligent Cube status indication and workflow To create an attribute form caching cube. The predefined MicroStrategy Web Analyst group is assigned the set of Web Analyst privileges by default. 1 clicking on the Intelligent Cube does not publish the cube but instead creates an analysis from the cube. e. This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. 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. 000007431. Execute ‘Report_Tutorial’ returns data as shown below: You can edit project-level cache and Intelligent Cube settings. Follow below steps to achieve that : Create Elements Prompt and add them into Report coming from Intelligent Cube. MicroStrategy Tutorial is used in this example. Deploy the ojdbc8. 1 product only with documents using view filter qualifications. The object Type is listed as Super Cube: This can also be seen when editing or authoring a dossier. Create a Visual Insight dashboard and add the above cube as the dataset: 3. x. Select other schedule options as required, and click OK. 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. Intelligent Cubes in MicroStrategy - A Tutorial MicroStrategyBlog 413 subscribers Subscribe 21K views 11 years ago A quick tutorial on how to create and. In your Datasets panel, hover over the. 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. 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. This is the same requirement to create or run a static report in Workstation. 4. Upload Dashboard. In order to set a limit of rows for report that uses an Intelligent Cubes use the following steps as workaround: 1 - Create a similar regular report using the same attributes and metrics of the Intelligent Cube. Execute reports or documents that reference the object. Log into the server and go to the Intelligent Cube monitor (Administration > System Monitors > Caches > Intelligent Cubes). For steps, see the Upgrade Guide. To schedule an Intelligent Cube to be updated. Create a new variable and assign SuperCube with two parameters inside – connection and id. Both MicroStrategy Developer and MicroStrategy Web have the ability to incrementally fetch element rows from Intelligence Server. Start > All Programs > MicroStrategy Products > Integrity Manager. Click Intelligent Cube Report. The Modeling service must be configured correctly to use this feature. For the example scenario, create a report with Year, Region, and Profit Margin on the report. Quickly integrating data into MicroStrategy as part of a proof-of-concept. In MicroStrategy Web browse to the Cube location and click on the cube . In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. 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). Run the Report and check the SQL View. There is no need to further create a dashboard. From the Report Selection panel, go to the File menu > Open. In order to set a limit of rows for report that uses an Intelligent Cubes use the following steps as workaround: 1 - Create a similar regular report using the same attributes and metrics of the Intelligent Cube. x. Check the status of the cubes in Developer. Click the MicroStrategy icon at the upper left of any page and select History List. Export to MicroStrategy File. How to use Guacamole to copy and paste text or files in MicroStrategy on AWS;Job ID for the action on the Intelligent Cube. From the Data menu, point to Intelligent Cube Options, and select Convert to Intelligent Cube. Create a report based on the Intelligent Cube with Year, Quarter, and Revenue. Check it in the cube monitor and we can see its column Database Connection is not empty. Related Topics. Create a second Intelligent Cube C02: Add the Year, Quarter, and Category attributes. Execute reports or documents that reference the object. 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. Rather than returning data from the data warehouse for a single report, Intelligent Cubes return sets of data from the data warehouse and saves. The old cube files don't have this property, so new IDs will be generated every. Create an intelligent cube with Call Center, Quarter and the derived metric 3. Intelligent cube is an OLAP feature introduced in Microstrategy 9 version. Create an intelligent cube with Category, Subcategory and Year in rows and Revenue and Cost in columns. Insert one panel stack and add dynamic text with Profit Margin. Add External Data. Quickly integrating data into MicroStrategy as part of a proof-of-concept. An Intelligent Cube is a multi-dimensional cube (sets of data) that allow you to use OLAP Services features on reports, as well as share sets of data among multiple reports and documents. The Save Intelligent Cube As dialog box opens. Click an MDX cube source. 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%. Expand Intelligent Cubes, and then select General. Here, we use MicroStrategy Tutorial objects to create a report: Add Category, Brand, and. 4. The following procedure will make cube data accessible to view reports. Call this 'Base Report'. You can also reproduce this issue in a Document. This KB article shows sample code to get the intelligent cube status programmatically with Web SDK. after executing the Login task), and type the GUID of the Intelligent Cube into the "reportid". The Intelligent Cube Options dialog box opens. To create an Intelligent Cube using the Freeform SQL Editor, select Use Freeform. This KB article shows sample code to get the intelligent cube status programmatically with Web SDK. A solution/code fix for this issue is not available in current releases but is being reviewed for a future MicroStrategy. Create a report not based on the Intelligent Cube with Year, Quarter, and Revenue . x releases, and the new Multi-table Data Import (MTDI) cubes. For steps to use the Derived Elements Editor to create derived elements in MicroStrategy Web, see the MicroStrategy Web Help. Create the metric levels log file used to. If. Create Schema Objects. Normalize Intelligent Cube data in the Database 4. Create an Intelligent Cube, with Region, Category, Cost and Profit. Assuming that ProjectA and ProjectB are in the same metadata, create a Database Instance to connect to an OLAP data source. Steps to reproduce. Make sure the service is properly configured and running before using the Intelligent Cube Editor. More than one cube can be used in a single dashboard. Sharing data. Open the cube report in Design View. In MicroStrategy Web, create a new Dossier > New Data > Databases > Select Tables. 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. 66K. In MicroStrategy Developer, select the Empty Attribute Form Caching Intelligent Cube template when creating a new Intelligent cube. 86K KB42486: Users are unable to align the report name / title when exporting a report to an Excel file in MicroStrategy Web 9…This article discusses an issue with DELETE incremental refresh reports invalidly preventing an intelligent cube from being used for dynamic sourcing in MicroStrategy 10. From the Data menu, select Configure Intelligent Cube. In the Refresh Policy column, choose one of the following options: To define an incremental refresh report. Prerequisites for using Cube Advisor. You can also select an existing template (see How to Create a Report Based on an Existing Template ). These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. A report accessing the Intelligent Cube includes only Year on the report. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. . 3. Using MicroStrategy Developer, log in to a project connected to an MDX cube source. IS_PROJ_ID. 2. This determines the approach to existing data at refresh. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. If you just want to create the SuperCube and upload the row-level data but leave it unpublished, use SuperCube. Share query results in-memory across multiple dossiers and. Look for existing Intelligent Cubes: Before you create an Intelligent Cube, search through MicroStrategy to see whether a similar Intelligent Cube already exists that can serve the same purpose as the Intelligent Cube that you. Use the Objects section to search for the desired metrics and attributes. This name change is visible in MicroStrategy Workstation and MicroStrategy Web. Type of action against the Intelligent Cube: •OLAP (In-Memory, Intelligent Cube) MTDI (In-Memory) MTDI (Live Connect) Data Retrieval. In MicroStrategy 10. With OLAP Services features, your report designers can create Intelligent Cube reports. Click the “Add history list subscription” link near the bottom of the screen to open the. To review and create recommended Intelligent Cubes using Cube Advisor. 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. To make the Intelligent Cube available to be reported on, you must publish the Intelligent Cube. 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. Published: 4월 6, 2017. Create a dossier and add subset R from Existing Dataset. STEPS TO REPRODUCE: 1. Browse to and select a. Supports derived metric creation. Create a report based off the cube in Step 1 that includes the description form for Category. In the Refresh Policy column, choose. 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 a known issue classified as a defect with MicroStrategy Web 9. How to publish Intelligent Cubes using Task Administrator in MicroStrategy Web. e. Right-click an application and choose Properties. The Select Intelligent Cube dialog box opens. /ClusterCube. After saving the log destination, the File Log column should now read as "CSI" for the Engine Component. Edit Project-Level Cache and Intelligent Cube Settings. To build an Intelligent Cube In Developer, from the File menu select New, and then Intelligent Cube. Create a report based on the Intelligent Cube. Click a catalog. Browse to and select a previously saved Intelligent Cube on which to build your report. 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. In the dashboard, create a derived metric, RankBy using the Rank function based on profit for Top10. 1. Steps to import a spreadsheet from Google Drive:MicroStrategy’s in-memory cube technology has been generally referred to as PRIME cubes since 10. Open MicroStrategy Web. Create an Intelligent cube and add subscriptions for all 500 users to publish the cube. From the Data menu, select Configure Intelligent Cube. Full Refresh. 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. You must publish an Intelligent Cube to make it available for multiple reports to access and report on its set of data. Personal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. The Modeling service must be configured correctly to use this feature. (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. 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. . Expand Intelligent Cubes, and then select General. For more information on importing MDX cubes into MicroStrategy, see Importing MDX cubes. To Create an MDX Cube Report. Right-click an Intelligent Cube and select Delete. Remove the prompt from the Base Report and save it as Intelligent Cube. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. Intelligent Cubes. x Intelligent Cube status indication and workflowTo create an attribute form caching cube. Its contents are timestamped messages with status, method of refresh, request source, request content, updated request content. Navigate to the folder location of the Intelligent Cube. Personal Intelligent Cubes are linked to a single report: Pro: The report can use OLAP Services to analyze report data and is always updated with the latest version of the personal Intelligent Cube. Data Population for Intelligent Cubes. x as Administrator; create a simple Intelligent Cube called Q, and publish it. Select from the following localization options: Use project default data language (Default): Select this option to provide data only in the default language for the project. 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. You can also create Intelligent Cubes by directly querying your data. As shown in the screenshot above, only one cube cache can be loaded in RAM. Use OLAP Services. You need the Use Intelligent Cube. 1 or above, to pick up the fix, enable project level setting "Data Engine Version" to 11. Include “Qualification Prompt”. Steps to activate CSI Log in Windows: Open the MicroStrategy Diagnostics and Performance Logging Tool. Under Refresh type, select one of the following options. 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. Browse to an Intelligent Cube, select it, and then click OK. 4. Web publish Intelligent Cube. Integrity Manager can test the SQL of Intelligent Cubes even if they. STEPS TO REPRODUCE. 1Currently it is not possible to create a cube refresh subscription in Command Manager. From the Data menu, select Configure Intelligent Cube. The Browse for Folder dialog box opens. “Intelligent Cube (<Cube Name>) for locale. 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 create an Intelligent Cube report, refer to the OLAP Services Guide . A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. The Report Editor opens. Currently, project duplication does not involve Intelligent Cube File Directory. Click Close, then "Finish" on the "prepare data" view and save the cube. To make the Intelligent Cube available for creating reports, publish the Intelligent Cube by choosing Run Report in the toolbar. Create a Report 'R3' with 'Country' attribute. Configure and start the Intelligence Server using the metadata backup. 1… Number of Views 9. 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). The Modeling service must be configured correctly to use this feature. In MicroStrategy Web, create a new Dossier > New Data > Databases > Select Tables. By default, there is a system hierarchy on the cube. Login to MicroStrategy Web, create a cube with the function of Data Import 2. Log in to the project in which you want to create a report. Configure a Cluster with a Centralized Cache. 2. Create a user (tester) and disable the "web publish Intelligence Cube" privileges under Web Analyst. You must belong to the System Administrators group to use this feature. In the MicroStrategy Tutorial Warehouse tables, import data from the table LU_CATEGORY to create an intelligent cube in MicroStrategy Web 10. To do so, you can take advantage of URL API. All reports that access Intelligent Cubes allow you to drill within the data included in an Intelligent Cube. Ensure that the email addresses can be displayed properly. They are. Con: The copy of report data in Intelligence Server memory only applies to a single report. First, you open a blank document and select a report to use as the document's dataset. Save the Report and close. Description. 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. Check the location of the new cube cache and notice that it is saved in the default location, i. Open MicroStrategy Developer. To publish your cube, see the In-Memory Analytics Help. Navigate to the Engine Component with CSI Dispatcher. To create an Intelligent Cube based on an MDX cube Using MicroStrategy Developer, log in to a project connected to an MDX cube source. 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 " How to" knowledge base article explains cube advisor. Right Mouse Click on ‘Cube_Tutorial’ to create report called ‘Report_Tutorial’. 0. This article discusses how to publish an Intelligent Cube using the MicroStrategy Web SDK. Create an Intelligent Cube, with Region, Category, Cost and Profit. To schedule updates for the Intelligent Cube. The ability to view or edit certain settings is determined by a user's privileges. If you are upgrading to MicroStrategy 11. Normalize Intelligent Cube data in the. In the Data Source column, select the checkboxes for the tables to update. x. Visualizations in the dossier that use data from the cube display. Answer: Intelligent Cubes can be created in microstrategy in public objects folder or in a particular user folder. 2. Create Intelligent Cubes. CAUSE: Starting in MicroStrategy 9. 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. This name change is visible in MicroStrategy Workstation and MicroStrategy Web. When attempting to add a prompt directly to an Intelligent Cube in MicroStrategy Developer 9. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data imported. Import MicroStrategy File. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. Click Create on any page, point to New Report, and select Blank Report. x clustered environment may observe that after a period of time from the initial publishing of the cube and executing reports based off it, the size of the cubes as reported by the Intelligent Cube monitor in some cases is different in one node than the other node(s). The general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. In the Data Source column, select the checkboxes for the tables to update. Create a report based on above Cube and add the prompt in view filter. This is the same requirement to create or run a static report in Workstation. Navigate to the Engine Component with CSI Dispatcher. Create Cube B which contains all objects in the report and publish it . Check it in the cube monitor and we can see its column Database Connection is not empty. 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. The Intelligent Cube opens in the Report Editor. 4. Click here to view details about the Intelligent Cube Monitor. 2. 1, Data Import allows users to maintain intelligent cubes from external Excel files. 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 New Grid dialog box opens. At this time, only one table per cube is supported. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. 2. Click Create on any page, point to New Report, and select Blank Report. 4. 2 in Web, navigate to the report in edit mode, right click “customer” and insert metric Count as shown below: 3. This can be seen in the screenshot below. Steps To Reproduce 1. details. An in-memory version of report data that can be manipulated by the MicroStrategy Analytical Engine. 4. However, importing data from a Google Drive Spreadsheet requires some additional setup. Check in Developer that the stopped node is in Maintenance Mode. 9 and 10. This permission is checked at design time, and when executing reports against an Intelligent Cube. 10 example shows how you can: Generate Auth Token and create an Intelligent Cube containing data. Integrity Manager can test the SQL of Intelligent Cubes even if they. json and has the yyyymmdd suffix automatically set every day, resulting in one log file per day. 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. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. Multiple reports can access a single. The impact is limited to MicroStrategy Developer 9. MicroStrategy Developer 9. 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. The Modeling service must be configured correctly to use this feature. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. Included are steps to enable dynamic sourcing for the project, create the metric levels log, and run the Cube Advisor Tool. Use the drop-down under the filter summary section to switch the server nodes. Create a cube report based on the cube. HIDDEN: if the intelligent cube is hidden or not, returned as a boolean value. 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. GUID: is the GUID of the intelligent cube, returned as a string. Setting Up Documents and HTML Documents: This chapter explains the setup required for the Intelligence Server to create and execute HTML documents and documents. Execute. For the Intelligent Cube that you want to refresh, click the subscription icon. 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. Select the data set and click Prepare Data. x, users will notice that this is not possible due to the mouse pointer changing into a "not allowed" symbol. A page with report creation options is displayed. KB441075: 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. 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. 4. This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. DESC forms are in bold as they are displayed by default in the report, as shown below:In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. 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. 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. * Web define Intelligent Cube report: create a report that uses an Intelligent Cube as a data source: WEBDEFINEVIEWREPORT.