Thanks Jack.
When I try "NotUsed" or "TopNode;SSOnly" I get the following error:
I've also tried "TopMember;Member" which nearly worked... As it keeps the base records in sEntity column and then the top member in the Entity but the problem is that it negates my entity mapping.
Looks like I'm just going to have to filter out the parent records when retrieving data, but it is just frustrating cause it unnecessarily doubles the number of records in the table. Esp as the aggregated totals are absolutely useless because the aggregation ignores currency conversion etc.
I think I'll put it in the idea stream... Is it possible to move this to the idea stream or should create a new post?
I would create a new post, because you might want to articulate the use case a bit differently. BiBlend is fundamentally an aggregation engine, not just a data pipe; trying to not do any aggregation at all is kinda forcing it to go against its nature, so you might want to explain why you'd want it to behave like that.
Btw it's not correct that "the aggregated totals are absolutely useless because the aggregation ignores currency conversion etc". BIBlend does do currency conversion, although it's limited to basic conversion through a single currency. The results will be different from whatever you get through the Cube, for sure (because it doesn't do elimination etc), but again it's meant to be a somewhat simpler aggregation engine that can work on any dimension and on very large amounts of data, so there are some trade-offs involved.
