Tag: business intelligence

Angela Hall 0
Resolution of Text Fields in Stored Processes

So you modified the SAS EG character formatted constraints to resolve automatically with surrounding single-quotes. (Seen below from Stored Process Wizard and Management Console screens.)                 Of course, the pain now is trying to pass dynamic parameters through the %stpbegin & %stpend statements.

Angela Hall 0
SAS OLAP Data Provider Install Tip

Problems connecting to the SAS OLAP Server in MS EXCEL after downloading ONLY the SAS OLAP Data Provider on a virgin SAS Machine? When installing the SAS OLAP Data Provider for use in MS Excel Pivot Tables, be sure to use the Integrated Technologies for Windows download, rather than the

Angela Hall 0
OLAP Values - Size Limit Beware

MDX has a limit to the length of values used to query. Therefore, all OLAP data must maintain a format less than 256 characters in length. You can follow the steps below to reduce the size during PROC OLAP creation (using OLAP Cube Studio) and then regeneration using the PROC

1 32 33 34