A alwin Oct 9, 2008 #1 Can we set up connection to SQL server analysis service (Cube) from access 2007?
K Klatuu Oct 9, 2008 #2 I don't think so. an OLAP cube is hiarchical data. You will need to use Excel. If you need the data in Access, you can first create your cube data in Excel, then import the data from Excel into Access.
I don't think so. an OLAP cube is hiarchical data. You will need to use Excel. If you need the data in Access, you can first create your cube data in Excel, then import the data from Excel into Access.