February 17, 2004 at 12:47 pm
Greetings,
Does anyone know of any good naming conventions for BI objects (cubes, dimensions, etc)? I've been looking on the web and have found it difficult to find anything on this topic.
Thanks,
SB
February 17, 2004 at 8:20 pm
These touch on the subject, Kimball's data warehouse toolkit goes into much greater detail on this subject.
http://www.rkimball.com/html/designtips/2002/designtip36.html
http://www.intelligententerprise.com/030201/603warehouse1_2.jhtml
HTH
------------
Ray Higdon MCSE, MCDBA, CCNA
February 18, 2004 at 8:15 am
I always run into issues as I have to name objects with the absolute in non-techie user in mind. Most database naming schemas won't work for BI end users. When I am asked to build a cube I work with a few of the users and build a template that includes all naming conventions for all dimensions and all measures. Since the end users are the one's who will be seeing the names and attempting to figure out what they mean, you should involve them.
February 18, 2004 at 12:58 pm
I do BI for a living and I agree with bnordber. The users are the best source of naming conventions for BI deliverables. I've also found that different user groups use different names for the same things and it's not always possible to get them to agree on a single name (although that's always the best solution). In this situation, users rule.
Donhttp://www.biadvantage.com
February 18, 2004 at 6:08 pm
I agree, the logical design you present to the user should be friendly, up to you how you do the physical design, sometimes it is beneficial to keep them the same, depends on your needs. A big mistake I see people make in cube design is to not name the measures appropriately, the user should not be able to confuse a measure with a dimension.
HTH
------------
Ray Higdon MCSE, MCDBA, CCNA
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply