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…

Hi, Welcome to the forum. You maybe want to invest more than 10 seconds in your thread if you want to have a chance to get some replies. That title maybe make sense for you, but nobody else see you screen or is inside your mind. You should write enough enough information providing the context, what you did and what…

The thing is that there is still a lot of info missing to have a full picture of the context of your setup. And BI Server errors code aren't as documented and universally known as an Oracle database ORA error, so no idea if I even ever saw a "nQSError 12061".

A subpage is just like a page, they all have individual links and are displayed differently as subpages, but they are just pages likes others. The same link format working for a page will do for a subpage.

Open the column and rename it. You maybe want to invest 30 seconds in writing a full question if you are after a different reply, because we can't know what you are seeing or thinking if you don't write it...

Security isn't file based anymore (the official source is OPSS), therefore you can't and shouldn't touch that file and it can't be moved. That location is inside the domain because it is still used for all the metadata still on disk (like catalog), but it's based on the domain. You should put the whole domain somewhere…

OAS doesn't work like older OBIEE version, the SSO happen now "outside" OAS because OAS itself has its lightweight SSO turned on and it should be left like that because it's required for the tool to work properly. In this setup, once SSO is setup for OAS, it will cover Answers (classic), DV, Publisher and everything at the…

In various versions there was that "-D" magic parameter (that wasn't explained at all) that was suggested if the command without didn't work. Did you try adding -D to your command and run that?