Can I Create Additional Title Header or Label in EView

Post Reply
bunchukokoy
Regular Participant
Posts: 197
Joined: Thu Dec 03, 2009 8:47 am
OLAP Product: IBM Cognos TM1
Version: 10.2.2.x
Excel Version: 2010
Location: Singapore

Can I Create Additional Title Header or Label in EView

Post by bunchukokoy »

Hi Guys,

Good Day!

I find the members here in this forum to answer on questions faster than the members from where, I know, this topic should truly belong. Forgive me guys. :) :) :)

Is it possible in EViewer 9.4 to create a label or a textbox where I can put a title header or a text? It since as far as I know, I can only use the elements to be the headers by just changing their display names. However, I'm creating an EView which should be the same with my Excel report. The problem is, I have additional descriptive titles headers in my Excel rep which are definitely not elements of any dimension from my source cube.

Can anyone help me please?

Thanks a lot always. :D :D :D

Bunch
rmackenzie
MVP
Posts: 733
Joined: Wed May 14, 2008 11:06 pm

Re: Can I Create Additional Title Header or Label in EView

Post by rmackenzie »

Do you mean Executive Viewer?
Robin Mackenzie
bunchukokoy
Regular Participant
Posts: 197
Joined: Thu Dec 03, 2009 8:47 am
OLAP Product: IBM Cognos TM1
Version: 10.2.2.x
Excel Version: 2010
Location: Singapore

Re: Can I Create Additional Title Header or Label in EView

Post by bunchukokoy »

Yes Sir, Executive Viewer, 9.4 specifically.
rmackenzie
MVP
Posts: 733
Joined: Wed May 14, 2008 11:06 pm

Re: Can I Create Additional Title Header or Label in EView

Post by rmackenzie »

In which case I think the answer is no, you can't if you are using the out-of-the-box cube-and-graph-viewer for you views. You can however, create custom HTML/ Javascript pages where you can display e.g. just the rows and and columns of the grid and not the titles (IIRC the offspread). Then you can display whatever labels you prefer and feed the element-equivalents of those custom headers into the view via the EV API when the user makes changes to the view.
Robin Mackenzie
bunchukokoy
Regular Participant
Posts: 197
Joined: Thu Dec 03, 2009 8:47 am
OLAP Product: IBM Cognos TM1
Version: 10.2.2.x
Excel Version: 2010
Location: Singapore

Re: Can I Create Additional Title Header or Label in EView

Post by bunchukokoy »

Ouch. :D

Thank you Sir Mackenzie!

Actually, I have a back-up plan Sir. I already have tried it and it worked. I just wanted to know if I was missing something in the features/functions that will ease my creation of the report.

What I did was to enter a formulated row thru' Calculator. In which case, adding formulated row I think is limitless. At first, the values on the cells of this row are zeroes. What I did was to edit the number formatting and put a fixed text values, which are actually the text values or the captions of the column headers. After doing that, I formatted the column headers into a single color background and the fonts except the intended middle columns/parts of my intended title headers. Then I changed the display name into my intended additional title header. The column headers are now my title headers, as if they are another dimension stacked into the original column dimension. That's the only work around that I see.

Thank you Sir Mackenzie. :) :) :)

Bunch
Post Reply