Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi;
i have 3 dimensions as below and i want to create a fact table to join them. this fact table must contain: Numero_Serie_Ordinateur, Numero_Serie_Ecran and Numero_Serie_Imprimante. Please help
Hi,
I would read the document supplied above.
It would be hard to suggest the best approach to making the link as we do not know the data your working with.
If you could give some more information, like what is the data tables what are the key fields and any links between the table.
Mark
which are the common keys between this tables ?? if you have only one key in common you can directly rename those fields with common name
Hi Cool,
The data structure looks identical in the shared screen shot, but we are unable to understand what data it is, if they are same set of data for different categories then may be we can concatenate all with a flag coloumn. Can you pls share some sample data set with dimension details so that we can have a better understanding on how this can be modeled?
-Sundar
Data are from GLPI, and i need to do inventory of computer, monitor and printer and would need to join table throught serial number of each equipement
I don't think your tables have a common serial number as s/n of the ordinateur is different from s/n of the printer, etc..... so you can't join the tables IMHO.
You can load the tables in the same table using concatenate and adding a type field to identify the device (ordinateur, printer, ...); you should also rename the fields ( .... as .....)
// ordinateur
Devices:
load
Numero_Serie_Ordinateur as Numero_Serie,
Nom_Ordinateur as Nom,
......
'Ordinateur' as DeviceType
from
....;
// printer
concatenate (Devices)
load
Numero_Serie_Imprimante as Numero_Serie,
Nom_Imprimante as Nom,
......
'Imprimante' as DeviceType
from
....;
// screen
concatenate (Devices)
load
Numero_Serie_Ecran as Numero_Serie,
Nom_Ecran as Nom,
......
'Ecran' as DeviceType
from
....;
Thank you everybody, I found a solution and i need suggestion:
I just link differents table by Pseudo_Utlisateur so i know which user have which equipement.
Hi Cool,
If Pseudo_Utlisateur is the user name and it is common in all the table , then this should work. Try hovering on Pseudo_Utlisateur in all the tables in the preview and look for Subset Ratio. There is no link between the tables if sum of all the subset ratio of the tables equals 100. else if it is something like 80,70,50, then we are good. If it is 100 in all the tables then you have the prefect data there.
If you stilll have some issue pls post sample data.
Hope this helps.
-Sundar