Hi, I assume by "delivered" you mean via email. In this case you should ask the question to your SMTP server administrator. OBIEE can generate files of tens, hundreds of Mb, but mail server generally have a limit at about 10-20Mb for attachments, or even less.

That's the one, FMW and right version.

If it isn't confusing, it isn't Oracle and you aren't downloading the right product 😁 This page send you to https://www.oracle.com/middleware/technologies/fusionmiddleware-downloads.html From there they send you around a bit in the most confusing possible way, till at some point you get on…

Go back to the installation documentation, the certification and the download page: OAS 5.9 requires FMW 12.2.1.4, your 14.1.1.0.0 install is useless for OAS. Install the correct FMW and the problems will disappear. FMW is not swappable with a newer version just like that, the dependency is strict: OAS 5.9 <=> FMW 12.2.1.4

https://community.oracle.com/tech/apps-infra/discussion/4491344/where-does-the-oracle-analytics-server-saves-the-uploaded-files Who said they were stored as files in a filesystem? There is (was?) a webservice that has a limited set of features for datasets (your file isn't a file anymore, it is a dataset), it wasn't much…

Well, your title says "BI Answers" and DV is a different product in the end, even if it still relies on the BI Server to get data out. It could depends on many things: what you workbook is based on, how is the dataset defined etc. As DV doesn't have an explicit definition of measures and attributes it is a bit more tricky…

So you would like to have a text column as a measure with an aggregation (because the amount will automatically aggregating assuming it's a measure and not an attribute). If your source is an Oracle Database you can use the LISTAGG function and call it from your analysis by using evaluate and defining all you need there…

Yes, maybe, no: it depends ... Define "merge or combine multiple rows into one row".

Turn all your amounts other than the pre-payment into negative numbers and RSUM will work just fine. PS: as an Oracle employee you should setup your forum profile following the internal rules/policies (appending the "-Oracle" to the screen name etc.)

If your analysis 2 filters based on the results of 1, doesn't it shows only order # 1-5? What you are asking does sound, to me at least, more like a logical / functional dependence than what "based on results of another analysis" is, which is a real WHERE condition in the query. And as any WHERE condition, it limits the…

Well, it probably depends a lot on what and how you are doing exactly. Maybe take a step (or a few) back to get a global view of what you did, what you would like to do and how you could get there. The RPD does work well for more than 10 years, but it's quite "unique" when starting with it... PS: you should also go over…

If the data is the same, why don't you just change your connection pool in the physical layer to point to your ADW instead? If tables have to be renamed, you rename them once (only the "real" physical tables needs to be renamed, aliases will point there). The same for schemas: one rename and job done, any business model…

What is "last viewed dates" supposed to be? Usage Tracking has dates on every single row, select MAX on the date and group by analysis and you get a last executed date. Of course here it's just like for the users: you need to have Usage Tracking enabled for a while before to consider the data as safe to be used. Every…

Keeping it short... no

There is no other way. To be fair there isn't a valid reason to not have usage tracking enabled, so with that disabled you are missing a lot of info about what your environment is used for. If you are really desperate and are ready to have an approximative answer to your question, you could try to go through all the users'…

And, if b), keep in mind that a user can login and not be visible at all in Usage Tracking (sure it's useless, but maybe the user only login to the homepage without firing any query and therefore not being visible in Usage Tracking, and also if it receives a delivery from an agent not ran as the user etc.) And if you want…

We have around 30,000 reports and thousands of users working on them. Is there a way we could migrate the security instead of manually assigning permissions to each report/dashboard which seems to take forever... While I don't know if Argus/Novell had something special, the security in your catalog was already group/user…

Hi, You maybe want to reformulate your post with a minimum of details about what you are talking about. Things like an exact product name and version are a good start. Also keep in mind that the more you invest into writing your thread, the more people will invest in writing a reply. It's a community forum, for and by the…

"Melting" the snowflake is how I call it because it's the easier word I remember. Not sure of the official wording for this step. There are various blog posts around covering this point, maybe try to search for snowflake in the RPD (and because now there is a DB company called Snowflake you will need to filter your results…

The RPD has tons of rules, and hierarchies enforce many of them. Not having any warning or message when not doing hierarchies doesn't mean it will always work as expected, the RPD is just skipping various checks. In the business model you can "reduce" (melt?) snowflakes into a single logical dimension by adding various…