PivotTables based on OLAP cubes don't use standard pivot table objects (i.e. .pivotfields().pivotfields().visible). I have been unsuccessful in finding any decent documentation. When you record a macro it uses .treeviewcontrol.hidden and .treeviewcontrol.drilled - help says these objects are for use only when recording a macro plus they are ugly looking array definitions that will require implicit knowledge of the cube structure.
I want to pull data from this cube based on user input for a specific week that is imbedded in a [year].[quarter].[month].[year] level structure. Do I need to go to a SQL type query or is there a way to do something like a .pivotitem("week_I_want"
.visible with OLAP cubes?
Thanks
JMT
I want to pull data from this cube based on user input for a specific week that is imbedded in a [year].[quarter].[month].[year] level structure. Do I need to go to a SQL type query or is there a way to do something like a .pivotitem("week_I_want"
.visible with OLAP cubes?Thanks
JMT
