Forum Discussion

SKVK's avatar
SKVK
New Contributor III
3 years ago

How to import data with more than 100 columns where not all needs to be part of dimensions

Team I have a raw dataset with more than 100 Columns. I would like to connect the data and import 30 columns and have the data imported to cubeview as is. And then will manage the view in Dashboard...
Data Integration
Data Sources
Import
JackLacava's avatar
JackLacava
Community Manager
3 years ago

In addition to the usual 16 dimensions, you have 20 Attribute dimensions and 12 Attribute Value dimensions that you can optionally enable (from Cubes -> select Cube -> Integration). That should allow you to capture up to 48 elements. Just make sure you create the datasource configuration after you've modified Integration settings, so that all those extra dimensions will be automatically added - otherwise you have to create them one by one.