Solved

MDX Script

Posted on 2014-12-16
1
89 Views
Last Modified: 2014-12-17
http://msdn.microsoft.com/en-us/library/ms145515.aspx

Refer to the article, can anyone explain more for the following points ? Tks

1. The MDX script take a layered approach to calculations within a cube through the use of calculation passes.

2. A SCOPE statement is dynamic, but not iterative in nature. The statements contained within a SCOPE statement run once, but the subcube itself can be dynamically determined.
0
Comment
Question by:AXISHK
1 Comment
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 500 total points
ID: 40505645
1. This means that, conspectually, not everything is evaluated at once. In other words, the cube data is calculated first, and then things such as SCOPE can alter previous calculations. You will see that one of the example increases [Amount] by 10% - but what does it increase it from? It has to calculate an [Amount] first in the cube, before then increasing it by 10%.

There's more information in the link beneath the first paragraph of the link you shared.

2. Exactly what it says. The SCOPE statement only runs once - that means that it can't be iterative (so it can't say that its value is based on its value in a previous calculation of itself). However, the part of the cube that it alters does not need to be fixed - you can have a subcube which is not fixed, but is (say) the 10% of the cube by value, as opposed to saying that it alters the value of [Amount] for the countries of the UK, France, and Germany (which is a fixed list).

Hope that helps.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
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 …
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
A short film showing how OnPage and Connectwise integration works.

919 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

16 Experts available now in Live!

Get 1:1 Help Now