What Joel said ... You have an issue in your hierarchy keys. "Q1" or "January" can't be keys because they aren't unique but shared for every year. So you need things, like Joel posted, like "2015Q1" or combine the year with the quarter to make the key unique.

Hi, Just use the SUM(... by Guest) > 1 in your filter of the analysis. Just make sure the calculation is right by adding the formula in a column first and validate it, then you just filter on that column and then you can delete the column itself as the filter will copy the formula.

I would just say it's more complicated than just "a place", it can be all over a bunch of places. Because the size of one impact the size of the other, it has some limits (min and max I would say) and then adapt based on the window size etc. It could be way more complicated than expected ...

How many users do you have there inside? How many init blocks are executed at login? (all the session variables init block which aren't delayed) UserPopulation: GetUsers took 20 seconds for SQL {call NQSGetUsers('NAME=testuser5','DISPLAY_NAME','ssi')}, with results: 1 This already tell you where 20 seconds went ...

Google or just looking in the doc they say somewhere how to export and import the users/groups.

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…