Excel Pivot

Hi,

I have developed a cube in AS 2005. I am accesing the Cube from Excel. In Cube Design I have grouped the Measures under different folders with 'DisplayFolder' Feature as I have about 100 measures.

When I access the measures from Excel, the folders are not displayed but the entire list of 100 measures. Is there anyway to group the measures together in folders such as sales, assets, profit etc.?

Thanks for the help.

Regards

Josh

Hello! If you are using Excel2003 i do not think that there is a solution.

If you use Excel2007 as a client they will show up in the display folders. Calculated members, however, will have to be mapped to display folders in the calculations properties dialoge. It is a small property button in the calculations tab in the cube editor.

HTH

Thomas Ivarsson

|||

Hi Thomas,

Thanks for your quick reply.

I am using Excel 2002 ;(

I will check with the upgrade and see what happens. BTW, I have couple more questions related to the same.:

- How can I use suppress values=0 (without using Autofilters)

- Is it possible to insert columns or rows in the pivot (which are not measures or dimensions)? The user wants to insert a column to do some calculations.

I would appreciate your reply on the same. Thanks a lot in advance.

Regards

Josh

|||

Hello.

To supress values = 0, I think you can only use FILTER() fór that. NON EMPTY will only suppress nulls.

Mosha have a good post here: http://www.sqljunkies.com/WebLog/mosha/archive/2007/03/07/averages_ratios_division_by_zero_non_empty_behavior.aspx

, that recommend you to aviod zeros in the cube.

You can insert columns and rows only if you do not use the pivot tables(In Excel2007). You will have to convert the pivot table to formulas. It is not possible to have both.

HTH

Thomas Ivarsson