|
TT04 The SAS Multidimensional Report Viewer(MRV) is a web-based tool that provides a way to create reports from multidimensional data bases (MDDBs). It is great out-of- the-box solution that allows users to quickly provide web-reports to an organization. Ho wever, we had client needs that required us to go inside the MRV, to dramatically change its appearance and functionality. The ability to customize the MRV through object-oriented techniques has been described by previous authors. In this paper we presen t specific customizations to the MRV that we made for various clients. First, we describe how, using the method overrides and instance variables, we construct syntactically correct WHERE clauses based on the current status of the MRV and show how this can be used to query SAS tables. Also, we describe how to override the output of the MRV in order to display additional information from extra titles to complete new tables using simple ODS and Data NULL processing. In addition, we also offer a simple print solution using SAS ODS RTF output to circumvent the web browser printing limitations. Finally, we demonstrate the methods overrides needed in order to utilize SAVE variables in a session environment. |