T
TKEMotown
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?
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?