Creating Inferred Dimension Members with SSIS

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Robert Rubocki » Creating Inferred Dimension Members with SSIS...

13 posts, Page 2 of 2

««1 2

Creating Inferred Dimension Members with SSIS

Rate Topic

Display Mode

Topic Options

Author

Message

ksreekumar_1

Posted Monday, January 21, 2013 4:29 AM

Forum Newbie

Group: General Forum Members
Last Login: Sunday, April 21, 2013 3:50 AM
Points: 1, Visits: 23

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

rrubocki

Posted Monday, January 21, 2013 8:35 AM

SSC Journeyman

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 2:02 PM
Points: 97, Visits: 240

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

Dattatrey SIndol

Posted Monday, February 11, 2013 1:42 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, February 11, 2013 1:41 AM
Points: 10, Visits: 157

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

« Prev Topic | Next Topic »

13 posts, Page 2 of 2

««1 2

Permissions