Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Calculation shows for all members... why?

Status
Not open for further replies.

hwkranger

MIS
Nov 6, 2002
717
US
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.

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!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top