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…

Sorry if that's not what you expect, but shouldn't you be asking those questions to the guys in your company who took the decision? Or maybe to Tableau... OBIEE/OAS and Tableau aren't the same tool (or why would they both exists), and this is the OBIEE forum for people asking about OBIEE/OAS, not Tableau.

To see exactly how the diff is calculated, just look at the physical query generated by your analysis and you will see the exact logic used in SQL. To explain your diff results, it's probably some rounding: either the "Hrs Diff" has a decimal component but you aren't showing it and therefore 4.66 => 5 and 5.16 => 5. Or…

OAC is covered in the Cloud Customer Connect node: https://community.oracle.com/customerconnect/categories/oci-oracle-analytics

While your question is legit and simple to ask, the answer is fairly long and complex... To have an idea of why this is a complex topic, there is a old series of blog posts going into a lot of details, and in this one https://www.rittmanmead.com/blog/2013/03/performance-and-obiee-test-design/ you see why an OBIEE analysis…

What kind of connection isn't working in the Admin tool? You mean your RPD, once deployed on the OBIEE server, doesn't return data when you run analysis? Or you can't view data via the Admin tool when you click on a physical table? I don't remember much about 11.1.1.9 (time for an upgrade maybe?), but the Admin tool for…

Hi, I'm sure it does make sense, for you, sadly it doesn't mean much for us who can't see your screen. Let's start from the beginning if you don't mind. What product (exact name) and version? You maybe want to add a screenshot or something allowing to visualize what you are describing. In case you are using OBIEE (this is…

As extension to what Christian said, 2. isn't even a question. You are changing OS, this means it can't be an in-place migration. If you make sure to install your OAS 5.9 as clean as possible, from there on you could hope to do in-place migrations (except if future releases of OAS massively change all the components they…

You have a dashboard page with a large number of analysis (25), each analysis has to be executed. Depending on what else the system is doing, depending on your settings, depending on what those analysis really do, having a full loading of the page taking 7 minutes at 3pm and 25 minutes at 4pm sounds reasonable. Not because…

What do you expect to print if the page is still loading? Same exact behavior if you try to print only after the page (and the content) fully loaded?

And what does the Node Manager log file says?