topic Re: How do Export Cube view to excel? in SAS Enterprise Guide

How do Export Cube view to excel?

deleted_user — Fri, 14 Dec 2007 20:42:56 GMT

How do I export a cube view to excel and have it look like the screen? I can do this fine if I'm in the portal viewer but EG seems to lack this functionality.

Re: How do Export Cube view to excel?

ChrisHemedinger — Mon, 17 Dec 2007 14:20:50 GMT

In EG you can create a slice from your cube view, and then Export the slice to Excel (or other formats). It won't necessarily look exactly like your cube view though.

If you have the SAS Add-In for Microsoft Office, you can access your SAS OLAP data directly via the Excel pivot table.

Chris

Re: How do Export Cube view to excel?

ChrisHemedinger — Mon, 17 Dec 2007 14:26:44 GMT

There's another trick you can try that might get you what you want.

1. Navigate to the desired cube view.

2. In the EG project explorer, right-click on the cube item and select "Create Report Snapshot". This creates a SAS report item in your project that looks like an HTML-version of your cube view.

3. Right-click on the table portion of your cube view and select Copy.

4. Paste into an Excel worksheet.

Chris

Re: How do Export Cube view to excel?

deleted_user — Mon, 17 Dec 2007 21:30:17 GMT

Nice!
Thanks Chris.

Re: How do Export Cube view to excel?

deleted_user — Mon, 25 Oct 2010 06:53:28 GMT

Hi,

Is this still possible somehow in EG 4.2? The option 'create report snapshot' appears to be missing in the right mouse menu.

Thanks,
Rudolf.