Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Year ago measure
Answers
-
Yes. Otherwise things will not work properly.
Also as I said: fact based attributes is a "No!". Get rid of them and only use correct dimensional attributes.
0 -
Why edit option is disabled for me ..
0 -
Edit: ok had to open your screenshot
The edit button is always grayed out if you do not select a physical mapping.
0 -
How to make it enabled?
0 -
3295595 wrote:How to make it enabled?
Christian Berg wrote:
The edit button is always grayed out if you do not select a physical mapping.
^--- Well...select a physical mapping. It helps to read answers posted in your threads.
0 -
I read .. But didnt understand ...
in 12c edit is grayed out
but in 10g we can
0 -
a) Why are you not displaying the mappings in 12?
b) Online or offline?
c) If online - did you disallow RPD updates in EM?
0 -
Hi,
If I were you I would read around dimension hierarchies and the time dimension.
I would then implement a physical table that has surrogate keys at Year / Quarter / Month / Date (if needed) levels. Your keys should ensure uniqueness at each level; i.e. 2016 / 201603 / 201608 / 20160823 NOT 2016 / 3 / Aug / 23.
You then build a dimension hierarchy that reflects these levels.
Your time dimension then joins to your fact table via the surrogate key.
Then start thinking about time series etc, after you have resolved your fundamental issues.
See => https://gerardnico.com/wiki/dat/obiee/obis/time_dimension
https://www.rittmanmead.com/blog/2017/02/obiee-12c-time-dimension-logical-sequence-number/
Get this right and you have laid the cornerstone to Business Intelligence.
0 -
Some extra reading with a direct link to time series functions:
https://gianniceresa.com/2017/01/time-series-functions-why-how-what-where-obiee/
https://gianniceresa.com/2017/01/sequence-numbers-time-dimensions-new-obiee-12c/
0 -
a) Why are you not displaying the mappings in 12?
which mapping?
b) Online or offline?
online
c) If online - did you disallow RPD updates in EM?
not disallowed
0
![[Deleted User]](https://us.v-cdn.net/6037859/uploads/defaultavatar/nT2GKTLRQJ3P1.jpg)
