Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
ratio calculated member is always 100%

問題 ratio calculated member is always 100%

  • Sunday, March 17, 2013 4:43 AM
     
     
    Sign In to Vote
    0

    hello

    i have defined a ratio calculated member and when I test it in VS.NET (on the browse tab) everything seems ok. When i built a report , the value is always 100%; i captured the query via SQL Profiler and i executed in ssms, the ratio returns only 100%.

    In browsing the cube i have used the same user defined hierarchy and i filtered the query.... why this behavior? I use sql 2008 R2.

    regards,

     

All Replies