So....
I have a problem -- it's the same problem I have with KPI's. I created KPI's, but when I put them in SSRS to report them ALL members are associated with the KPI and it seems impossible to filter which members I want from a consumed parameter.
So I changed it to a calculation -- this is one of my trends.
When i do this, it flushese out all the members of a measure to all dimensions.. I'm perplexed...
thanks!
I have a problem -- it's the same problem I have with KPI's. I created KPI's, but when I put them in SSRS to report them ALL members are associated with the KPI and it seems impossible to filter which members I want from a consumed parameter.
So I changed it to a calculation -- this is one of my trends.
Code:
Case
When IsEmpty
(ParallelPeriod
([Dim Time].[Hours After Midnight].[Hours After Midnight],1,
[Dim Time].[Hours After Midnight].CurrentMember))
Then 0
When (
[Measures].[Average Service Window Time] -
([Measures].[Average Service Window Time],
ParallelPeriod
([Dim Time].[Hours After Midnight].[Hours After Midnight],1,
[Dim Time].[Hours After Midnight].CurrentMember))
/
([Measures].[Average Service Window Time],
ParallelPeriod
([Dim Time].[Hours After Midnight].[Hours After Midnight],1,
[Dim Time].[Hours After Midnight].CurrentMember)))
>=.01
Then 1
When(
[Measures].[Average Service Window Time] -
([Measures].[Average Service Window Time],
ParallelPeriod
([Dim Time].[Hours After Midnight].[Hours After Midnight],1,
[Dim Time].[Hours After Midnight].CurrentMember))
/
([Measures].[Average Service Window Time],
ParallelPeriod
([Dim Time].[Hours After Midnight].[Hours After Midnight],1,
[Dim Time].[Hours After Midnight].CurrentMember)))
<=.01
Then -1
Else 0
End
When i do this, it flushese out all the members of a measure to all dimensions.. I'm perplexed...
thanks!