Hi there, There is a command called REFRESH CUBE that enables you to refresh a cube on an OLAP Server. Please see SAS(R) 9.4 OLAP Server: User's Guide, Third Edition. I hope this helps. Best Regards, Donna L.
... View more
Also, see the topic "SAS OLAP Cube Size Specifications" in the SAS OLAP Server User's Guide. This topic discusses size specifications for dimensions, hierarchies, levels, measures and properties.
... View more
Also, see the topic "SAS OLAP Cube Size Specifications" in the SAS OLAP Server User's Guide. This topic discusses size specifications for dimensions, hierarchies, levels, measures and properties.
... View more
There are some topics in the SAS OLAP Server User's Guide that may also be of use. See the topics: Accessing OLAP Cubes from SAS : SQL Pass-Through Facility for OLAP Connecting to a SAS OLAP Server Using the OLEDB Protocol
... View more
There are some topics in the SAS OLAP Server User's Guide that may also be of use. See the topics: Accessing OLAP Cubes from SAS : SQL Pass-Through Facility for OLAP Connecting to a SAS OLAP Server Using the OLEDB Protocol Note: the SQLRC macro will also let you validate the success of your Proc SQL connection. This willbe documented in the 9.4 release.
... View more