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. ..
try , -1 where you currently have ,1
Shortest possible answer: Your model is seriously messed up if that is the result.
Alas technically this is correct:
For 2018 the YAGO value IS 38638965. It's just your underlying model that's wrong.
Hi,
I'm kind of curious to know what your model looks like as I hardly imagine how it is possible in a correct model to have a date like "10/10/2017" on the same row as "2017" AND "2018"!
So I would say your "year ago" is fine and it's your model wrong (or weird) and your "Deal date" is not part of your time dimension, so you can't expect OBIEE to make a year ago on something not being linked to the time dimension (as you see it works on the year column).
My date dimension... Couldnt find any issues. ..
I tried. It will just display the same 2017 value in 2016 also. Actually i want to display the value of 2016.
I made the Join to time dimension online . Also the time dim and measures created online without a restart. Can it be a problem?
used the time dim date column instead of deal date from fact in filter and criteria. It seems like worked .will update you soon.
You have a "deal date" column in your fact table? That's what I meant by weird model. If you made the right joins in the model you don't need to keep a "deal date" column as this one is supposed to be equal to the day column of your date dimension. So get rid of it and you avoid the mistake.
And you see once you take the right date it works as it was already working fine before ...
3295595 wrote:deal date from fact in filter and criteria
Deal Date on the Fact.....and that doesn't scream WROOOOOOOONG at you in the loudest possible manner?
Dates go into a dimension. That's dimensional modelling 101 from back in the 90s.
Edit: AND your Year level doesn't even have a chronological key...swell
Should i have chronological key every level or only at the date level?
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.
