Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Creating Inferred Dimension Members with SSIS Expand / Collapse
Author
Message
Posted Monday, January 21, 2013 4:29 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, March 14, 2014 3:10 AM
Points: 1, Visits: 33
Hi Robert, this is a great article and elegant way to add inferred dimension.

Just wanted to know how was BKColumnList planned to be used?
Post #1409476
Posted Monday, January 21, 2013 8:35 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, September 8, 2014 11:32 AM
Points: 106, Visits: 289
Hello,

BKColumnList is a comma separated list of the fields that make up the business key or natural key of your dimension. The sample uses a single field (Product_Nbr) as the business key. However, dimensions may use a composite business key. For example, the business key of the sample dimension could have been the combination of Product_Nbr and Product_Name, in which case the value of BKColumnList would be "Product_Nbr, Product_Name".
Post #1409587
Posted Monday, February 11, 2013 1:42 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, February 4, 2014 5:40 AM
Points: 10, Visits: 184
Nice article!
Plain, Simple, Clear, and To the Point!
Thanks for sharing :)


Dattatrey Sindol
Blog: Datta's Ramblings on Business Intelligence 'N' Life

This information is provided "AS IS" with no warranties, and confers no rights.
Post #1418252
Posted Monday, March 24, 2014 2:20 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Yesterday @ 8:59 PM
Points: 6, Visits: 273
Very good and well written article. Would it be possible to get the SSIS solution files uploaded to the site ?
Post #1554211
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse