Is there a way we can sort a listing in WRS on a Hidden Column(Which has the Desired order)?? I have to retain a specific order of values in the report (not in alphabetical order) and I cannot find a way to do that. Thank You. ... View more

I am trying to apply a user defined format on a measure in my cube.After creating the format, I have added this to my proc olap code. libname pr 'D:\Program Files\SAS\Config\Lev1\SASAPP\SASEnvironment\SASFormats'; options fmtsearch=(pr); However this does not seem to have any affect on the measures in my cube , after some investigation I have came across this SAS Document. http://support.sas.com/kb/11/390.html Assuming that my format is similiar to the one that is shown in the document proc format ; value NACOMMA . = 'NA' other=[comma15.] ; run; I Have created a calculated member as per the document, but I am getting an error message "Formula error - The format specified in the PUT function is invalid or not found - in the "PUT" function" Since I have placed the format in the specified directory this should be available to all the applications, Please let me know what could be the issue. ... View more

My Cube has all Non-Additive measures, My requirement is such that the Value for any measure for any combination with any Level of the Time Dimension would be that of the last day of that Level. For Example. the Value for the year 2008 for a particular measure would be the Value of the measure on 31 Dec 2008, the same applies to the Quarters and Months. I have created external summary tables which are used to create aggregation at various levels these are giving expected results. I was wondering if there is a better way to do this since the number of summary tables that have to be created grows exponentially on the number of Dimensions and Levels in the cube. Regards, Raj ... View more

When trying to access SAS cube from the OLAP viewer the root folder (The default and the only folder) in the Available Items pane is reflecting a numeric extension to the cube name. For ex. I have created a cube named CUBE_Exposure, when the cube is accessed from the Web OLAP Viewer the name of the cube is appearing as CUBE_EXPOSURE_1285654880720. The same happens is with all the cubes though the numbers seem to be random. Is there any way to remove/rename those numbers? Regards, Raj ... View more