Aggregation BI-Blend non-attribute dimensions without base members
Hello:
I've integrated a set of transaction details from a GL into a bi-blend cube within OneStream. I'd like to aggregate along the UD1 dimension so we can see the data at the parent level for each transaction. The dimension consists of a set of parents with a few base members rolling up to each one, it's a pretty simple dimension. I'd like to be able to see the parents in a column with the base members in the other column. Note: that the base member is being passed directly form the data source, i.e. It's a pass thru mapping. An example of a parent child relationship is below:
Parent: Clubs
Base:1000
Base:2000
In the ud1 value column, I'd like to only see "clubs" while in another column I would like to see "1000" and "2000" values in another. I know that in the ud1 when I aggregate this dimension, I'll see the base member and the parent members in the same column for UD1 even if it's the blend unit dim. I'm passing the base values into an attribute. Is the only way to exclude non-base members is filtering the data set on the data adapter that feeds the BI-BLEND dashboards? I know it will work, but just curious if anyone else has run into this.
Thank - James
That is correct, you can create a Data adapter to this view.