Loading dynamic headers through xml

Suite and Optimus Suite 5
#1

Hi,

I have two headers. The first column in my header is dynamic and should be loaded from xml and remaining columns are static and i need to use colspan after second column. The second header also contain some dynamic columns to be loaded from xml. I tried the following code
select x “” from (
select 0.1 , ’
‘||decode($LEVEL$,‘1’,‘Account Manager’,‘2’,‘Sales Level 5’,‘3’,‘Sales Level 6’,‘4’,‘Segment’,‘5’,‘GTM’)||’
Plan($M)




Bookings($M)




Bookings(% Plan)

' from dual Can you please help me in this issue.

Thanks,
Pravallika.

#2

I think you’re missing the tag at the end.