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

New Contributor III


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.


Basically, in Excel world am trying to put a pivot on raw data of 100 columns with output being only few of them.



Community Manager
Community Manager

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.