Thanks, this seems to work for me.  I will see if DBA can create function on the database.

Scott

Hi All,

so i met with business users and it seems i had the requirements a bit mixed up.  I think it might even be a bit simpler now.  So i...

Hi,

sorry, it's hard to put in words.  So if the claim id, damage id and location id are the same, then I need to sum the reserve amt  only for...

i get this:

Use of DISTINCT is not allowed with the OVER clause

Execution Plan attached.

wow, i way overlooked this one. thanks

I think the Dense_Rank will work.

we should never have a scenerio where we have 2 renewals and have to remove just one.

works, thanks!

thanks! that worked.

here are the drivers in case anyone runs into same issue:

http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html

so how do i fix it?

Hi,

yes that was a typo on my part. The policy should be 1000124.

I'm trying to join the tables together and at the same time capture that there is a...

Yes, finally!!!

thanks so much for your help. You were a great source for information.

Scott

Martin,

Basically, this is an SSRS report that sits over an SSAS cube. What the report is supposed to do is show which accounts for a given Quarter, Operations, Division,...

Martin,

thanks for your help on this.

i changed the query to include the filtered set using the "OR" logic:

WITH MEMBER PREM AS

StrToMember("[Measures].[" + @PremiumType+ " Premium]")

SET FilteredBrokers AS

{STRTOSET('{[Broker].[Account Broker Name...

Thanks Martin,

Being new to MDX, i usually start off with the Designer then modify the query as needed. Probably not best practice...

In regards to creating the named set, i...