That is correct, you can create a Data adapter to this view.
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.
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.
Got it - so I can query this table from inside OneStream using an SQL data adapter then?
That is correct, you can create a Data adapter to this view.
