Solved

Different processing option in MS SQL Analysis Services

Posted on 2014-11-13
4
133 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
ID: 40439395
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
ID: 40439396
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
ID: 40439399
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
ID: 40446465
Tks
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…

910 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

22 Experts available now in Live!

Get 1:1 Help Now