Hello, Nair!
You wrote on Mon, 7 Jul 2003 02:32:38 -0700:

N> I would like to know the limitation of Excel Pivot Table
N> on using/ implementing MS OLAP features.

N> Can anyone help me !!!

N> Thanks in advance.

I'm also interested in this question
Here is my current list of limitations:

1. No support for calculated members in dimensions other than 'Measures'
2. Excel always hides empty rows and columns.
3. Very low performance (this is probably connected with point 2)
4. No support for FormatString property (for example no possibility to
display percentage properly).
5. Unexpected results in some situations when using calculated cells

With best regards, Andrew Surinov. E-mail: sav (AT) tut (DOT) by

Corrections...



tom @ the domain below
www.tomchester.net


"Andrew Surinov" <sav (AT) tut (DOT) by> wrote

Hello, Tom!

All right, Excel XP supports calculated members, only if you specify parent
members for them
What is the setting to show emty rows and columns?


??>>> 1. No support for calculated members in dimensions other than
??>>> 'Measures'
TC> I believe this was fixed in XP

??>>> 2. Excel always hides empty rows and columns
TC> There is a setting to change this behavoir.

Hey Andrew,

Can't find the setting, I take it back! ;(

tom @ the domain below
www.tomchester.net


"Andrew Surinov" <sav (AT) tut (DOT) by> wrote

Andrew

If you are not able to solve your problem showing empty rows or columns
using PivotTables then please contact me as we can solve this for you. We
can also help you with other member selection issues.

Howard
www.o2olap.com


"Andrew Surinov" <sav (AT) tut (DOT) by> wrote

Hi Tom,

Can you tell us where to change the behavoir?