Calculated Member Problem in RS

Hi,
There are two problems during I tested the Cube in RS:
1. If I choice a Member is the Top Level of the Dimension, as following, the
"All" this Member.
The All Member is the name of "All Caption" of the AS Advanced Property
and it's the sum of the Department Dimension.
When I use this All Member in RS, I can't see the Member name in Dataset
Fields, Why?
Sales Department Dimension
|--All
|--dept A
|--dept B
|--dept C
2. When the source data is Cube and use Matrix to present, is any way to
calculate dimension member on Column and Row?
It's mean that I want to use the member in Column and Row to calculate a
Calculated Member and show its value on "data" cell.
Or we should make the Calculated Member in AS first and select it on RS?
Have any idea about this and how to do?
Thanks for your time!
AngiLook for a whitepaper on Analysis Services and Reporting Services on the
Microsoft website. I know it is there. I read it and concluded that RS is
absolutely not ready for AS.
The disappearing "All" member is a known issue. The whitepaper shows ways
around the most common problems you'll encounter.
Hth,
Tom
"angi" wrote:
> Hi,
> There are two problems during I tested the Cube in RS:
> 1. If I choice a Member is the Top Level of the Dimension, as following, the
> "All" this Member.
> The All Member is the name of "All Caption" of the AS Advanced Property
> and it's the sum of the Department Dimension.
> When I use this All Member in RS, I can't see the Member name in Dataset
> Fields, Why?
> Sales Department Dimension
> |--All
> |--dept A
> |--dept B
> |--dept C
> 2. When the source data is Cube and use Matrix to present, is any way to
> calculate dimension member on Column and Row?
> It's mean that I want to use the member in Column and Row to calculate a
> Calculated Member and show its value on "data" cell.
> Or we should make the Calculated Member in AS first and select it on RS?
> Have any idea about this and how to do?
> Thanks for your time!
> Angi
>
>