TM1 Forum

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.

Bunch

Do you mean Executive Viewer?

Yes Sir, Executive Viewer, 9.4 specifically.

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.

Ouch.

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