Tag: Uncategorized

Adding Negative Solve Orders to OLAP Calculated Members

OLAP Calculated Members need to be tested to ensure that the numbers are correct in various tools. What we recently found was that the member tested properly in the OLAP Studio View Cube but then in Web Report Studio, the measure wasn’t correct. Essent…

DI Studio Code Importer for Comments

In DI Studio 4.3, SAS offers a code importer utility that can assist with moving legacy SAS code into an enterprise DI environment. The importer uses PROC SCAPROC to analyze and translate the code into DI Studio components. There is also a neat utility…

SAS truncates SQL columns to length 1024

At first I thought SAS was giving me errors because the input data was malformed. Before I found data entry operators typing invalid dates such as “3/30/33/2009″ : NOTE: Invalid argument to function INPUT at line 1248 column 26 NOTE: Mathem…