June 3, 2008 at 10:47 am
I have built a financial cube to automate periodical reporting. The cube pulls data from several companies' SQL databases. 'Gross Margin' calc member was introduced, with the following formula:
[GL Account Master].[Account Category].&[Sales Revenue]-[GL Account Master].[Account Category].&[Cost of Sales]
When I build a pivot within the Visual Studio environment (in the OLAP browser) or using WebParts, the 'Gross Margin' field collapses nicely. Upon importing the pivot to Excel (either 2003 or 2007) or after building the same pivot in Excel from scratch, I have tried to collapse the field which resulted in the following error:
Cannot show or hide detail for this selection
This message can appear when:
You are looking at either the highest or lowest level of detail for a given dimension or field in a PivotTable report, and no more information is available.
You are looking for data in an empty cell.
June 5, 2008 at 6:51 am
I'm not quite sure what you mean by 'collapses nicely'.
However, AFAIK by default you can not get details for a calculated member when using a XL-pivot on a SSAS cube.
Hope this helps.
Peter Rijs
BI Consultant, The Netherlands
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply