Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
abeneventi
Starting Member
4 Posts |
 Posted - 2008-11-10 : 13:51:47
|
| Dear forum guys, I have a simple cube to analyze my customer's sales. I have a Time Dimension, a Product Dimension (with a few hierarchies) and a couple measures (sales and purchase amounts).I also have defined a few Calculated Members, in particular the average sales and purchase amount over the last 12 months from the selected month.I need to show the results in a SSRS Report: the user must select a month and the report needs to show the sales and purchase amount of the selected month and the average of the previous 12 months (both for sales and purchases).Everything works perfectly if I test the cube using the Cube Browser or Excel 2007 as a client.When I define the SSRS Report I cannot get to work with the calculated members (the average): I get strange numbers which are much higher than the real numbers.I've tried both Matrix and Table reports.Can anyone suggest me what I'm doing wrong: I think this should be a very common mistake.Best regardsAlessandro |
|
|
Ludwig
Starting Member
9 Posts |
Posted - 2008-11-17 : 15:47:49
|
| Hi Alessandro,I have the same issue and I don't have a solution for it. I think SSRS just sums up the values of an cal. member which does not make sense.I suppose we need to change the way ssrs aggregates the values...but where and how...Anybody else with that issue and a hint to fix it?Best RegardsLudwig |
 |
|
|
Ludwig
Starting Member
9 Posts |
Posted - 2008-11-21 : 10:07:25
|
| Hi GuysI looked into that...A way you could solve the issue is to add a calculated field to your dataset and calculate the value in SSRS again. Strange, yes but for me it works.It's not neccessary when you on the leaf level of your dimension but it is when you show aggregates in your reports. I think SSRS o5 is not a pure SSAS 05 client and does not provide this features as Excel 03 or 07 does. Agree? |
|
|
|
|
|
|
SSAS Calculated Member not working in SSRS