Skip to main content
S
SKVK
Newcomer
April 14, 2023

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

  • April 14, 2023
  • 1 reply
  • 0 views

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

1 reply

J
OneStream Employee
JackLacavaOneStream Employee
OneStream Employee
April 16, 2023

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.

    Terms & ConditionsAccessibility statement