Hi, You are posting in the OBIEE forum, wouldn't it be better to ask in the Data Quality forum?

As Ebin posted your IF in SQL is a CASE WHEN (think at how would you make a SQL query managing that condition). If you want to exclude current day values (in case they exists) adapt what Ebin gave you and change into a BETWEEN <the given formula> AND <your timestamp -1> and you get the same result. I would just say to…

Just in case for the future ... For database questions will be better to ask on one of the Database forums instead of the OBIEE one (it gives you more chances to get the answer and also help others looking for the same thing but looking in the right place for it ...)

Of course +1 what you (Christian) wrote above But I'm also translating what you said in a different language so everybody understand (it's Friday)

To make it short: Yes you have an attribute meaning the data version in your database on the same row as your measures, but in OBIEE you must model it for what it is: an attribute and not a measure. According to Ralph Kimball, [1] in a data warehouse, a degenerate dimension is a dimension key in the fact table that does…

As mine is before yours .... it's you copying me... But I don't mind, not your fault if a bit slow

Hi Dilek, An attribute in a Fact table? It's not supposed to be there, if it's an attribute (not aggregate mesure) it's supposed to be in a dimension. So model your fact as a degenerate dimension, set the content levels etc. as your did for your other dims and things are supposed to work fine.

Hi, In the admin page where you see the sessions in the logs you are supposed to see the LSQL and then the physical SQL (as long as your query doesn't hit the cache). If you don't see it (and it's not the cache) then just increase your log level a bit. It's all about the log level if you don't see the physical query ...

Hi, In the bottom-left part of the "Results" tab you can select your view and click on the duplicate icon. All your settings and formatting on the pivot view will be there in the new duplicated view as well. Not sure what you call "report view" ...

Except if the OP is on 12c as GUID doesn't exist anymore ...

Take it more like a mid-long term advice ... A bit along the lines of : give a man a fish and you feed him for a day; teach a man to fish and you feed him for a lifetime.

You can also simple add a filter to your analysis with your "year" column between YEAR(CURRENT_DATE)-1 AND YEAR(CURRENT_DATE) and use a pivot view .... Actually there are many ways as that's the way OBIEE works: if you have a correct model with a proper time dimension by default your figures are aggregated at the year…

On OBIEE privileges Deny is stronger than Allow, so if Admin is allow and BI Consumer is deny and you are both you have a deny as a result. If you remove BI Consumer (so no deny or allow) then by default they have a deny. If doing that and allowing only Admin and Author your BI Consumer still see it then you have…

Hi, Have a look at time series functions, TODATE and AGO. Actually TODATE isn't needed as you can take the revenu directly at the year level and on 2016 you have the current year revenue and the same using AGO will give you 2015.

Hi, Honestly using EVALUATE for all your things I would ask myself why to pay an OBIEE license if it's just to use the database, there are tools to visualize the content of the database which are way cheaper than OBIEE ... So why don't create your 6 calculations in OBIEE?

If you have a way to identify row 2 from row 1 and 3 yes. So do you have a way to identify which one is row 1, which one is row 2 and which one is row 3? As these aren't really measures I'm not sure if FILTER(... by ....) works, but for sure you will be able to model it in your RPD. If you had to write it by hand in SQL,…

Sorry but your aren't doing anything to help people helping you ... As you wrote the word "analytics" in the OBIEE forum we can guess you try to login to OBIEE, that's you provide as information ... How To Ask Questions The Smart Way There are things like version, security setup (providers etc.) ...

You can deploy it into the analyticsRes folder if you deployed that one, or also add it to your custom style and change references in files to make it work from there (actually you can try adding @import "font-awesome.min.css"; to the custom.css of your custom style adapting the required path etc.). There isn't any…

Hi, You mean that: Font Awesome, the iconic font and CSS toolkit ? If it's the one you talk about you can deploy the font-awesome folder on your server and add their CSS, but OBIEE will not use it anywhere ... It's up to you to add the pieces of code you need where you want to see the icons etc.

were you looking for something else?