Forum Discussion

SKVK's avatar
SKVK
New Contributor III
2 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.

 

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

Thanks

Data Integration
Data Sources
Import
  • JackLacava's avatar
    JackLacava
    Honored Contributor
    2 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.