Hi Rob John, I'm not sure if I'm getting the idea but, have you ever tried Linked Dimensions? On your main model you can have the calendar week number and you can link this dimension with another model that contains the calendar week and the comments...
Hi Tobias,I'm supposing that you are using import/acquire, in this case you have the option to model on SAC,have you tried to concatenate columns? please check this out https://blogs.sap.com/2020/06/19/new-string-functions-in-sac-bi-calculations/
Hi Andrea,I would suggest two things, without know the structure of your CSV file:1. change the CSV file for a XSLX extension, this could help to auto-detect the correct headers.2. You could verify that the delimiters headers on the csv and columns.P...
