View string value in measures

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

Moderator: Alex Zencovich

View string value in measures

Postby Iton » Fri Nov 10, 2006 12:49 pm

How i can vew string value in measures?
for ex.
in my facttable i have some fields. one of this fields has type StringField
in PivotCube. MEasures my field have datatype as ftString, calc type - ctSumma . but when i run my prog i can`t see normal values in this measures (must be 123 - 45 for ex., but i see 1.00)

sorry my English :(
Iton
User
 
Posts: 11
Joined: Wed Sep 27, 2006 5:49 pm

Postby AlexZencovich » Fri Nov 10, 2006 1:47 pm

There are no way to put strings as measures to PivotCube because there are no common way to aggregate them if it required (for example if you have 5 strings for some dimension row/column combination)

You may override TPivotGrid.OnGetDataCellValue event to put any string value into grid cell, but algorithm which you will use to get that string should be written in your task-specific code
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

Postby Iton » Fri Nov 10, 2006 2:00 pm

please view example for me
Iton
User
 
Posts: 11
Joined: Wed Sep 27, 2006 5:49 pm

Postby AlexZencovich » Fri Nov 10, 2006 5:07 pm

You may found event code example in demo app which come with package. It replace 0 values with string 'empty' and do lot os additional things with colouring etc
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 5 guests

cron