October 17, 2002 at 4:27 am
Suppose that i need to deliver an OLAP solution with all the relevant information in multi-language support, choosen by the user (not with the locale facility).
Which is the best approach for desing : implement some kind of dimension representing the languages available ? if so how do i represent the relation between the fact tables and these new dimension ? Also i wiil need to relate this dimension with all other dimensions in the system (e.g, products defined in multiple language, but i dont want to have several ID's for each product in each language). How do i solve these problem ?
Thank's in advance
October 24, 2002 at 12:00 pm
This was removed by the editor as SPAM
October 25, 2002 at 2:23 am
You would need to define a product / language relationship such as:
PRODUCT TABLE
---------------
Product ID
Product details
..etc
PRODUCT DESC TABLE
------------------
Product ID
Language ID
Product description (language specific)
LANGUAGE TABLE
------------------
Language ID
Language description
And set up the relationship as follows:
PRODUCT PROD DESC LANGUAGE
Product ID -> Product Id
Language ID -> Language
Join this in a star scheme by product id to your fact table. Create a dimension for language.
Kindof thinking out loud here, so might not be perfect!
HTH
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply