Oracle Analytics Cloud and Server

Products Banner

Dynamic headers in OAC classics report

Received Response
294
Views
13
Comments

Summary:

Dynamic headers in OAC classics report

Content (required):

We need dynamic column header in classic report ,eg.

header1 = current date -7,header2 = current date-14 ..... etc.

for example : current date = 09Dec2022

header1 = 09Dec2022-7 = 02Dec2022

header2 = 09Dec2022-14 = 25Nov2022

We tried using union report to achieve same.

since in main report(data report) data types for columns are mixture of number and varchar which is used in further calculation can't be change data type so union report (for header) is not working.

Any suggestion on same.


Tagged:

Answers