What to do when a single attribute rolls up to multiple categories?...

Same attribute in multiple dimensions or Create new dimension?

Hi all - I'm struggling with this concept. I have 2 dimensions: Customer and Products. Both share a common single attribute that I'll just call "Owner" for now. If a customer purchased a product, the owner would be the same for both. I

multiple hierarchy : single dimension vs multiple

Hi Need to analysis sale revenue by store. We have two separate hierarchy for geographic location 1. Country / County / Council / Store name 2. Country / Region / Area / Store name Need valuable suggestion for how to design dimension for above to

Single TV shows accross multiple drives / locations

Hi This might have been covered before but I wasn't having much luck finding the answer. I have several large TV show collections with different seasons on different drives but in a folder with the same name, XBMC see these as one show and only list

v3.237 MC is creating multiple NFOs for single movie

I have a directory which contains 8 video files, named dirname_pt1.avi, dirname_pt2.avi, dirname_pt3.avi ... dirname_pt8.avi etc. Where dirname is the directory name. MC created an NFO file for parts 1, 6, 7 & 8, when I was expecting it only to

Multiple facts in a fact table

One proposed model for our business (wholesale/retail) sales fact is to have every register ring in one fact. This causes refunds, voids, coupons and other 'facts' to be stored in a single fact entity. There is a column type dimension that then tells us

Dimension Design with Multiple Data Sources (ORACLE and SQL Server)

Hi All. We have a client that is currently migrating from a legacy SQL Server (6.5) based ERP to Oracle e-Business Suite. The old legacy system was distributed in both application and database, however the application and database structure was (almost

Fact table with multiple date ?

Hi, I am modling a fact table for prisoners inscription in order to track historical changes. An admission is the hole stay comprise of one or many inscriptions usually separated by transferts between institutions. In the transactionnal system, it

Multi valued dimension attributes, weighting factor and cognos

Hi, we have several attributes in our product and customer dimension which might by multi valued. We modelled these as multi valued dimension attributes using bridge tables and weighting factors therein. Can anybody reference a best practice

How to manage multiple languages

Hi there! I have been using Media Companion quite successfully to manage my movie collection. However, I am having some problems managing non-english movies. I have several Italian language movies (in a separate directory from the English movies). In

Display your categories as tabs

Display your categories as tabs Many of you asked how to achieve this effect: Preview forum : http://youngstaruniversity.darkbb.com/forum.htm This tutorial will try to explain. Avoid changes of templates if you do not have the minimum knowledge

Suggestions for Categories and Forums

We have movies & TV, games, Anime and Maga but not a books area, or even an area for music (Put them together?) I don't know about you but I love to read and write, as well as listen to music. So it might be a nice area to have.

Single Release ? - Neat Little Rows

Just wondering what the first single off the Album will be Is Lippy kids just a taster for us, or is that intended to be a release ? If it's going to be another track, surely we'd have to get wind of that soon, assuming any release would probably be

Multiple clickable portions on a Image.

Multiple clickable portions on a Image. Using HTML make Mutliple portions on a image clickable Hello Everyone This is a very simple tutorial to make multiple clickable areas on your image. Enter this code into your HTML Page. Code:<img