Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Cube Processing Expand / Collapse
Author
Message
Posted Monday, August 20, 2012 6:03 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, February 13, 2014 6:01 AM
Points: 17, Visits: 148
Hi,
I am new to SSAS.i have 1 lakhs record in cube but next day i am getting another 10k records.So i want to process only new records.For this what i need to do?

Please reply me.Thanks in advance


Cheer's
Rajesh
Post #1347112
Posted Monday, August 20, 2012 6:18 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Friday, June 27, 2014 7:41 AM
Points: 739, Visits: 518
rajeshpalo2003 78748 (8/20/2012)
Hi,
I am new to SSAS.i have 1 lakhs record in cube but next day i am getting another 10k records.So i want to process only new records.For this what i need to do?

Please reply me.Thanks in advance


Hi Rajesh,

Thanks for the question. Please be aware that this is an international forum and not all readers will understand the phrase "lakhs". Its best to write the actual figure so that we're all involved. I believe that 1 lakhs is 100,000 but please correct if I am wrong!




"Be brave. Take risks. Nothing can substitute experience."
Post #1347121
Posted Monday, August 20, 2012 6:23 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Friday, June 27, 2014 7:41 AM
Points: 739, Visits: 518
Found this in SSC which discusses cube updates.

http://www.sqlservercentral.com/blogs/jamesserra/2012/01/25/improving-cube-processing-time/


"Be brave. Take risks. Nothing can substitute experience."
Post #1347124
Posted Monday, August 20, 2012 6:27 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, February 13, 2014 6:01 AM
Points: 17, Visits: 148
Thanks Robin.Again i am repeating that question with proper phrase

i have 100,000 records in cube but next day i am getting another 10,000 records.So i want to process only new records.For this what i need to do?
Which is the best way for cube processing?

Cheer's
Rajesh


Cheer's
Rajesh
Post #1347127
Posted Monday, August 20, 2012 6:31 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Friday, June 27, 2014 7:41 AM
Points: 739, Visits: 518
Hi Rajesh,

Open the link and read the article - it should point you in the right direction.


"Be brave. Take risks. Nothing can substitute experience."
Post #1347132
Posted Tuesday, August 21, 2012 8:11 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Yesterday @ 1:39 PM
Points: 22, Visits: 730
The link seems to be busted today.
Post #1347812
Posted Tuesday, August 21, 2012 9:05 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Friday, June 27, 2014 7:41 AM
Points: 739, Visits: 518
Just checked.... the link is fine

http://www.sqlservercentral.com/blogs/jamesserra/2012/01/25/improving-cube-processing-time/


"Be brave. Take risks. Nothing can substitute experience."
Post #1347853
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse