July 29, 2008 at 7:04 am
Is there a way we can gen or snapshot off an Excel Pivot Table from an SSAS cube --
Excel pivot table would not have a live connection to SSAS but would be an emailable
report view of a portion of SSAS ( aside from using OfficeWriter )
July 29, 2008 at 8:41 am
Just disconnect the workbook.
In Excel 2007, click the Data tab.
Click connections.
Select the connection (or each connection if there are multiple).
Click remove.
You will not be able to continue to use the pivot tools (obviously), but the current viewable data will remain in the worksheet.
August 11, 2008 at 2:24 pm
What kind of memory would be necessary to generate a Pivot Table say
for the Excel 2003 row maximum from SSAS? On current rig I am
snowing to a crawl at 20,000 rows.
Thanks very much --
August 11, 2008 at 2:33 pm
That will depend on a lot of factors.
Usually, most of the work is done at the Analysis Services end, so the memory needed on the client end is not much. However, Excel does some odd things and may return all data in rows or columns and then pivot it again once it is at the client. This is done for a bunch of different reasons and is really hard to anticipate. When this happens, it can be a bit more memory-intensive.
You should download the OLAP PivotTable Extensions for Excel (it's free - search google for it) so you can see the MDX. Check if it is the client or server taking so long.
August 12, 2008 at 11:44 am
It requires VSTO toolkit second edition. I followed the link and downloaded it and the
executable would not run on my virtual machine running off a Vista server. Am trying
the extensions without it and things are performing the same for the procedure I had been
following:
1-Insert a pivot table
2-Set SSAS/test cube as the data source
3-lay out the rows, cols, results.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply