Object Properties

Not endorsed by or affiliated with SAP	Register \| Login
Not endorsed by or affiliated with SAP	Broadcast and burst BO reports dynamically (Opens a new window)
Index \| About	Sponsors \| Contact Us \| Calendar \| FAQ \| Rules and Guidelines \| Privacy Policy \| Search

General Notice: Upcoming Events: BI show Toulouse: Oct 18. There are 50 ASUG sponsored events in the next 45 days, see calendar for details.

Object Properties

Search this topic... | Search Semantic Layer / Universe Designer... | Search Box

Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer

Author Message

eye_candy
Principal Member

Joined: 18 Mar 2005

Posts: 307
Location: ~~

Posted: Mon Feb 08, 2010 4:40 pm
Post subject: Object Properties

Hi,

What is the difference when we create a measure. In the *Select part* we say count(ID's) and in the properties tab we select sum(default).

When we run a query. Does it do the count of sum of the ID's?

I am confused

Back to top

Andreas
Forum Aficionado

Joined: 20 Jun 2002

*2
Posts: 13527
Location: You're waiting for a train. A train that will take you far away..

Posted: Mon Feb 08, 2010 4:44 pm
Post subject: Re: Object Properties

Please, see post on Measures: SQL aggregation & projection.
_________________
A smile a day, click here
Follow me on Twitter
Who is your Friend? Search is Your Friend™
Focusing on Visualization Information, Looking at XI 4/Aurora, SAP BOE XI 3.1 SP3, SAP connectivity, Data Modelling, Project Management

Back to top

BOXIER
Forum Member

Joined: 07 Feb 2010

Posts: 5

Posted: Mon Feb 08, 2010 10:59 pm
Post subject: Re: Object Properties

When you look at the SQL generated it will be select count(id) from table.. so, it will count the ids.

Back to top

Display posts from previous:

Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer

Page 1 of 1 All times are GMT - 5 Hours

Jump to:

Index | About | FAQ | RAG | Privacy | Search | Register | Login

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.1509 seconds using 16 queries. (SQL 0.0072 Parse 0.1323 Other 0.0114)

Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com