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,…

That's what the doc say and the list is given, you just need to look for new patches if any to cover for the "or later" mention in all of them (patches can be superseded over time).

https://community.oracle.com/tech/apps-infra/discussion/comment/16835437#Comment_16835437 Wrong tool for the need: a dashboard prompt isn’t Google or a search engine. And could you just write all the requirements you are trying to cover at once? Because it’s now the 3rd version of the requirements, changing things around.…

What is the meaning of smith? I get an error. It is a default value if the variable isn't set. If the variable isn't set, your condition would be an error because the value will be missing. "smith" will be used in this case instead of the variable. You don't have to use "smith", you should use a value that you are sure it…

You didn't really follow the steps posted, or maybe you followed them too much without looking much at what you were writing and where. "Avis"."Titre avis" IN (UPPER('@{varNameSearch}{smith}') = UPPER("Dim All Avis"."Titre avis")) This isn't a condition in any known query language (SQL or LSQL). A condition is an…

Do you have any data for "today" ? There is no magic, OBIEE/OAS does generate a query and execute it. Look in the logs, find the generated query and there you will also find the reasons of no data for "today". Maybe there is an inner join that remove "today" because of no data available in a table. The physical query…