On 64-bit Operating System, you can find the file Microsoft.SQLServer.ManagedDTS.dll in the following path:

C:\Program Files (x86)\Microsoft SQL Server\110\SDK\Assemblies

On 32-bit Operating System, you can find the file Microsoft.SQLServer.ManagedDTS.dll in the following...

Happy to help. Although if you are hitting these problems now (with the increase in data) perhaps it's time you considered whether SSAS Tabular is appropriate? Or can you reduce...

OomBoom (3/23/2016)

---

Thanks again. If I understand it correctly the guru is saying that Measures will not consume any memory at process time. This brings me back to my original question....

In SSAS Tabular calculated columns are persisted (unlike in SSAS Multidimensional which runs calculations on the fly at query time) and if they are complex can hit processing resources highly....

As ever with this sort of thing the answer is very much "it depends"

You could look at the advanced memory properties of the AS instance. More information on them here:...

polkadot (3/22/2016)

---

switchTest:=SWITCH('POEC Delivery Types', "MCS T&M", SUM([one thing]),'POEC Delivery Types', "Subcon T&M", SUM([another thing]),0)

I'm trying to say that if the Fact column called POECDeliveryType has value "MCS T&M" then SUM([one...

Jeff Moden (3/17/2016)

---

PB_BI (3/9/2016)

---

tonzonline (3/5/2016)

---

Hi,

Is the problem because I create this dimension by Wizard and choose "Create Time table from server" ?

I also notice, NameColumn property is "New binding(WChar)

If I...

tonzonline (3/5/2016)

---

Hi,

Is the problem because I create this dimension by Wizard and choose "Create Time table from server" ?

I also notice, NameColumn property is "New binding(WChar)

If I click the ellipsis,...

Have you read the following (the ROLAP section)?

https://msdn.microsoft.com/en-us/library/ms174915%28v=sql.110%29.aspx

There are a number of rules that you need to adhere to for ROLAP to work correctly. My guess is it's something to...

Okay. What does it say in event viewer when you start the server (in regards to SSAS)? Is the SSAS service set to automatic in services.msc?

Did you read the white...

Clustering and SSAS can be a minefield.

That said, you have not told us any really relevant information; SQL Server version/edition, Operating system, type of clustering, which node this is happening...

Remove the SubSelect then as it serves no purpose if you're not wanting to filter on a particular model:

WITH

MEMBER [Measures].[QtyTotal] AS

[Measures].[QtyInWarranty] +...

Whenever I have *had* to do this (emphasis on had because if you're having to do this then you have an underlying design issue in my opinion) I have used...

From BOL:

Syntax

ParallelPeriod( [ Level_Expression [ ,Index [ , Member_Expression ] ] ] )

So for the first argument you need a Level Expression and you are using a Hierarchy Expression.

So...

You can use the ORDER clause directly in MDX:

https://www.mssqltips.com/sqlservertip/3129/order-and-sort-with-mdx-in-sql-server-analysis-services/

Or, since you're using SSRS, if you're not comfortable with writing it in the query you can just sort the Tablix that...