Well ... I took what I got as input It sounded like a snapshot table where the OP wanted to work only on the last snapshot, and because LAST is already an aggregation when the OP asked for aggregates on last snapshot it sounded as a WHERE ... But of course everything is possible, depends on the exact need of the OP.…

As you are new I will put you on the right direction So you want to get the current date/time, subtract 2 hours and keep only the hour (so 00:00 for minutes and seconds). In OBIEE that's equivalent to this: TIMESTAMPADD(SQL_TSI_HOUR, HOUR(CURRENT_TIME(0)) - 2, CAST(CURRENT_DATE as TIMESTAMP)) CURRENT_DATE = give you the…

Forget SQL, you are in the logical layer of OBIEE, the logical layer doesn't speak SQL like a database because it could be pointing to an XML file, a SQL Server etc. So click the icon on the right of the textarea, the one with the "fx". There select "Category" = Functions, "Functions" = Calendar Date/Time Functions and…

Honestly get in touch with your Oracle representative to get these answers (and ask him to reply by email or writing and not just over the phone so you have something written). Oracle license do not ask you to enter any license key, but if you use something you aren't allowed by the licenses you own or more users etc. You…

Hi, Add a WHERE condition on the logical table source of your logical fact table. It will limit your fact table by the condition you write all the time.

Yes, that's the OBIEE mail settings, so agents for OBIEE. Publisher is an independent tool in the end, it's sitting there in the middle, but it has its own life ... It shares security if configured that way, it can use the BI server as a source but it's still an independent tool.

The source (edelivery or OTN) doesn't matter : it's the same software, same binaries, same everything. So take them from where you can. OBIEE 12c I guess I always downloaded it from OTN just because on eDelivery it was too annoying to find it (because of the various namings of products etc.). So go with the one you can get…

Not really because users and group aren't an OBIEE thing or a FMW thing. They are a Weblogic LDAP thing. There are WLST scripts allowing you to export users/groups from one environment and load them into the new environment.

Hi, It's gone ... There isn't a public Sample App anymore, it's quite some time already The 2 options you have are: a) run your own Sample App: OBIEE Samples b) get a trial account on Oracle Cloud and start an OAC instance and for 30 days you will have an online environment you can start when needed There isn't any sign so…

My bad ... I was thinking at a column formula, not a calculated item. A calculated item just can't accept CASE WHEN, it only accept simple calculation between items. That's because your "pickup" column isn't a measure or anything like that, it's just an extra item added into the values of the 'snapshot date' column.

I smelled a pivot and an intra-dimension calculation How are the last 2 dates defined? Do they come from a prompt or from a variable or something? You could use FILTER instead of $3 and $4, so you are sure about what happen The thing with CASE WHEN is that the condition to say if the calculation must be done or not can't…

Joining Christian comment I suspect something a bit "weird", so if you post more details (I imagine a screenshot is asking too much) it will be easier to point you in the right direction more precisely.

Hi, A formula is a formula and execute what you wrote, so if you want to apply it only to some rows you need to write the conditions in the formula itself to say when it must be used or not. CASE WHEN is the most used approach for that.

3004672 wrote:We have migrated our OBIEE Catalog & RPD info from one server box to another server box. How did you migrate and what exact version of OBIEE are you using?

Hi, I'm not sure to "see" what you try to get as final result ... (It's Monday) You would like in an existing listing of employees coming from your "Employees" subject area display attributes like "Job" and "Organization" and that's fine as you have those attributes in the "Employees" SA. But now you would also like to…

Hi, Sorry but ... what do you expect from the forum and/or ODC? You aren't really asking anything, and based on your statement I can just say: go ahead, do it !

I definitely know what OBIEE is, what Publisher is, and what and how and where Publisher is in OBIEE. Your wording is confusing as there isn't a thing called "OBIEE Publisher", it's either OBIEE or Publisher and they are quite different (even more when about security if you aren't using the Fusion Middleware secuity in…

Sorry but is that OBIEE or Publisher? You talk about OBIEE things but call it OBIEE Publisher (they are 2 different products in the end), so it's slightly confusing ... And no need to mention that support for your version of OBIEE was over 4 years ago, you may want to consider to upgrade one day ... Is your "user_n1" a new…

If I'm not wrong there is a plugin for IIS which make IIS act as a proxy in front of weblogic. A bit like OHS (Oracle HTTP Server) which is just Apache acting as proxy. I never set it up in IIS, but there was/is definitely a little plugin making this "proxy-like" setup. So "UI hosted on Windows" sounds like a pretty poor…

Hi, It somehow complain about incompatible types. Does the analysis ("report" = Publisher, "analysis" = the one you are opening ) contain a UNION? Is that something you copy/paste edited, migrated or moved around for a while? Does the same happen if you create a new (from scratch) analysis with the same logic?