November 28, 2006 at 11:17 am
I have a PivotTable with an information from an Access Data Base but when I try to convert it to a cube file I can't cause the option Offline OLAP is not enabled and I don't Know if I'm doing something wrong, or if I have to install any component to enable that option.
November 28, 2006 at 12:40 pm
I thought you could only do this (create offline) in the pivottable when it's based on an OLAP cube to begin with? An alternate approach you could take is to go back through Microsoft Query (you know how this kicks in when you start a new DB query in Excel). From here, when you are finished with the query that is to bring back the data, one of the options is to build a cube file (*.cub) with the data.
Steve.
November 28, 2006 at 2:09 pm
I am trying to create a file (*.cub) but I can't. In the explanation that I found in the web it says that I have to select the PivotTable that I have in Excel, and in PivotTable Tool click PivotTable Option and select Offline OLAP and then select the option to create the offline cub file.
But I haven't seen those options because Offline OLAP option is enabled in PivotTable Tool.
November 28, 2006 at 3:25 pm
In your original post you indicated that you had a pivottable based on MSAccess data. As I alluded to in my earlier post, if you have a pivottable built on an OLAP cube, then you can save directly to 'offline'. If you've built the pivottable off a database (or even a spreadsheet in Excel) then this option isn't available.
If you go through the External Data Wizard again (the way you normally get data in to an excel spreadsheet from MSAccess), the second to last step in the wizard should ask you if you'd like to 1) return the data to excel; 2) view the data in Msft Query; or 3) create a local cube (cub) file. Selecting the local cube file option will let you build a local *.cub file.
Steve.
November 28, 2006 at 4:48 pm
In my computer I couldn't do that, because that procedure displays an error at the end and it says that it couldn't save the cube file because of something, but I tried it in other compurer and it worked.
Thank you very much!
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply