Newbie question

[Matt Dee]

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.

[AlexZencovich]

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

[Matt Dee]

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.



Sorry bout that....

Looks good now