I have the calculated measure half working. At the detail level the numbers are correct but the subtotal and grand totals are wrong. This is what I get:
Adding the clustered index helped, at least now I can see what is happening. The fact table is also joined to a DimProduct, DimClient and DimDate. When I filter to...
That sounds like it should work, but I am not sure how to set that up. I tried add New Measure Group, selected DimContract, it added the reserve plus a...
Currently I have 2 fact groups in my measures, Fact Production Claims which has things like claim date, claim amount, etc., Fact Production which has a count distinct ContractKey. Additionally...
I actually have the reserve field in 3 places right now as a result of trying to figure this out. It's in DimContract, FactProductionClaims, and FactContractReserve. I changed the calculated...
Version 2 worked! Thanks. Unfortunately I cannot use a delimited string to set the default of a multi-select parameter like I thought. I'm thinking I need to...
Thanks for the reply. I cannot hard code the last column because it is also variable. SSRS adds the last value that was not selected...kind of strange. ...