CSV Import - String values

Questions & Answers
1

Hi there,

I would like to import a similar table as the one below in csv :

Business Unit Team Date Number Issues Comment
BU1 Team 1 01.02.2021 10 bla bla bla
BU1 Team 2 01.02.2021 14 bla bla bla
BU2 Team 1 01.02.2021 18 bla bla bla
BU2 Team 2 01.02.2021 22 bla bla bla
BU3 Team 1 01.02.2021 26 bla bla bla
BU3 Team 2 01.02.2021 30 bla bla bla
BU1 Team 1 01.03.2021 34 bla bla bla
BU1 Team 2 01.03.2021 38 bla bla bla
BU2 Team 1 01.03.2021 42 bla bla bla
BU2 Team 2 01.03.2021 46 bla bla bla
BU3 Team 1 01.03.2021 50 bla bla bla
BU3 Team 2 01.03.2021 54 bla bla bla
![image 479x313](upload://17bmyaEoMCR4aj3vKS74IIk1Nw2.png)

My question is, how do I have to define the Comment columm? Since it´s a string (not an intenger) I can not define it as Measure, and therefore I can not display it as column in the report.

Thanks for your assistance.

2

Hi Anton,

Did you try to import “Comment” as a separate dimension?
The only downside is that it would group identical comments in the report and merge them in the report.
What is the purpose of having the comment in the cube?
Would you filter the report by a comment in some way?

Martins / eazyBI