Solved

Different processing option in MS SQL Analysis Services

Posted on 2014-11-13
4
128 Views
Last Modified: 2014-11-16
What's the difference option for process ? When should I select among these 3 options ?

Tks
BI-cube.png
0
Comment
Question by:AXISHK
  • 2
  • 2
4 Comments
 
LVL 24

Expert Comment

by:Phillip Burton
Comment Utility
When you have changed the information in the dimension only, do the dimension level.
If you have changed your cube, do the cube level.
If you have made multiple changes, do the database level.
0
 

Author Comment

by:AXISHK
Comment Utility
And also, what the various option on Dimension table (attached file) ? TKs
Process-BI.png
0
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 500 total points
Comment Utility
This article will give you the answer to your question: http://msdn.microsoft.com/en-us/library/ms174774.aspx
0
 

Author Closing Comment

by:AXISHK
Comment Utility
Tks
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now