Repeating attribute member in Excel 2007

I'm accessing SSAS 2005 cube with Excel 2007. In the pivot table, let's say that I pull premium by policy year, policy month.

The display in the pivot table would be like the following.

policy year policy month premium

2007 Jan 2,000,000

Feb 1,000,000

Mar 1,500,000

How can I repeat 2007 in the pivot table so that it would look like the following?

policy year policy month premium

2007 Jan 2,000,000

2007 Feb 1,000,000

2007 Mar 1,500,000

By repeating the attribute member in Excel 2007, my user can easily export the pivot table into a data set.

Mitch

One way to solve this is to make a SSRS2005 report with the SSAS2005 cube as a data source.

In Reporting Service you can control if a group member name should be repeated for each child or not.

Users can export this report to Excel.

I have not seen a solution in Excel 2007 pivot tables, more than allowing drill-through actions on cells, and let users get the leaf transactions behind that cell value.

HTH

Thomas Ivarsson

|||

Thomas,

Thanks for the feedback. For me, SSRS is not an option because my users want to create these data sets on the fly within Pivot table. I'll just let them know the feature is not there yet for now.

Mitch