Intelligence Cube in MicroStrategy

Please subscribe to the channel to get an update with videos and help us to get 5000 Subscribers. https://www.youtube.com/channel/UCFwVfgH4aCh6MXAgL0CcIow Intelligent Cubes are also known as In-memory Cubes Intelligent Cubes allow multiple reports to retrieve data from a single shared in-memory set of data for faster response times. To import data from a local file:-- In MicroStrategy Web, open the MicroStrategy Tutorial\Shared Reports page. Click Create, and select Add External Data. In the Connect to Your Data window, click File from Disk. In the Upload, Your Files window, click Choose Files. Navigate to and select the Forecast Data.xlsx file you received from your instructor, and click Open. Click Prepare Data. Click the drop-down list beside the Customer column header, and select Rename. Type Last Name. For the third column, change the name from Column 3 to First Name. Change the name of the Customer Address column to Address Change the name of the Customer City column to City Publish the data as an Intelligent Cube Click Finish to publish as an in-memory Intelligent Cube. Save the Intelligent Cube as Forecast Data in the Shared Reports folder, and click Save. Create a report based on the Intelligent Cube that you created from the imported data. On the Start, Your Analysis window, click Create Report. Double-click the Last Name and First Name attributes in the Report Objects window to add them to the grid. Double-click the Profit Forecast and Revenue Forecast metrics in the Report Objects window to add them to the grid. Save the report as Customer Forecast (Grid) in the My Reports folder and click OK. Go to the Shared Reports page. Click Create, point to New Report, then select Intelligent Cube Report. Select the Forecast Data cube in the Shared Reports folder, and click Select. Hold CTRL and select Category, Profit Forecast, and Revenue Forecast. Right-click the selected objects and click Add to Grid. In the toolbar, click Run Report. In the toolbar, click Graph to view the report as a graph. Click Save Save the report as Category Forecast (Graph) in the My Reports folder and click OK. Click Return to Original Report