rebuilt model and not having this error anymore.

Hi Brian,

Questions about your formula.

First section:

Are you getting sum of [POS Units] for each level of the Calendar hierarchy? Is [POS Units] a measure or the name...

Hi Brian,

Thanks for reply.

The pseudocode for what I need reads requires I used Lowest Logic instead of Measure:

IF(ISFILTERED ([Lowest Dimension Attr]), [Lowest Logic],

IF(ISFILTERED([Next Dimension Attr]), [Next Logic], etc.

))

EG.

=if(ISFILTERED(Resources[ResourceName]),...

solved. I double clicked on the error for 2 and it returned a window in which I defined granularity. Nice feature in SSAS to direct you to the item that...

Thanks Koen.

one last question:

So how to I process the 2014 cube so it can be edited? Is there an .sln version of it somewhere?

Hey thanks a lot. Now I have AdventureWorks DW 2014 on the Database engine and Multidimensionalmodel backup restored to Analysis Services engine.

OK. Then, since I'm using SQL Server 2014 and already have AdventureWorks2014 DW installed on the Database Engine, I've decided to download AdventureWorks 2014 Multidimensional Models from codeplex.

Surprise though.....When...

one of 50 error messages I am getting is Cannot open database "AdventureWorksDW2012" requested by the login. The login failed.

I don't have AdventureWorksDW2012 installed on the Database Engine...

I wonder what Alice B Toklas <edit> and Gertrude Stein would have to say about the semicolon?

I'm to the formatting part of the Redgate Manual.

EG. 'we need to decide what comprises a change in the nesting level that things get difficult'

So, thanks Luis and...

Hi Grant, the red-gate SQL Server Team Based Development book I downloaded for free, Chapter 1, is very relevant to this topic....and very funny.

'Vowel Movement' referring to the practice of...

Honestly, many more pressing issues and teams are not bothered to spend time on this topic, yet it is expected that queries are readable. Seriously, does any team really...

The links are very appreciated. I'll take a look

In my case the complaints have been about indentation and spacing akin to what one might expect from an outline for an...

Does that mean that #temp tables are constantly updated as other are updating the tables that it is referencing?