Year ago measure

[Deleted User] · Oct 25, 2017 1:39AM

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.

Sunny86 · Oct 25, 2017 2:59AM

Why edit option is disabled for me ..

[Deleted User] · Oct 25, 2017 3:17AM

Edit: ok had to open your screenshot

The edit button is always grayed out if you do not select a physical mapping.

Sunny86 · Oct 25, 2017 4:09AM

How to make it enabled?

[Deleted User] · Oct 25, 2017 4:14AM

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.

Sunny86 · Oct 25, 2017 4:28AM

I read .. But didnt understand ...

in 12c edit is grayed out

but in 10g we can

[Deleted User] · Oct 25, 2017 4:35AM

a) Why are you not displaying the mappings in 12?

b) Online or offline?

c) If online - did you disallow RPD updates in EM?

Robert Angel · Oct 25, 2017 4:47AM

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.

Gianni Ceresa · Oct 25, 2017 5:15AM

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/

Sunny86 · Oct 25, 2017 6:59AM

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

Oracle Analytics Forum

Categories

Year ago measure

Answers