Hi, In the future you may want to consider storing the domain home outside the oracle home as it will make your life easier for upgrades. https://docs.oracle.com/middleware/1212/core/INFIN/infra_dir_structure.htm#INFIN351

There is a feature which does just that but not in a separate window, in the same one ... For every page where you check the checkbox highlighted it will wait for prompts to be filled before to execute the analysis (with a message telling the use it's waiting on prompts).

Hi, There isn't any public sample app anymore. You can either get your own http://www.oracle.com/technetwork/middleware/bi-foundation/obiee-samples-167534.html or get a cloud trial account and start an OAC instance there.

What Sherry George said. You can't "invent" the number of parameters of a function yourself: CONCAT requires 2, exactly 2 parameters. You try to use 3, can't work, so embed and extra CONCAT to first concatenate 2 pieces and then concatenate again 2 pieces and done. PS: OBIEE isn't Excel accepting as many parameters you want

Those links are at the analysis level, they can configures at the dashboard, page and analysis level. When you open the analysis in "view" mode you will also see them in general. You have a global refresh on the top-right if you click on your account name. As it's a browser you need to keep in mind there is a browser cache…

Well ... Difficult to say like that. It must definitely work, so what you have to do is to track all the things. So open the analysis, check what the server does (if it generate the query, if the query is sent to the DB, if the query is supposed to return the new records) etc. Logs right now are the best (and only way) to…

We will probably never see @3236706 again ... But it sounds like a badly configured time hierarchy with issues in the keys and that's why the YTD functions can't make a difference between months of different years.

A picture is worth a thousand words... There are other ways like disabling cache globally if you didn't want it (or don't need it), there is a setting in Enterprise Manager. You can also disable it on some sources (tables) in the physical layer in the RPD (there is a checkbox when you look at the properties for the table).

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.