Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 215 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Make Folder & Column heading vary.
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
Answers
-
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,
0 -
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 ?
0 -
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
0 -
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
0
