Percentages in a Crosstab - Report Author 10.1.2 (Dim. Hierarchy)

[gosoccer]

Folks,
This Crosstab Report is build using Dimensional Hierarchies.

???
As the attachment shows, I have a cross tab that shows Success and Failure but now for each of the crosstab node, I need to
add % of Success and % of Failure after each Cross Tab node member. I was curious which way would be the simplest way
to do this?

1) To establish the % values as a part of cube generation OR
2) To simply add a node member and use some sort of percentage calculation.

If you could provide clear steps of how I would do #2, it would greatly help.

Thank you in advance for your time.

[gosoccer]

If getting it done at cube generation is the desired choice, could someone tell me what option under Insert Measure I could take
to create the %.

[Francis aka khayman]

#2 would be the easier step.

create a member that will add all the rows:

[Total Rows] = member(total([whatever rows]),'Total Rows','Total Rows',[Hierarchy of the Rows])


[success pct] = [Total Rows]/[Success]
[failure pct= = [Total Rows]/[Failure]

[gosoccer]

Could you please elaborate on this if you could,
create a member that will add all the rows:

[Total Rows] = member(total([whatever rows]),'Total Rows','Total Rows',[Hierarchy of the Rows])


[success pct] = [Total Rows]/[Success]
[failure pct= = [Total Rows]/[Failure]

So, in the Transformer, I'll use the options under Measure to create a member? Or other options within
the transformer to do the above.

My apologies for my ignorance but meeting a very severe deadline.
Thx so much

[Francis aka khayman]

create a data item called Total Rows using the formula i have given. make the necessary substitution on [whatever rows] and [Hierarchy of the Rows] to the correct items.

I think [Hierarchy of the Rows] is optional so you can choose to remove that.

[gosoccer]

Yes, I did it in the Report Author and it works well.
thank you so much. This did the trick!!