Hi Erika, Have you looked into EPM Narrative Reporting or Process Cloud within the Visual Builder PaaS offering? I think one of those two might be the start of what you're looking for - wrapping an approval/editing workflow around a report production process. Hope that helps, Glen

Agreed, this would be very useful for validating/documenting current configuration.

Hi Lokanath, Ok, sorry for the confusion. You mentioned OTBI in the question, so that's what made me think you were pulling from a subject area. But if this is BIP only, you might have an option to do it in the layout. There is some pivot functionality there, but I haven't personally used it. What I was suggesting was…

BIPublisher gives you control over the SQL, so I think that should work for you. You may get better performance if you can extract the physical SQL from your original OTBI Analysis and pare that down to just the essential columns and base tables, but hopefully that's not a concern for you. Pulling from the OTBI Subject…

Hi Lokanath, Have you looked into writing your own Logical SQL in OTBI, or creating a BI Publisher report based upon the OTBI Subject Area you're interested in seeing? There are ways to pivot rows to columns in SQL, so I believe this is something you should be able to accomplish today. It won't be end user drag-and-drop,…

Agreed, this is much needed functionality. Audit exists around the objects in the BI Catalog, but now Admin configuration like Delivery Channels or Runtime Configuration properties.

Hi Cody, Are you creating those layouts as BI Publisher RTF templates? If the ultimate output is Excel, you'd be better off building this with a single true Excel layout template. Those support producing multi-tab Excel files, plus better Excel field formatting overall than RTF templates. So one BIP template leads to one…

Hi Karan, Sorry for the late response, but correct - that's the intent of the LE timezone settings, to derive the correct accounting date for all applicable transactions. Hope that helps, Glen

Agreed, it would be useful to combine the best features of true Excel layout templates with online preview.

Agreed, would be a nice enhancement that can easily be implemented by checking the module status in Functional Setup Manager.