Column Headings in Webi

building reports webintelligence legacy 1/2
1

I am trying to edit the column headings in Webi to include data in a table.

i.e. YTD Earn Dollars for the title - all that shows up is YTD Earn Dollars even when I select YEAR1 (an object in the query). Is there any way to edit html. I noticed Last Refresh: in the page lable has a <refresh_date> reference.

Thanks Kim

Listserv Archives (BOB member since 2002-06-25)

2

You’re variables are not available in WebI. Only a few special ones are available in a few specific locations.

Listserv Archives (BOB member since 2002-06-25)

3

I don’t know if this would be helpful, but here’s a solution I use whenever I need to include variable information within a WebI report: If I need to show information from a prompt or condition, I create an object within the universe that incorporates that info (i.e.,
'Selected Date Range: ’ || @variable(‘Enter First Date’) || ’ to ’ || @variable(‘Enter Last Date’). I then place this new object in the section portion of the results tab. It will appear as, for example, “Selected Date Range: 01/01/2000 to 01/31/2000” at the top of the report. Maybe not the best way, but it works and looks okay.

Listserv Archives (BOB member since 2002-06-25)

4

Sonya,

Thanks for your reply. Is 'Selected Date Range: ’ || @variable(‘Enter First Date’) || ’ to ’ ||
@variable(‘Enter Last Date’) placed in the Select portion of the object properties?

Thanks again.

Listserv Archives (BOB member since 2002-06-25)

5

Yup, that goes in the object’s select statement.

Listserv Archives (BOB member since 2002-06-25)