Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table - "duplicate dimensions across (independent) axes"
I'm trying to create reports using pivot tables in Excel that access OLAP
cubes. I have 8 reports, (spreadsheets), that I run using a Visual Basic script in another Excell spreadsheet. This Master spreadsheet accesses the other 8 reports and loops through regions and districts to create reports for each store. This worked fine until the data for the Regions changed which caused our structrue in the pivot tables to be altered. Previously it looked like this: [Region 1 North East].[District 01].[Store 1] Now it looks like this: [Region 1 East].[District 01].[Store 1] And now when I try to run the reports I get a message that says: "Formula error - duplicate dimensions across (independent) axes - in a <tuple base object" I worked with our data warehouse people and they determined that somehow the MDX code that creates or refreshes the pivot table is some how causing this. Though like I mentioned this worked fine until the data in the Region changed, and I have not changed the way the pivot tables are set up other than to refresh the data in them to get the new structure mentioned above. Is there an easy way to see the MDX code behind a pivot table? Is there a way to modify it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create Pivot Table Data with Column "Sum" rather than "count" defa | Excel Discussion (Misc queries) | |||
Pivot Table Report Filter - "OR" instead of "AND" Multiple Filters | Excel Discussion (Misc queries) | |||
Pivot table "Group and Show Details" vs. "SubTotals" | Excel Programming | |||
OfficeXP "Cannot open pivot table source file" when refreshing pivot table | Excel Programming | |||
Help required with setting up a pivot table with the source on sheet1 to have the pivot table created on sheet called "report" | Excel Programming |