IN the most recent case I encountered, it was a case of the source database having a reduced number of rows in the table I was using in my model,...

Additionally, the measures on Fact_transaction work correctly with DimCOA When I use the explore with Excel option from the designer.

Further digging has shown this to only occur with measures on the Fact_transaction table.  
This table has a relationship to dimCOA, but when I attempt to use these dimension and fact...

And I figured it out.  I had screwed up on the COAKEY field so that there were no matches when attempting to use RELATED.  However, I am not 100% sure...

I am attempting to create a measure using the related to determine if GLL_Amount is categorized as REVENUE or COGS. In the case of revenue the formula I am trying...

Appears that the last issue was fixed by removing the dimension and re adding it after reversing the DSV relationship.

now I am getting a similar error on another table- dimcustomer - also related to FactProductSales
Errors in the OLAP storage engine: A duplicate attribute key has been found when...

Figured it out.  I had to reverse the direction of the relationship between the tables.

One of the ways that I think this can be achieved most easily is through the use of VMs & keeping not just snapshots, but full images of VMs, as...

When it comes to dealing with politics in IT, there are two general types I break things down into- Internal IT politics, and external polititcs.  The external politics are often...