The question has already been asked various times over the last years, the answer never really changed. The recipients of an agent are stored inside the agent itself. So there you go, you can do whatever you need to do with it. PS: in the future when you have a question you should create it as such and not as a discussion…

Hi, Oracle Analytics Server or OBIEE isn't certified for Windows 10, it isn't supposed to work (many spent hours if not days to finally have to accept reality). Install Virtualbox and setup a VM with a supported OS for the product you want to install. A linux VM will be smaller.

What you call "Extra header" is the presentation table name, rename it for all your column (in the analysis) and it's supposed to merge automatically. You then can align it the way you want.

Keeping it short: you can migrate content across versions and a change of OS, it does work. Just don't expect anything to work directly with 2 clicks and no manual intervention: that is the idealistic case and only work with sample content (= no content more or less). In a real situation there is always something requiring…

https://community.oracle.com/tech/apps-infra/discussion/comment/16837236#Comment_16837236 Are you asking us about your migration process? Because you are the one who decided on the process and the steps for the job, not us. You can't use the the existing RCU schemas because you have mismatching versions.

https://docs.oracle.com/middleware/12212/biee/BIEMG/GUID-F1204007-2846-425D-8BF1-A05CF153CA7B.htm#BIEMG3104

Set a repository variable containing your fiscal year, and then populate the variable with the correct logic for the need ("your" fiscal year follows your own rules, you should have a business logic defining how the fiscal year is defined, so implement that in a piece of SQL). In your formula use the variable and done.

I would first setup the authenticators and the whole security realm before to import the BAR, because if you import the security model of the BAR it will map groups to approles, and if your groups do not exist it will maybe not like it much. Also another thing to do anyway, because it's jump between 4 versions from your .0…

Go into the logs and find the real reasons for the very generic error you see on screen. Logs tells you everything...

What's the point of randomly trying things in a product without first understand how it works? OAS is not OBIEE 10g or 11g The linked thread doesn't apply: you are on OAS, that thread was probably OBIEE 11g. So many things changed about how the RPD is used, manipulated and persisted. You don't have to take my reply as…

At the best you can move the SDD, and that's documented: https://docs.oracle.com/en/middleware/bi/analytics-server/administer-oas/change-singleton-data-directory-sdd.html The linked thread doesn't apply: you are on OAS, that thread was probably OBIEE 11g. So many things changed about how the RPD is used, manipulated and…

Kind of ... You can create an analysis that only check the value of one or multiple prompts. Ages ago I did write about this, it wasn't exactly your use case, but all the logic is still valid and easily adapted to your needs: https://www.rittmanmead.com/blog/2014/03/obiee-dashboard-prompt-at-least-one-mandatory/ The idea…

I believe the "Prompt before Opening" was a something added to provide a simple "two-steps" process when opening the page, mainly to inform users about the fact they need to pick prompt values and the analysis shouldn't be used without those prompts set. If you want to really force the user to always pick all values that…

[nQSError: 23024] The last argument to the AGO function must be a constant integer. (HY000) This is the error I got in OAS 6.4 building a case similar to yours. As you can see the main difference in the message is "constant". The formula is expecting a value that doesn't come from a dynamic formula and therefore being…

None of this worked, what am I doing wrong? If you only enter these 3 TIMESTAMPDIFF code in a column formula, what do you get as result? And what does "none of this worked" means? You got an error? You got nothing? You got something different than what you expected?

Hi, Could you be a bit more precise on what product (full name) and exact version you are asking about? The post is maybe in the wrong category, based on these extra details it can be moved in the right place to get you more chances for a correct answer.

If your numbers are 3x the original, the issue comes from the join happening. It can be an issue of granularity: you select your attribute but forgot that this attribute isn't unique but exist multiple times in the table and therefore aggregate rows multiples times. The easiest way to fix the issue is to look at the…

https://community.oracle.com/tech/apps-infra/discussion/comment/16835527#Comment_16835527 That link is not about OBIEE, it's about OBIA. And you asked in the OBIEE category about OBIEE. Are you saying that you are asking about OBIA instead?

OAS doesn't have any support for Informatica, just like OBIEE doesn't have any support for Informatica : both OAS and OBIEE don't interact at all with Informatica. OAS and OBIEE do use data stored somewhere, how the data get there (Informatica as ETL) isn't something OBIEE or OAS do care about.

two or more words, in order or out of order This one is fairly simple, not simple to do but simple to cover: you either take the possible workarounds or forget that requirement (because that's really a search engine approach). Multiple fields for multiple words: that's the only way you can easily deal with multiple words,…