Hallo everyone. I have two Excel table: Facttable and Dimensiontable. The facttable contains customernumber, productnumber and unit. The dimensiontable contains productnumber, productdescription and price. I would like to link the two tables with productnumber and generate the sum of each customer by multiplying the unit and price. I managed to model the tables using 'data-driven modelling' function in jedox excel add in BUT SEPARATELY. How can I link both tables/cubes? Thank you in advance.
newinjedox -
Hallo everyone. I have two Excel table: Facttable and Dimensiontable. The facttable contains customernumber, productnumber and unit. The dimensiontable contains productnumber, productdescription and price. I would like to link the two tables with productnumber and generate the sum of each customer by multiplying the unit and price. I managed to model the tables using 'data-driven modelling' function in jedox excel add in BUT SEPARATELY. How can I link both tables/cubes? Thank you in advance.