X

An Oracle blog about BI Publisher

Summary Total Text in BIEE

Don't panic, we're not turning into a BIEE blog, I have been doing dome work with it lately and could not find the following nugget out there. Colleagues on an internal list helped out with my request - it was a simple one but I wanted to record it for posterity.

As many of you have seen you can generate totals and sub-totals in your BIP templates quite easily, you can also embed fields into the total label text.

bieetot1.gif

To get the customers name in the total text, its just a case of copy and pasting the customer name field into the table cell.

bieetot2.gif

I needed to do the same in a BIEE pivot table. Not quite so obvious but doable, once I got some help from my friends, ooooh I get by with a little help from my friends ... danged Guitar Hero! I dont even like the Beatles, for a Brit, sacrilege I know.

Building out the pivot you can see that if you set a total for the group you get XXXXX Total.

bieetot3.gif

the dialog to customize the total string is tucked away a little. Click the total icon again and select Format Labels

bieetot4.gif

This will pop the dialog

bieetot5.gif

You can now enter the text you want, the '@' character will be replaced at runtime with the actual group value.

The pivot now renders with the required text.

bieetot6.gif

Join the discussion

Comments ( 6 )
  • Sergey Porokh Thursday, September 17, 2009
    I have such template:
    >?for-each:G_DEPR_GROUP>?
    >?DEPR_GROUP>?
    >?MONTHLY_DEPRECEATION>?
    >?CNT?>?
    >?end for-each?>
    >?show-page-total:CN;'9G990D00'>?
    I'd like to use choose-statement on CN variable in order to display different Text values on a Page Level, eg,
    choose CN
    when 30 then
    "Thirty"
    when 40 then
    "Forty"
    ...
    Is it possible to implement it on a page level?
    Only known workaround - Layout in Oracle reports...
    I tried to use:
    >?xdofx:decode(xdoxslt:get_variable($_XDOCTX,'CN'),14,'Fourteen',31,'Thirty one', 'Other')>?
    but it returns null.
    According to the documentation:
    "The $_XDOCTX specifies the global document context for the variables."
    Do you know the context for Page-level variables?
    PS: I heve deliberately changed tage brackets
  • Eric J. Franklin Thursday, February 4, 2010
    It was fascinating. You seem very well-informed in your field.
  • Stupid Videos Friday, February 5, 2010
    I just came across your blog and have been reading along. I thought I would leave my first comment. I don't know what to say except that I have enjoyed reading. Awesome blog. I will keep visiting this blog very often.
  • Allan Pernin Sunday, April 4, 2010
    Easily some of the greatest tunes ever made, been a fan for as long as I can remember.
  • vuitton Wednesday, June 23, 2010
    Find out the next trend before it’s even out there with help from predictions of people in the top of the fashion industry. A great place to see crazy “trends” like oversized fabric chains or see-through bombers, that will probably never make it into your local department store. Free.
  • louis Thursday, June 24, 2010
    Overalls belong on a farm. Period. They don't flatter anyone, and there are much better ways to look down-home sexy (a checked shirt tied at the midriff is a better start).
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.