Think I've got the iif statement the wrong way around

IIF(ISEMPTY([Measures].[Sales Amount] )

,NULL

,SUM ({ [Company].[All Company].[COMET]},[Measures].[Sales Amount]) )

,NON_EMPTY_BEHAVIOR = {[Measures].[Sales Amount]}

Apologies

Mack

Is this a duplicate post of this? http://www.sqlservercentral.com/Forums/Topic1409208-17-1.aspx

Mack

You could use a case statement or iif statement. I'd also use the non_empty_behavior clause as well

IIF(ISEMPTY([Measures].[Sales Amount] )

,SUM ({ [Company].[All Company].[COMET]},[Measures].[Sales Amount])

,NULL)

,NON_EMPTY_BEHAVIOR = {[Measures].[Sales Amount]}

Mack

There is a very recent thread on this already

http://www.sqlservercentral.com/Forums/Topic1407198-17-1.aspx

Mack

Does it all look fine in the solution? Maybe redeploy it

I had a similar issue once when using ClearCase as our source control (it didn't always check in all...

Sounds like you're not having the best day....

Sorry for being unclear..... Edit the dimension of the cube and go to properties of the offending attribute. KeyColumns --> DataType needs to be changed from WChar to Integer

The cube...

You'll need to alter the datatype of the attribute

Edit the dimension and go to properties of the offending attribute. KeyColumns --> DataType needs to be changed from WChar to...

Depending on how big you dimension is then recreating it is an option

However you can change the table ID tho...

Edit the dimension - click on each attribute and go to...

You need to add this to the calculation script of your cube

CALCULATE;

CREATE SET CURRENTCUBE.[ThreeMonths]

AS

LastPeriods(3,StrToMember("[Take Date].[Month].&["+CStr(Year(Now()))+"-"+Right("00"+CStr(Month(Now())) ,2)+"-01T00:00:00]").lag(1));

Mack

Try

SELECT

NON EMPTY{

{[Measures].MEMBERS} *

{[DIMLINEOFBUS].[LINEOFBUSTYPE].&[Commercial],

[DIMLINEOFBUS].[LINEOFBUSTYPE].&[Auto],

[DIMLINEOFBUS].[LINEOFBUSTYPE].&[Residential]}

ON COLUMNS,

NON EMPTY {

{[Dim Geographic].[COUNTYNAME].[All].children} *

{[Dim Geographic].[CITY].[All].children} *

{[Dim Geographic].[POSTALCODE].[All].children} *

{[Dim Geographic].[LOCATIONID][All].children}

} ON ROWS

FROM (select [Dim Geographic].[Policy].[STATECODE].&[27] on columns from...

Couple of questions, how are you processing it? What service is being killed - can you connect to SSAS or SQL Server after the cube has failed?

The error looks...

You can do it in two ways

{[Set of Locations]} - {[Set of exclusion locations}

For example

SELECT NON EMPTY { [Measures].[Revenue] } ON COLUMNS ,

NON EMPTY { [Client].[Region].[All].CHILDREN } - {[Client].[Region].[AEJ]}...

hmmmmmmmm

Looks like you make have to add a Month Name attribute to you time dimension so it will group the months of the year

MonthMonth Name

Jan-10Jan

Jan-11Jan

Jan-12Jan

Jan-13Jan

Feb-10Feb

Feb-11Feb

Feb-12Feb

Feb-13Feb

Another alternative is to set up...

Are you trying to sum months - so January is Jan 10 + Jan 11 + Jan 12 + Jan 13

Or do you want to sum across products like so:

Select...