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?
Agenda Presentation: What's New in FDI 26.R3 Open Q & A: Ask your questions of implementation and product specialists Replays of past FDI CEAL Guidance Office Hours are available on Oracle VideoHub here. Fusion Data Intelligence - CEAL Guidance Office Hours The FDI Office Hours are hosted by CEAL solution architects who…
So when I click the apply button, it uses the value . Also. How do I stop the auto populate table when the report opens???? I am in OAC
Good day, please kindly assist. We are creating a graph to calculate the number of assets per milestones. However, the planners have only populated assets for only one milestone from the list of milestones the customer wants to track. Which gives an incorrect view as the project moves past different milestones that it has…
I scheduled the report in OTBI and the agent was run successfully. However, I do not receive the report after the run in my inbox. The addresses are properly recorded, and the report is in an excel format and saved as a pivot table in otbi. What can be the cause?
Anyone has any idea why the OAC documentation on custom viz is not available now? I was able to access till last week - https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsdv/build-package-extension.html. Does this mean OAC doesnt support custom viz or custom workbook extensions?
I made a parameter with letter range values… put it into a dashboard filter. Then I created an expression filter to bind it to my last name column in the table with the image I uploaded here. I am getting the following error??? Invalid Expression. Validation of parameter values failed. A general error has occurred. Message…
