hey arsenal can u plzzzzzzzz help with a detail information about how u made the distinct count in transformer? where u write the manual sql? in database or in FM?
Wow, it's been awhile since I worked on that particular model, so my memory may not be exactly right
But yeah, did a data source query subject in FM
used Select and Group by. Also, set a query item to always be 1. When this query item was put into a new cube, along with some of the other items we needed from the new query subject, the cube aggregation gave a count that was equivalent to a discount count.