Newbie question

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

Moderator: Alex Zencovich

Newbie question

Postby Matt Dee » Sun Nov 05, 2006 10:40 pm

Hi, I'm trying to set the Pivot Cube up for the first time and I think there's something obvious I'm missing :)

I'm using a dataset with fields like so (this is simplified):

Table Location (Key) | Table Game (Dimension) | Table Dealer (Dimension) | Table Drop (Fact) | Table Win (Fact) | Table Hold (Fact)

I've set this as the FactTableDataSet property for the cube. Then I go through and add the following dimensions:

Table Location
KeyField := ''

Table Game
Key Field := Table Location

Table Dealer
Key Field := Table Location

Then I set up the following measures:

Table Drop
Table Win
Table Hold

and then build the cube.

When I try viewing it in the grid however, every record has the same value (1 or 0) and grouping does not seem to work. i.e. I can drag Table Game and then Table Location into the Row Tool Bar, so that I should see all tables grouped by table game, but each group has every single table in it.

Any help would be very much appreciated at this point :-)

Cheers,

Matt.

p.s. I'm setting this all up in code, not using the designers.
Matt Dee
User
 
Posts: 15
Joined: Sun Nov 05, 2006 9:11 pm

Postby AlexZencovich » Mon Nov 06, 2006 7:52 am

Please check if you set ALL required fields for dimensions

FieldName = Main facts table Key (dimension key - foreign key for dimension table)
LookupField = String field in dimension table
KeyField - Key field in dimension table

If you have single table(facttable) then all fields should be equal to FieldName
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 Matt Dee » Tue Nov 07, 2006 2:46 am

Ok that was horribly embrassing, I was passing the Cube a TDataset made up entirely of strings (was exported badly) hence the 1s and 0s.

:oops:

Sorry bout that....

Looks good now :-)
Matt Dee
User
 
Posts: 15
Joined: Sun Nov 05, 2006 9:11 pm


Return to PivotCube VCL

Who is online

Users browsing this forum: No registered users and 1 guest

cron