Yeah, smart move ! I find it totally wrong from Oracle to call it "New homepage". It isn't the same tool (or why does it require a new license?), works in a different way and cover different needs than the "classic" home. So it's good that you got rid of that link there.

Hi @Phantasm, Aren't you working with Rahul? Error while saving an OBIEE report with 100+ columns PS: "wrong tool for the wrong job" seems to match sadly ...

Staying neutral on the topic I would just say that looking at the history of the OP you also see that it isn't about a forum but just really about what Christian called "do my homework", as none of the threads have never been closed and the OP never ever posted anything back when people posted answers or suggestions. A…

Just what the doc says ... (and a bunch of blogs post Google return in the first page of results)

Ok, good that you answered that as I was hoping for it Good news: there is no link at all between these 2 things. The "row count" is just inside the RPD for your information, when you build a model it's good to know the size of tables because it can impact how you define joins, driving tables etc. But it has no impact at…

Hi, Sorry to ask something instead of giving you a reply .... What's the link between "connecting to a database refreshed every minute", "run reports out of it" and the 2 things you asking? The ability to do analysis on a database refreshed every minute doesn't depend on an updated row count or check in/check out ... So…

Larry's Friday Girl wrote:it now errors with a conversion error Hi, Thanks for letting us know In case it's a question, what's the question? And you will have to post a bit more if you expect an answer ... Things like the detailed error, the conversion used, the version etc.

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.