Forum Discussion
Are you using Star Schema creation? If you did that, then you'll get a Parent Column in the view, and you can use the view to pull it. If you use Member filters, then if this is a blend unit dimension, that will change how the members are stored in blend tables.
Interesting. When I update my bi-blend settings between star schema and non-star schema I don't get any additional columns. I was however able to get the data in need into the table. I was lucky in the respect that my base level data for UD1 matches what's in the ERP, so I just did column comparison against and attribute and it's working and performing well.
- ckattookaran3 years agoVIP
Pay attention to the word view, it is not a table. You need to create a connection to the view OS creates using the dimension tables.
The P columns are parents.
- JamesKirkby3 years agoNew Contributor III
Got it - so I can query this table from inside OneStream using an SQL data adapter then?
- ckattookaran3 years agoVIP
That is correct, you can create a Data adapter to this view.
Related Content
- 8 months ago
- 12 months ago
- 6 months ago
- 11 months ago