Using Kimball Excel Dimensional Model template

View previous topic View next topic Go down

Using Kimball Excel Dimensional Model template

Post  hortoristic on Fri Aug 08, 2014 4:33 pm

Whenever I use the Kimball Excel Dimensional Model template, and use the "Create / Update Diagram" button, it seems to skip the first fact row in creating my bubble chart. Seems like I always hit this snag and forget how to quickly fix it?

Example on FACT worksheet:

Column Name:
AddressDimKey ...
InsertAuditKey ...
UpdateAuditKey ...

It creates a bubble graph with my fact in middle, but only draws an Insert and Update bubble - it skips the AddressDimKey.

hortoristic

Posts : 7
Join date : 2012-05-29
Location : Seattle, WA

View user profile

Back to top Go down

Re: Using Kimball Excel Dimensional Model template

Post  nick_white on Wed Aug 13, 2014 9:28 am

Is this template available to download from somewhere? If it is then let me know and I'll have a look at it

Regards,

nick_white

Posts : 366
Join date : 2014-01-06
Location : London

View user profile

Back to top Go down

Re: Using Kimball Excel Dimensional Model template

Post  hortoristic on Wed Aug 13, 2014 9:36 am

http://www.kimballgroup.com/wp-content/uploads/2014/03/DW-Toolkit-Excel-Data-Model-3.4.zip

hortoristic

Posts : 7
Join date : 2012-05-29
Location : Seattle, WA

View user profile

Back to top Go down

Re: Using Kimball Excel Dimensional Model template

Post  nick_white on Wed Aug 13, 2014 10:04 am

Seems to work fine for me. I took the "MDWToolkit Datamodel 3.4 MDWDAdventureWorks 2005 version.xlsm" workbook, updated the blank fact sheet so that the first 2 rows referenced product and promotion and when I generated the diagrams it created the blank fact with 4 links (product, promotion and the 2 audit dims

nick_white

Posts : 366
Join date : 2014-01-06
Location : London

View user profile

Back to top Go down

Re: Using Kimball Excel Dimensional Model template

Post  hortoristic on Wed Aug 13, 2014 10:05 am

Using Office 2013?

hortoristic

Posts : 7
Join date : 2012-05-29
Location : Seattle, WA

View user profile

Back to top Go down

Re: Using Kimball Excel Dimensional Model template

Post  nick_white on Wed Aug 13, 2014 10:15 am

No - 2010. Sorry, I don't have 2013.

However it should be reasonably straightforward for you to debug the macro code - presumably it is one of the calls to DrawDims near the end of Sub WTDraw that is causing your problem. Just put a breakpoint near the top of the DrawDims code and then step through it

nick_white

Posts : 366
Join date : 2014-01-06
Location : London

View user profile

Back to top Go down

Re: Using Kimball Excel Dimensional Model template

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum