https://communities.sas.com/t5/SAS-Data-Management/SAS-OLAP-studio/m-p/44189#M382 OLAP cubes may be built in a wizard driven environment with no coding required. You don't necessarily need to build a model in order to build the cube. The wizards will guide you through creating metrics, dimensions and hierarchies.<BR /> <BR /> Documentation on OLAP is available here: <A href="http://support.sas.com/documentation/cdl/en/olapug/59574/HTML/default/viewer.htm#a002255372.htm" target="_blank">http://support.sas.com/documentation/cdl/en/olapug/59574/HTML/default/viewer.htm#a002255372.htm</A> Fri, 08 Apr 2011 13:51:03 GMT TimStearn_SASProductManagement_ 2011-04-08T13:51:03Z https://communities.sas.com/t5/SAS-Data-Management/SAS-OLAP-studio/m-p/44188#M381 Can anyboby explain the details of the OLAP TOOL?<BR /> 1. How the olap cube build in the studio? does this require the coding effort?<BR /> 2.how the dimenssional model can be done? does this need coding effort?<BR /> <BR /> 3. any sas tool or other tool to perform the dimenssional modeling,<BR /> thanks, Message was edited by: jdk123 Tue, 05 Apr 2011 14:09:41 GMT https://communities.sas.com/t5/SAS-Data-Management/SAS-OLAP-studio/m-p/44188#M381 jdk123 2011-04-05T14:09:41Z https://communities.sas.com/t5/SAS-Data-Management/SAS-OLAP-studio/m-p/44189#M382 OLAP cubes may be built in a wizard driven environment with no coding required. You don't necessarily need to build a model in order to build the cube. The wizards will guide you through creating metrics, dimensions and hierarchies.<BR /> <BR /> Documentation on OLAP is available here: <A href="http://support.sas.com/documentation/cdl/en/olapug/59574/HTML/default/viewer.htm#a002255372.htm" target="_blank">http://support.sas.com/documentation/cdl/en/olapug/59574/HTML/default/viewer.htm#a002255372.htm</A> Fri, 08 Apr 2011 13:51:03 GMT https://communities.sas.com/t5/SAS-Data-Management/SAS-OLAP-studio/m-p/44189#M382 TimStearn_SASProductManagement_ 2011-04-08T13:51:03Z https://communities.sas.com/t5/SAS-Data-Management/SAS-OLAP-studio/m-p/44190#M383 When building OLAP cubes, you could use a star schema as input, which often is preferred from a performance standpoint.<BR /> <BR /> There is no modelling tool in SAS. For modelling you could use tools like MS Visio or CA ERwin.<BR /> <BR /> Once created, they can be imported/generated in SAS. For populating the dimensional model/star schema, the most appropriate tool (if available) is Data Integration Studio.<BR /> <BR /> /Linus Wed, 13 Apr 2011 14:37:06 GMT https://communities.sas.com/t5/SAS-Data-Management/SAS-OLAP-studio/m-p/44190#M383 LinusH 2011-04-13T14:37:06Z