OBIEE does add a limit on the number of rows of each query taking the value from the settings. If you want to dynamically limit the number of rows based on a value you enter/pass to an analysis, you should add a filter on the analysis and using a row number column or rank or rsum or anything else that will generate a…

Couldn't you just keep using the thread that exists with replies? Double posting is against the community rules. https://community.oracle.com/tech/apps-infra/discussion/4512528/obiee-export-artifacts-from-bi-server And still you aren't saying what version of OBIEE you talks about: 12c is 5 different main releases and…

Nobody download and open random Word files from a forum, the forum let you write long texts and add pictures if needed. And if you have a question about Fusion, you should ask in https://community.oracle.com/customerconnect because here is for OBIEE/OAS.

And where are your accounts managed? Did you integrate your corporate AD/LDAP? Are you having SSO?

What exact product and version are you asking about? (OBIEE 19c isn't a thing, doesn't exist) What kind of account do you mean? Where/in which part of the product?

None has the report name as primary key because the tool couldn't care less about the report name. The key is the JobID. The path of the agent should be one of the parameters or properties there around. Depending on the history of your environment it can be wrong, let's hope your environment is "clean". If you want a…

The tables are s_nq_job, s_nq_instance, s_nq_err_msg (not just errors, logging in general) and s_nq_job_param. All we want is simple: Need all receivers for each active /enable scheduled report (Agent) . And if one of your agents use a dynamic list of recipients, what you want is not simple anymore and just become…

I would slightly disagree with Federico, the info is available out of the box, but it isn't available as a nicely formatted list like your audit asks for... Your are on OBIEE, this means you have already direct offline access to your catalog (no need of a copy), you can use Catalog Manager (the GUI will do the job if it's…

@User_PHX1F , Welcome to the forum. As this is a 3+ years old thread abandoned by the owner, how about you create a new one asking your question and providing your context (a product name and exact version is always helpful). You will get more chanced to have helpful replies quickly, without having "same exact issue" that…

so All I have is numeric values as string and casting should solve the problem . Not really, and that's what Federico was saying: you can cast all you want, but if you don't tell OBIEE/OAS that the column is a measure, the tool isn't going to aggregate anything. Did you tell the tool that column is a measure and should be…

Isn't this just the same as https://community.oracle.com/tech/apps-infra/discussion/4507121/siebal-dac-v7-8-2-is-compatible-with-informatica-version-10-5#latest ? For your compatibility question, it's generally quite simple: products come with a certification matrix listing what is officially certified or not with it. If,…

I will not say I agree or disagree, but that's the price to pay to have a cloud product running on a black box (no access to the system or any config file) ported to on-premises. Do I like it? Nope Can I live with it? Not really a choice...

I was expecting that kind of reply, but in all fairness you only gave examples with a fixed format in the first place... You are taking the problem in the wrong way... Did you look once at the query sent to the database with that kind of formula? It will perform poorly and you are trying to have OBIEE doing the job that…

You just have to take it step by step and combine all the pieces like when playing with Lego... TRIM(BOTH ' ' FROM SUBSTRING('De Army, Miss Lucinda Diana' FROM LOCATE(' ', 'De Army, Miss Lucinda Diana', LOCATE(', ', 'De Army, Miss Lucinda Diana')+2) FOR LOCATE(' ', 'De Army, Miss Lucinda Diana', LOCATE(' ', 'De Army, Miss…

You did install OBIEE 12c on a Windows 10 OS? Drop your vm, create a new one with a supported OS and reinstall. OBIEE 12c is NOT certified to run on Windows desktop versions. The forum is full of threads of people who "successfully" installed the tool but it just doesn't work (the lucky one saw it once till a reboot, the…

As its production env, logging disabled. Sorry but what is this supposed to mean? What’s the theory of disabling logging in prod? Please don’t tell me it’s because you believe the myth that disabling logging improve performance. Exactly because it’s a prod environment you need logging, because guess what? How are you…

Are they really reports? Or just analysis? You do have logs, don't you? You can see what the analysis does when you open the page, the logs tells you everything. A forum can't guess much while the logs tells you exactly what is going on, and as a direct consequence you can see what actions need to taken to change the…

Look at the function LOCATEN , it allows to use a 3rd parameter being the character where to start looking for your search thing. You will need to combine LOCATE and LOCATEN a few times to find, for example, the location of the space character before the name and then the space after it or just the end of the whole string,…

Do we agree you aren't really looking for any reply? Because your thread is empty....

This is not true. we can upgrade from 12.2.1.3 as well. Of course, you can even migrate from 11g, but the documentation only gives the process from 12.2.1.4 and for everything else it's a generic "If you want to export metadata from other 12c releases, use the corresponding command to create the export bundle.". How about…