dbTalk Databases Forums  

Browse data during processing?

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Browse data during processing? in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
JP
 
Posts: n/a

Default Browse data during processing? - 09-02-2003 , 10:43 AM






We have users connecting to Analysis Services via a web
app to browse cube data and run an incremental process
every week to update this data. We also run a full process
every now then as well.

Does anyone know if it is OK to allow them to browse cube
data while the Analysis Services database is being
processed(by both a full and an incremental)?

Any suggestions would be appreciated.

Thanks!








Reply With Quote
  #2  
Old   
Yashwant
 
Posts: n/a

Default Browse data during processing? - 09-02-2003 , 02:23 PM






Yes,
You can allow users to browse data while cubes are being
processed. They need refresh the web page i.e they need
to reconnect to the cube to view new data.
Regards



Quote:
-----Original Message-----
We have users connecting to Analysis Services via a web
app to browse cube data and run an incremental process
every week to update this data. We also run a full
process
every now then as well.

Does anyone know if it is OK to allow them to browse cube
data while the Analysis Services database is being
processed(by both a full and an incremental)?

Any suggestions would be appreciated.

Thanks!







.


Reply With Quote
  #3  
Old   
Yashwant
 
Posts: n/a

Default Browse data during processing? - 09-03-2003 , 05:13 PM



When you process a cube, it will ask for full process ,
refresh and incremental update. Incremental update is a
better solution to process cubes just to save time.

while going for incremental update, u need to specify
filter like "year=1998" , AM will process the new data and
will merge it to the existing partitions.

you need to go for full process when any structural
changes has taken place for the cube. then user must
reconnect to cube.

Cheers
Yashwant








Quote:
-----Original Message-----
Thanks Yashwant,

Does that mean that everytime a user refreshes their
browser they will be seeing incomplete data?

How exactly does Analysis Services handle data
consistency?

-----Original Message-----
Yes,
You can allow users to browse data while cubes are being
processed. They need refresh the web page i.e they need
to reconnect to the cube to view new data.
Regards



-----Original Message-----
We have users connecting to Analysis Services via a web
app to browse cube data and run an incremental process
every week to update this data. We also run a full
process
every now then as well.

Does anyone know if it is OK to allow them to browse
cube
data while the Analysis Services database is being
processed(by both a full and an incremental)?

Any suggestions would be appreciated.

Thanks!







.

.

.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.