PivotTable and OLAP: how to reach attribute properties?
 

Hello @all,

at the present I write an Excel add-in, which should be used to visualize
the data from pivot table (connected to OLAP cube) on the Virtual Earth.
Language is VB.NET, development environment VS 2008. The "map"-related part
of the add-i ist not a problem. Processing of the pivot table is more
problematic.

As a simplest example, I have one dimension with 4 attributes: ID(=PK),
CountryName, Latitude and Longitude. I want to use
(Latitude;Longitude)-values (which are attribute properties in the cube) to
place a pinpoint on the map. I can iterate through all pivot fields and their
items, but I see no way to reach the properties of the corresponding item.
The PivotItem interface offers no methods or properties to achieve it.

Can anyone give me any hint?

Thanks a lot in advance,
Andrey