SAS recommends building OLAP Cubes on a separate 'non-production schemas' because cube building can be resource intensive and time consuming. Each OLAP Server can be defined to one & only schema at a given time, therefore you will need to setup the architecture to include another OLAP Server & Schema
Tag: business intelligence
When creating an OLAP Cube from a Star Schema table, the Dimensions / Hierarchies created must be free of all blanks. This is because the name is used as a table alias in the SQL Join. The obvious error in the resulting code example below: proc sql; create table geography
Was assisting an individual with an issue on the SAS Discussion Forum and we discovered why some users would not get the prompt to save/view excel content in excel rather than in the web browser. Essentially, the file type options were different for these users. This was causing users to
Last month, the SAS Global Certification program added a new credential, the SAS Certified BI Content Developer. My first blog post from May described how a global team of BI experts collaborated to create the beta exam. In May and June, candidates from a broad background of experience (novice to
SAS allows for three different cube storage mechanisms: 1. MOLAP The traditional SAS OLAP Cube will all aggregations / nway stored on a physical file structure accessible by the SAS OLAP Cube Server. 2. ROLAP A relational OLAP cube - where no aggregations are stored and SAS points to the
The ODS ExcelXP tagset is pretty powerful stuff. Hidding columns, changing the print layout to landscape, updating the spreadsheet names, defining the default column width and row height, etc - it's all available using options within the ExcelXP setup. So the best thing to do is grab some documentation. Fortunetly,
What if you need someplace to store static files for web consumption. Things that might come to mind: Images HTML Static Title Pages JavaScript PDF Documentation (such as how-to instructions) An ideal place would be a HTML server, since these aren't active files. However in a standard 9.2 installation, there
When viewing OLAP cubes in Web Report Studio, there comes a time when the user might want to view all the levels within the hierarchy, without the cumbersome process of selecting and expanding each individual item. In 9.2, there is a quick solution. When you right click on the level-heading
The %STPBegin and %STPEnd macros are pretty powerful pieces of code for SAS Stored Processes. They embed all sorts of information on devices, where content is located, and just make everything work. However for creating those fancy custom HTML forms or layouts, ods html is needed instead. I've written about
Using ActiveX in SAS graphics provides users with more functionality, options, and pretty colors than Jpeg, gif, etc (check out these examples). The issue is that ActiveX requires a device driver installed on the viewing machine, similar to Flash. In SAS 9.2, the sasgraph.exe is available within the SASWEB component deployed