How to reach the Dimension Key inside PivotMapCustomMeasure

Discussion forum for PivotCube VCL users. Common questions. Bug and problem reports

Moderator: Alex Zencovich

How to reach the Dimension Key inside PivotMapCustomMeasure

Postby velislav » Wed Feb 15, 2012 1:14 pm

the full title is (the system shortened it)
How to reach the Dimension Key inside PivotMapCustomMeasure in a single-dimension cube case


Suppose we have a very simple fact table : id | parentid | area | population.
We construct a PivotCube with 1 dimension -> area and 1 measure -> population with CalcType = ctCustom
the dimension is made hierarchical by a clone of the fact table
next we create a PivotMap with one row -> the area dimension
next we create a PivotGrid for the map
next we add PivotMap.OnCustomMeasure event in order to manipulate data at the moment of constructing the map

is it posible to get area.key value inside PivotMap.OnCustomMeasure while calculating the corresponding measure, having in mind the above restrictions (i.e. single dimension but reordered by hierarchical ordering)?
velislav
User
 
Posts: 5
Joined: Tue Jun 23, 2009 1:16 pm

Re: How to reach the Dimension Key inside PivotMapCustomMeas

Postby velislav » Tue Feb 28, 2012 9:11 am

Is this forum still alive :?:
velislav
User
 
Posts: 5
Joined: Tue Jun 23, 2009 1:16 pm

Re: How to reach the Dimension Key inside PivotMapCustomMeas

Postby AlexZencovich » Tue Feb 28, 2012 7:34 pm

Sorry for delay. And sorry, that is impossible. That event called from kernel when and due to perfomance reasons the dimension item key(as same as even dimension itself) is just unavailable for time when it called.
Best regards,

Alex Zencovich
-------------------------------------------------------------------------------------------------------------------------------------------
www.pivotcube.com - OLAP solution for Delphi, C++ Builder and ActiveX environment
AlexZencovich
Site Admin
 
Posts: 580
Joined: Sun Jun 18, 2006 10:09 am


Return to PivotCube VCL

Who is online

Users browsing this forum: No registered users and 3 guests

cron