OLAP Pivot Table in Excel 2000. 1

[Mikey2000]

I am using an OLAP pivot table in Excel 2000, and I understand some of the functionality of the pivot table is lost when compared to a non-OLAP pivot table.

With a non-OLAP pivot table, I had the functionality of going into the settings of a field and hiding values. For example, if I had data from 2000 through 2002 and I wanted to look at just data from 2002 and 2001, I could hide the data from 2000 by going into the field settings of the "Year" field. This is no longer an option when using the OLAP pivot table.

Does anyone know of a way around this, or if the functionality is available in Excel 2002?

 

[DrewConn]

Try making a pivot table on your existing pivot table and selecting the values to hide in your new one

Otherwise time to upgrade Mikey2000

 

[DiegoErnesto]

First, you should understand that the non-OLAP Pivot-Table is for few data, The OLAP pivot table is for read data from OLAP cube that is a datamart, or pre-calculated totals because is many-many data.

If you have 2000, 20001 and 20002, You can see only 2001 and 2002 but the total doesn't change, because this total is pre-calculated and came from OLAP-cube, no calculated in that moment.

When you click in down-button (right information title) display the content of same, and you have check box that indicates see or not see.


bye and good luck

 

[Rob999]

I'm using Excel 2002 accessing SQL Server 2000 cube files and I DO have the ability to go into the various Dimensions and and select/deselect things like years, regions, levels of profitability, etc.

I don't know if this is new to Excel 2002 because I only used Excel 2000 very briefly - 8,000 rows of unique data vs. Excel 2002's 32,500 rows.

 

[clydie]

Hi,

I have exactly the same problem. I have 10500 rows in my OLAP cube, and I receive the same message.

It is definitely not the OLAP cube, because it does open in Proclarity and Data Analyser.

Was this problem solved or is it still an on-going issue?

I would appreciate any suggestions.

Thanks

 

[Mikey2000]

To handle the problem I originally posted, I decided to upgrade to Excel XP (2002). This new version allows a user to select multiple items from a drop down list of dimension values. I did not find another of doing this in any older version of Excel.

There are a number of additional new features offered in the new version of Excel, and the majority of them relate to OLAP pivot tables. Below is a link which describes these new features.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnexcl2k2/html/odc_XLOWCOlap.asp

I hope this helps.