G
Guest
hi,
I have a pivot table report based on an olap cube, created by the pivot
table wizard. In my report, I have a page field called [date]. I want to
programmically add pageitems for display, based on a date range declared by
the user. This is my code:
activesheet.pivottables(1).pagefields("[Date]").currentpagelist =
Array("[date].[all date].[2002]","[date].[all date].[2003].[January]",
"[date].[all date].[February].[1]")
The problem is, if one of the items declared does not exist in the cube, an
error will be returned. Anyway I can exclude invalid items from the lsit or
to detect whether the items exist or not? By the way, I am unable to use the
PivotItems method to get the page items as it is from an Olap cube.
Thanks
I have a pivot table report based on an olap cube, created by the pivot
table wizard. In my report, I have a page field called [date]. I want to
programmically add pageitems for display, based on a date range declared by
the user. This is my code:
activesheet.pivottables(1).pagefields("[Date]").currentpagelist =
Array("[date].[all date].[2002]","[date].[all date].[2003].[January]",
"[date].[all date].[February].[1]")
The problem is, if one of the items declared does not exist in the cube, an
error will be returned. Anyway I can exclude invalid items from the lsit or
to detect whether the items exist or not? By the way, I am unable to use the
PivotItems method to get the page items as it is from an Olap cube.
Thanks