You say you have problems when exporting as attachment (which I translate into "Export" > check "Email as attachment"). Does it work if you just export it? Does it work if you export without data/data connections? Did you try to check the logs?

In addition to what Christian said, so the tool being on your desktop, nobody prevent you to share your desk, your seat, your keyboard and mouse with a coworker but I suspect it's not what you expect DVD has an option to "export" a project, in the export you can include data (if you want) and connections details (if you…

So you look for caching, as retrieving the data is slow you would like to cache it so the users will not have to go down to the DB but VA find the required in the cache (=> faster). Right? (Just making sure to focus on the right piece) Your source is the database directly (so using a datasource pointing to the DB) and not…

As far as I know there isn't a caching like the one you look for in VA, if you were using OBIEE as a source (the RPD, not some direct db request thing etc.) you could use the OBIEE cache in theory (so using agents on the OBIEE side to populate the cache in the morning).

ashu_eureka wrote:...data gets refreshed everyday ... Well ... depends what data you used? If you use a DB or any other "external" source data is refreshed when you load it, not when you open or not your VA report. Or did you build your VA report on Excel data you uploaded and you want to automate the refresh of that data?…

There isn't one because the BIP Desktop Tool is only for Office on Windows. So if you want it on mac you must use a VM running Windows and install Office there inside.

Just wanted to add an info I got via a different channel: Oracle owns a patent on BVT, and that's probably also one of the reasons of why they don't share the code publicly or anything (it would anyway be a long and complicated process AFAIK to do that at Oracle). In this context they could maintain BVT to keep making it…

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…