Mapping/ Join SQL and CSV Data

Ellina Mnikh

Hi all,

I'm quite new in Board and would be happy to get an advice to my topic. I use ASCII Data Reader to get the inventory data from a csv. To get some additional information like material description I add a database table Material via SQL protocol. Both of them have a common column calling Material code. 
I would like to show the inventory data and material description in one dataview. So I'm wondering, if here would be a way to join the data?

Some of my settings:
Data Reader:
ASCII: Inventory
Day   Owner   MaterialCode   Material  Quantity

SQL: Material Data
MaterialCode   MaterialGroup

Relationships: 
MaterialGroup - MaterialCode - Material

Cube:
Day   MaterialCode   Owner

Reportidea:

Thank you in advance,

Ellina

------------------------------
Ellina Mnikh
Controller
------------------------------

Sébastien Breyne

Hi Elina, 

I don't believe that the data source is a problem. 
I would try with a cube at the lowest level to show what you need:  Day, Material,Owner instead of Day, Material Code, Owner

You should then be able to insert the 3 dimensions in the rows of the dataview. 

Best,

------------------------------
Sébastien Breyne
Finance Manager
Cullen International
Belgium
------------------------------
-------------------------------------------