Make Folder & Column heading vary.

N&A Support Team · Mar 15, 2016 1:28AM

Hi everyone.

I received a requirement to make folder and column headings appear like this:

4/1 4/2 4/3 4/4 4/5 4/6 4/7 (Folder Heading level)

Mon Tue Wed Thu Fri Sat Sun (Column Heading level)

where the first digit contains the month (for instance, 4 represents the month of April) whereas the 2nd digit would represent the day (both at Folder Headings Level)

At Column Headings level, we need to display the day of the week.

Basically, the need is, depending on the month selected, make both Folder & Column Heading levels vary accordingly.

Any suggestions are much appreciated.

Cheers, Angel

cesar.advincula.o · Mar 15, 2016 1:56AM

Hello,

1. You want to vary Folder Heading level in your "Criteria Tab", you cant do it, there is no a standard way. If you want to do something like this you should hack it.

2. The another thing, if you could reflect something the "Result Tab"

- At "Column Heading Level", you could use presentation variable for getting some dynamic column, however it is not what do you need in your requirement.

Kind Regards,

Gianni Ceresa · Mar 15, 2016 4:27AM

Hi,

Do you have a measure for each single day?

I don't guess so ...

Why don't you use a pivot view and use your calendar dimension (if you don't have your date column) to have the date (month / day) and day name there on top ?

N&A Support Team · Mar 17, 2016 9:14PM

Hi all,

Thank you very much for your comments.

@ Gianni: You were absolutely right. In the end, this is exactly what we did and it worked fine.

Best Regards,

Angel

N&A Support Team · Mar 17, 2016 9:15PM

Hi all,

Thank you very much for your comments.

@ Gianni: You were absolutely right. In the end, this is exactly what we did and it worked fine.

Best Regards,

Angel

Oracle Analytics Forum

Categories

Make Folder & Column heading vary.

Answers