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 |
|
m_papag
Starting Member
2 Posts |
 Posted - 2009-05-24 : 04:27:53
|
| My migration of RS 2005->2008 has not ben so hassle free..I have a report that queries an AS2008 cube.The query has sales per product/geography/time.PPG% (Previous period growth) is not aggregatable neither by geography nor by product hierrarchy. Therefore I have created custom aggregations in AS2k8, as well as custom formating coloring the PPG red / green depending its value.All works ok in AS2008 and the report in RS2005.Initally, I couldn't get the aggregates correct at group level(Product->Brand, Zip Code->City), since it returned either blanks or the first value, and when using the aggregate function, the details where blank.Now by re-writing the report, it seems to be ok, but the Color property for the group totals.Therefore, the color property retrieved either for a Brand or a City is the same as for the first product/zip code that belongs to the respective group. And in Color property, the Aggregate is of no use.The "Interpret subtotals as detail rows" at the Dataset properties is at auto.Any ideas?Thanx |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-05-24 : 05:01:51
|
| have you tried using Inscope() function?you may use something like=IIF(Inscope("YourGroupName"), "Red","Blue)... |
 |
|
|
m_papag
Starting Member
2 Posts |
Posted - 2009-05-25 : 15:45:03
|
| The Color is an mdx expression in the formating properties of the Calculated Member.Therefore, I do not want to re-write the logic on the report itself.The report in RS2005 was able to get the Color property from the respective calculated measure for the aggregated level (i.e. Brand level is one level above Package level). It gets the color from the package level, but in the same report, when showing the total, the color it return is that of the first child of the respective brand.Something seems to have changed with the new Tablix control with respect to how it treats AS 2008 server aggregates..any tips? |
|
|
|
|
|
|
|
|
Server Aggregates