Total column show

Discussion forum for PivotCubeX component. Common usage questions. Bug and problem reports

Moderator: Alex Zencovich

Total column show

Postby fabiano » Fri Jul 21, 2006 1:11 pm

3 dimension:

D1
+D2
+D3

I need total show columns in D2 or D3 with and without filter by user.

tanks.
fabiano
User
 
Posts: 16
Joined: Fri Jul 07, 2006 8:04 pm

Postby AlexZencovich » Fri Jul 21, 2006 2:15 pm

Please describe your questions little detail. There is no way to provide help if I cannot understand what you ask
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 fabiano » Fri Jul 21, 2006 2:45 pm

Dimension D1
Dimension D2

-Value D1 - 05
.........Value D2 - 01
.........Value D2 - 02
.........Value D2 - 03
- Value D1 - 06
.........Value D2 - 02
.........Value D2 - 03
.........Value D2 - 04
.........Value D2 - 06

Total rows D2 in D1 05 = 03
Total rows D2 in D1 06 = 04

If user filter D2 with > 02 then

Total rows D2 in D1 05 = 01
Total rows D2 in D1 06 = 03

I need show this totals of row in D2 for users.

tanks.
fabiano
User
 
Posts: 16
Joined: Fri Jul 07, 2006 8:04 pm

Postby AlexZencovich » Fri Jul 21, 2006 3:08 pm

You need to use OnGetVellValue event to replace cell value with your own count.
Use PCX.MapGetCellInfo to get information about number of cells in inner dimension
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 fabiano » Fri Jul 21, 2006 5:46 pm

I dont find MapGetCellInfo in object pivotcube.
fabiano
User
 
Posts: 16
Joined: Fri Jul 07, 2006 8:04 pm

Postby AlexZencovich » Fri Jul 21, 2006 6:10 pm

Sorry, it must MapGetRowCellInfo and MapGetColumnCellInfo

See details here
http://pivotcube.com/forum/viewtopic.php?t=24
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 fabiano » Sat Jul 22, 2006 6:00 pm

Ok good option, but:

onrowheaderdbclick parameters (x,y) no equal MapGetRowCellInfo parameters (CellIndex and DimIndex).

I need click in row header (onrowheaderdbclick) and see row total (MapGetRowCellInfo).

Or another suggestion.
fabiano
User
 
Posts: 16
Joined: Fri Jul 07, 2006 8:04 pm

Postby fabiano » Wed Jul 26, 2006 10:14 pm

No suggestion for this problem?
fabiano
User
 
Posts: 16
Joined: Fri Jul 07, 2006 8:04 pm

Postby AlexZencovich » Thu Jul 27, 2006 4:59 am

Sorry no. I will add way to solve problem in next build (in few days).
It will require to use Cell.Position parameter as index (that property does not accessible in PivotCubeX now, but I will add access)
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 fabiano » Thu Aug 03, 2006 1:04 pm

Tanks,

The component is excellent, and the wonderful support.
fabiano
User
 
Posts: 16
Joined: Fri Jul 07, 2006 8:04 pm


Return to PivotCube ActiveX

Who is online

Users browsing this forum: No registered users and 1 guest

cron