To be honest technically what you ask could be done but ... it's bad (I'm kind of sure the licensing conditions prevent that and also it means your laptop/workstation is now a server always up etc.) So follow what Francesco is saying, it's the correct way of doing things

What version of Essbase? And what kind of Essbase is it? (OBIEE one, standalone, EPM ?)

You can find the logs in C:\Users\<your username>\AppData\Local\Temp\DVDesktop\logs I would look into OBIS\obis1-diagnostic.log

Hi, As I managed to connect to Essbase with the earlier version (didn't try with the last one) there isn't a generic global error. Did you try checking the logs to see if you get some words about the reason? (the GUI just return a generic error) PS: which version of Essbase? I guess I remember there was some issues with…

Are you talking about Data Visualization Desktop which is currently at version 12.2.2.1.1-20161222001521 ? Or do you talk about the one installed with OBIEE (the /va/....) ? DVD can load XLSX files from Office 2016, so what kind of support do you look for? The OBIEE Data Visualization one also can load Office 2016 Excel…

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…