arsenal plz help

[biswasarijit84]

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?

[Arsenal]

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.