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

Comments:

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

Posted by Sergey Porokh on September 17, 2009 at 11:20 AM MDT #

It was fascinating. You seem very well-informed in your field.

Posted by Eric J. Franklin on February 03, 2010 at 11:07 PM MST #

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.

Posted by Stupid Videos on February 05, 2010 at 05:07 AM MST #

Easily some of the greatest tunes ever made, been a fan for as long as I can remember.

Posted by Allan Pernin on April 04, 2010 at 01:46 AM MDT #

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.

Posted by vuitton on June 23, 2010 at 05:30 PM MDT #

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).

Posted by louis on June 23, 2010 at 06:56 PM MDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Follow bipublisher on Twitter Find Us on Facebook BI Publisher Youtube ChannelDiscussion Forum

Join our BI Publisher community to get the most and keep updated with the latest news, How-to, Solutions! Share your feedback and let us hear your voice @bipublisher on Twitter, on our official Facebook page, and Youtube!

Search

Archives
« March 2015
SunMonTueWedThuFriSat
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
    
       
Today