Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

generate distinct clause for dimension objects

Status
Not open for further replies.

naga5566

Technical User
Joined
Mar 14, 2003
Messages
90
Location
US
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.
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top