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…

If your second picture is the business model diagram, that's by far not a star schema. The business model should contain 1 (or more) "simple" star schemas: 1 logical fact table connected to 1 or many logical dimensions. Your picture shows dims connected to dims etc. Not what the RPD expect at all. In case that picture is…

And in the logs you will also see the content being executed by the various users and you will be able to confirm, based on the generated queries that security is applied.

And for the ODI part: just as OBIEE doesn't care if you use ODI or something else or nothing as ETL, Tableau also isn't going to care. Both tools aren't ETL (ok, OAS/OAC/OAD could become lightweight ETLs, but that's another topic), they need data. How you move your data around isn't their problem.

https://community.oracle.com/tech/apps-infra/discussion/comment/16813715#Comment_16813715 OBIEE is not a visualization tool, OBIEE is an analytical platform. If you trash it and move to Tableau, you should ask the people who decided or Tableau about how you can do the same job. If you trash OBIEE, there is nothing from…