Mapping/ Join SQL and CSV Data

Ellina Mnikh
Ellina Mnikh Customer
10 Comments Second Anniversary
edited July 2020 in Platform
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:


image



Thank you in advance,

Ellina

------------------------------
Ellina Mnikh
Controller
------------------------------
Tagged:

Answers

  • Sébastien Breyne
    Sébastien Breyne Customer
    Fourth Anniversary Advocate First Comment
    edited July 2020
    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
    ------------------------------
    -------------------------------------------

Categories