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

Connecting to OLAP Data

To connect to and display OLAP data in Microsoft Data Analyzer, you must first create a view file, which is a special text file with the extension .max. The view file itself does not include any data from the OLAP data source. Rather, it contains details about the OLAP data source connection and about how to initially display the data in Data Analyzer. You create one view file for each way in which you want to initially view a particular OLAP data source in Data Analyzer. For instance, you would create one view file to connect to a specific offline cube file and display a dimension’s data initially as bars; you would create a different view file to connect to the same offline cube file and display the dimension’s data initially as a pie chart.

Note

You can also distribute a view file to other Data Analyzer users, provided the users have access to the associated OLAP data source. The view file contains information to connect to the data source; if other users cannot access the target OLAP data source with an application such as Excel, they won’t be able to use Data Analyzer to access the target OLAP data source either.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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