First time aggregation

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Analysis Services » First time aggregation

First time aggregation

Rate Topic

Display Mode

Topic Options

Author

Message

mauryakamal

Posted Wednesday, April 29, 2009 4:33 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, January 03, 2013 7:18 PM
Points: 16, Visits: 190

How to decide first time aggregation percentage i.e 1%,10% or 90%. What is the criteria to decide the percentage.

Use 1% on this criteria or Use 40% on this criteria etc.

Thanx in advance.

kamal maurya

Post #706622

Brandie Tarvin

Posted Wednesday, April 29, 2009 11:20 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 9:57 AM
Points: 6,724, Visits: 5,796

I'm new to this myself, but I'll take a stab at the answer.

I don't think there is a real criteria. I think it depends on how you want your numbers to turn out. No more, no less.

I can't find this percentage thing in BOL, though, to be certain.

Brandie Tarvin, MCITP Database Administrator, MCDBA, MCSA

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Post #707077

« Prev Topic | Next Topic »

Permissions