I opened a ticket with SAS support and this info may be useful.. although not really a solution: The SAS Enterprise Guide OLAP Analyzer uses the followinglogic to determine which dimensions will be placed on rows or columns: Do until a dimension is placed on Columns If a TYPE = TIMEdimension exists, place it on columns Else if adimension with the name "customer", "geog","account", "product", "market","employee" or "store" exists, place it on columns Else select thefirst dimension defined to metadata that does not have TYPE = GEO. Do until a dimension is placed on Rows If a TYPE = GEOdimension exists, place it on columns Else if adimension with the name "customer", "geog","account", "product", "market","employee" or "store" exists and is not already used incolumns, place it on rows Else select thefirst dimension defined to metadata that does not have TYPE = TIME and is notalready used on columns. Calculated members will not be selected by default forthe display in any client. The default measure will always be selected based onthe DEFAULT option in your MEASURE statements. Another option available - you can create a view and savethat view within the SAS Enterprise Guide OLAP Analyzer or as a spreadsheet inMicrosoft Excel. If that project/workbook is opened again, that view will bepreserved.
... View more