12-10-2021 02:37 PM - last edited on 05-24-2023 08:39 AM by JackLacava
Hello,
We have data loaded to stage, voucher row text field, that we do not want loaded to the cube. Is there a video or how to doc that walks you through how to setup Attribute Value Dimensions for this column? I know from some of the OneStream training that I have attended it is possible but just having trouble getting started.
Cube Design Attribute Value.docx (385.9 KB)
12-10-2021 02:38 PM
Haaris:
Design and Reference within Platform Documentation is a great resource (Help at the top right of the application). I think reviewing Cube Integration and Data Sources will help you get to where you want to go with this.
Design and Reference > Cube > Cubes > Integration
For the Cube where you are importing this data, you would need to enable one of the Attribute dimensions. When a Dimension is Enabled, it will appear in the Stage area and data can be imported into it for a particular Scenario Type.
Design and Reference > Data Collection > Data Sources
For the data source assigned to the import, create Source Dimension for the enabled Attribute dimension then set the position where the dimension data will exist in source data.
Next time you import the data to stage, based on your data source configuration, data should map to newly enabled dimension.
12-10-2021 02:39 PM
Thanks @michael.brokaw this was helpful.
12-10-2021 02:39 PM
Pardon the plug; however, I wrote a brief blog for this post, Post | Feed | LinkedIn
12-10-2021 02:40 PM
@terry.ledet Thanks, this is exactly what we needed!