I am trying to create a summary page based on data that is on subsequent worksheets via the Excel template in Bi Publisher 11g.
I wanted to know if there is a way to reference a Group. So if I had a Department (G_D) and a Employees (G_E) groups in the data model and then I wanted to reference G_D on both sheet 1 and Sheet 2 in the spreadsheet how would I do it.
I created the equivalent in the XDO_METADATa Sheet:
Don't know if there are any Excel template/Bi Publisher developers out there but it initially appears to me that if you are doing anything a little clever you are on your own.
When I mean clever, I mean do more than just publish data directly, unformatted, unchecked or unmanipulated from the xml by creating sub totals and totals, additional functions both row and group level then it may be possible but you have to find out on your own.