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.
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 %.
#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]
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
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.
Yes, I did it in the Report Author and it works well.
thank you so much. This did the trick!!