OWC11 Dimension Name

Y

yen

Hello,

I am now migrating from OWC10 to OWC11 and from SQL2000 to SQL2005.

Now i noticed that there is a different between them.

The dimension name in SQL2005 is different from SQL2000.

For example,

SQL2000 SQL2005
[Customer].[Name] [Customer].[Customer].[Name]

How can i replace the dimension name is the following statement for SQL2005?

PivotTable1.ActiveView.Filteraxis.FieldSets("Customer").Filed("Name") --
SQL2000

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Comparison of OWC10 and OWC11 1
OWC-XML Structure migration issues SQL2005 1
Timeout Issue 2
P2003 database migration, MSDE to SQL2005 0
OWC11 pivot table export to excel fail: missing tag row (seems to 0
SQL Connection String / Open Recordset via ADO 4
Insert name and adress from a list in a word document 1
OWC with SSAS 2005- Strange issue 0

Top