Year ago measure

[Deleted User]

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

Why edit option is disabled for me ..

[Deleted User]

Edit: ok had to open your screenshot

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

Sunny86

How to make it enabled?

[Deleted User]

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

I read .. But didnt understand ...

in 12c edit is grayed out

but in 10g we can

[Deleted User]

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

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

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

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