OWC pivot & OLAP

E

Effie

Hi!
i'm trying to connect to a cube via owc/pivot.
the connection is working, and i can add fields manualy to the grid by
dragging.
How can i pre define (by code) what fields will be loaded?
this command--> pivot.DisplayFieldList = true
display the fields and i can drag them.

this command --> PivotView.FilterAxis.InsertFieldSet
PivotView.Fieldsets([year])
do not placing the year field on the filter grid (no error)

TIA, Effie
 

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

Top