• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 10. Leveraging the Power of OLAP... > Other Considerations When Using OLAP...

Other Considerations When Using OLAP Cubes

You have a few items to consider when using OLAP cubes. Note that OLAP is a rich and broad topic. These are just a few of the features.

Viewing an OLAP Cube Online

One of the tools provided in Excel allows you to display a spreadsheet or pivot table as a web page, and you can even make it interactive for the user. The same is true for working with an OLAP cube. Likewise, you can control whether opening the web page will force a refresh of the data, and you'll have the same formatting issues with numerical data and with charts. It's possible to create VBA code to handle the formatting for you. You can also export from the web page back down to a new Excel file for further analysis if so desired.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint