Hello All,
Trying to configure Year ago measure. Previous year same date data. But instead of that it is showing values for year 2018 instead of 2016. ..
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.
Why edit option is disabled for me ..
Edit: ok had to open your screenshot
The edit button is always grayed out if you do not select a physical mapping.
How to make it enabled?
3295595 wrote:How to make it enabled?
Christian Berg wrote:
^--- Well...select a physical mapping. It helps to read answers posted in your threads.
I read .. But didnt understand ...
in 12c edit is grayed out
but in 10g we can
a) Why are you not displaying the mappings in 12?
b) Online or offline?
c) If online - did you disallow RPD updates in EM?
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.
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/
which mapping?
online
not disallowed
Do you know if connections that do not use TLS will be affected by the September 2026 update? Regards, Alison.
We have a requirement to embed OAC reports within the OCC Marketplace for both Organization and Non-Organization users. Currently, Organization users can access the reports through Oracle Analytics Cloud. However, the requirement is to make these reports available as embedded content within OCC Marketplace. When a user…
Hi Team, We would like to raise an enhancement request for the SSO/SAML configuration guidance for OAS 2026. We have already raised multiple SRs regarding OAS 2026 SSO configuration. However, we are facing difficulties getting the required guidance, as the available documentation does not clearly cover the OAS 2026 SSO…
We are planning to archive the Contract and Lease data currently sourced from the External Source as Contract and Lease accounting functions are being migrated to Oracle's CLM and Lease Accounting modules. At this stage, only active and partially closed records are being converted into Oracle and the remaining historical…
The difference column is a calculation, and I would like to average that row.
