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.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.