generate distinct clause for dimension objects

[naga5566]

Hi All,
I want to generate a distinct clause for any dimension object i select in the universe.
Instead of hardcoding distinct in the select box of each object,is there any parameter that can be set to generate distinct for all/any of the objects in the universe or universe class.

 

[skrandel]

Why do you want to do this?

If you are using measures correctly, then the combination of measures and dimensions will cause a GROUP BY, which does what you want.

If you have particular queries, then you can set the query option in the panel to "No Duplicate Rows".

Again, the real question: What are you trying to accomplish?

You can't set this attribute for individual objects or groups. It's a query level thing. If you did it for objects, then you'd cause other problems when you used other objects.

Steve Krandel
BASE Consulting Group

http://www.baseconsulting.com