Hi I was going through the forum and i found this word Bucket field, could any one explain me what it means. thanx Kumar
Specifically, the term “bucket” is used in the implementation of SumIndexField Technology on the SQL Option for Financials/Attain as the name of the column in the “SIFT tables” that describes the level of aggregation used. It could also be used as a general term to define aggregations, for example in relation to OLAP (just like the SIFT could be regarded as a kind of OLAP). The implementation of SIFT is described in great detail in the Application Developer’s Guide (read it!), but here is a quick intro: For example: If a (secondary) key is defined as: “Account No.”, “Posting Date” with the SIFT field Amount the associated SIFT table on the SQL Server will contain the following 4 columns: bucket , f, f, s where: is the field number of the “Account No.” column, is the field number of the “Posting Date” column, is the field number of the Amount column The SIFT table on the SQL Server could look like this: bucket , f, f , s -------,-----,-----------------------,------- 1 , ‘A’ , ‘1753.01.01 00:00:00’ , 79.00 1 , ‘B’ , ‘1753.01.01 00:00:00’ , 899.00 … 2 , ‘A’ , ‘2001.01.01 00:00:00’ , 10.00 2 , ‘A’ , ‘2002.01.01 00:00:00’ , 11.00 2 , ‘B’ , ‘2000.01.01 00:00:00’ , 12.00 … 3 , ‘A’ , ‘2001.03.01 00:00:00’ , 3.00 3 , ‘A’ , ‘2001.06.01 00:00:00’ , 2.00 … 4 , ‘A’ , ‘2001.03.07 00:00:00’ , 1.00 4 , ‘A’ , ‘2001.03.26 00:00:00’ , 2.00 4 , ‘A’ , ‘2001.06.20 00:00:00’ , 2.00 The records with bucket = 1 defines aggregations for a single Account No. with no date filter. The date ‘1753.01.01’ is the representation of the “undefined date” (0D) on SQL Server. The records with bucket = 2 defines aggregations for a single Account No. with a date filter matching a whole year. The records with bucket = 3 defines aggregations for a single Account No. with a date filter matching a whole month. The records with bucket = 4 defines aggregations for a single Account No. with a date filter matching a single day. Regards - Jens
quote:
Originally posted by MVGS: Hi I was going through the forum and i found this word Bucket field, could any one explain me what it means. thanx Kumar