April 11, 2003 at 12:07 pm
Is there any way to export a cube (Analysis Manager browse data) to excel.
April 11, 2003 at 2:57 pm
Did you try using DTS by defining a source that is a cubed query?
Darren
Darren
April 13, 2003 at 5:43 am
Hi Shaki,
Yes, you can 'export' the cube to Excel (as a .cub file).
What you need to use is the Offline Cube Wizard within Excel. The way I got to this was to create a new excel crosstab report off the cube I wanted to bring locally. When the PivotTable menu was up in Excel, I then used the 'Add/Remove Buttons' of the toolbar to add the 'Offline OLAP' option to my toolbar. After adding this, you basically click it once and follow the wizard prompts.
Just remember, you've got to have enough disk space locally for the cube.
Hope this helps.
Steve.
Steve.
March 28, 2012 at 4:34 pm
Hi Shaki,
Is there any way to create offline cube (which holds Many to Many dimensions but none of the measures are from its intermediate measure group)I'm getting error while creating the local cube.
Any suggestions would be appreciated!!
~PM
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply