MicroStrategy - Intelligent Cubes

mstr

http://www.bryanbrandow.com/2011/04/incremental-refresh-of-intelligent-cubes.html
http://www.bryanbrandow.com/2011/03/intelligent-cubes-dynamic-sourcing-vs-view-reports.html
http://www.lancetdatasciences.com/resource-center/blog/microstrategy-tech-tip/tech-tip-how-create-microstrategy-intelligent-cubes

http://www.youtube.com/watch?v=dJcE7PryBUA - Intelligent Cubes in MicroStrategy - A Tutorial - YouTube
http://www.youtube.com/watch?v=dJcE7PryBUA - Intelligent Cubes in MicroStrategy - A Tutorial
http://www.youtube.com/watch?v=P5S6_0rrQ78 - Intelligent Cube Using Microstrategy 9.0.1 By Vamsi

How can we manually publish Intelligence Cubes?

  1. Launch Desktop
  2. Connect to the appropriate project source
  3. Drill down on the appropriate project
  4. Drill down on Public Objects -> Reports and select the folder that contains the report
  5. Click on the Search / Find icon on the top toolbar
  6. Click on the Object Types tab
  7. Click on the check box next to Intelligence Cubes
  8. Click on the Find Now button
  9. Double click on the the appropriate item in the search result area. This will run the cube report, and publish the cube. If there are multiple intelligence cubes that you need to refresh, you can press CTRL+A to select all matching intelligence cubes, or select multiple intelligence cubes using the CTRL + left click mechanism, and then you can right click and select "Run Report". This will run all the selected cube reports and publish the cubes.

How can we schedule cube refresh?

To reduce refresh time, you can opt for partial updates as you previously mentioned. Additionally you can schedule daily cube updates on off-business hours. To access this feature, you can right-click on the intelligent cube in Desktop, select "Schedule Delivery to…Refresh Cube." In the window that pops up, the drop-down menu to the right of "Schedule" will allow you to determine the frequency of cube refreshes, ie. "At Close of Business."

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License