Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Alter legend
Answers
-
I thought that WAS a customized graph already.
So @CRX you "just" want to have a new dimensional attribute which bins fact rows into these groupings?
0 -
4 columns != 4 members in a dimensional attribute which to split the data by.
Thimas gave a good hint but depending on your model you need a different approach alltogether.
0 -
You'll need to create a physical/logical dimension ...
Dim_AgeBins
Key Description
1 24h
2 48h
3 72h
4 Em atraso
Create a logical hierarchy for this dimension and set the LTS levels to the detail level
then in your fact table, create a logical column that evaluates the hours between (CurrentDatetime - DeliveryDatetime) and assigns the correct AgeBin key. Join the tables in your model on the key and set the LTS for the fact at AgeBin detail.
0