D
Denis in Brisbane
I'm trying to generate a report using RBS and resources and showing work,
availability and some calculated fields. Works like a charm. I can get the
report at a high level and drill down in the RBS, right down to the Resource
level.
That's fine so long as the calculation involves combinations of data fields.
As soon as I make the calculated field equal to a function, or even a
constant, then the drill down finishes with all resources appearing in every
lowest level entry of the RBS.
For example, it's fine if the calculated field = [Measures].[Work] or even
[Measures].[Work]+[Measures].[Baseline Work]
but not if it = [Measures].[Work]+1
or = now()
or even just =1.
It's bugging the hell out of me.
Any thoughts?
Denis
availability and some calculated fields. Works like a charm. I can get the
report at a high level and drill down in the RBS, right down to the Resource
level.
That's fine so long as the calculation involves combinations of data fields.
As soon as I make the calculated field equal to a function, or even a
constant, then the drill down finishes with all resources appearing in every
lowest level entry of the RBS.
For example, it's fine if the calculated field = [Measures].[Work] or even
[Measures].[Work]+[Measures].[Baseline Work]
but not if it = [Measures].[Work]+1
or = now()
or even just =1.
It's bugging the hell out of me.
Any thoughts?
Denis