Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Refresh one OLAP Cube toupdate multiple spreadsheets / pivottables
whether it is the methodology or the technology, it still doesn't answer the question. Not sure what an ETL is either. I thought the question was fairly simple... If I have a database in Access I can query it directly from Excel. I also have the option to build my query into an OLAP cube. If... -
Refresh one OLAP Cube toupdate multiple spreadsheets / pivottables
Access is the only software available to me at present within our organisation. I was more interested in the principle rather than the application. We have a dedicated Information Team, but they seem to think it's a good idea to put all the data in 100mb spreadsheets which my PC can barely... -
Refresh one OLAP Cube toupdate multiple spreadsheets / pivottables
Hi all, Tried asking this in a few excel forums but got no joy so I'm assuming this is more of an OLAP question. I am trying to get my head around OLAP. At present for our metrics analysis, our Information team populate huge unwieldy excel spreadsheets. The overall spreadsheet for the year to...
