I'm going to rebuild my table and go to float data type.

Love rebuilding my MODELS, all 6 of them. :/

Since it's being held in-memory I'm wondering if the server is dropping off line and the databases are dropping. interesting......

I've done some additional research, according to MS websites discrete data types work with all mining structures.

https://msdn.microsoft.com/en-us/library/cc645993%28v=SQL.110%29.aspx?f=255&MSPPError=-2147217396

This is simply not true for 2012 BI Edition.

Ended up...

Eric - To say I don't do those ever would be a lie, but it's not even 5% of my work effort day in and day out. I wouldn't...

Thanks Martin I appreciate the heads up.

Ended up using calculate filtering on the false value. Worked fine, just took a while to get the syntax down.

I'll just share what I ended up doing for my first model.

I wrote my SQL to pull in my Fact table and then joined my dimension table in the SSAS...

I ended up creating another calculated columns in SSAS Tab and then did a distinct count, the other problem now is when I do my breakout for one to one...

Sounds good I'll do that. Makes sense.

Here is what I did 😀

Not proud......

Added this to my fact table to create two concatenated columns to reference

,CASE WHEN LEN(CONVERT(VARCHAR, CONVERT(INT, CONVERT(CHAR(4),SUBMISSION_ID))) + CONVERT(VARCHAR, CONVERT(DATE,...

Martin thanks for following up. The order of operations make sense, almost like an aggregate on the outside of a case statement, however I was still unable to get...

The answer is BOTH!

Love tabular, easy to set up models and use DAX for calculations etc.

Need the multidimensional mode for mining etc. If the Excel mining plug...

I usually just go to the design mode and refresh the model.

Thanks for the heads up. I think what we going to end up doing is just moving our multidimensional box to the BI version and using that to perform...