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?

Seriously, what do you expect with just a screenshot and not a single word about the context? Sure it's a VM, but still it doesn't say anything about the history of that VM. Did it ever work? Did you touch something there inside? What debug process did you follow so far? If Node Manager doesn't work, a good place is to…

You are welcome!

Before to fix "performance", you should find out of there is a performance issue (sometime things are slow because of what you ask, not because of poor performance). Look at the logs and start analysing what the tool does (how long is spent on what, and what actions are performed etc.). OBIEE doesn't have a simple setting…

Hi, You should ask in the forum/category of that product. It maybe does use OBIEE/OAS for some analysis/reports, but it isn't predefined OBIEE/OAS content, because these products are empty out of the box. If yours is a Fusion app, you should probably ask in https://cloudcustomerconnect.oracle.com/

In theory you shouldn't need to convert to text, but making it an attribute yes (you do this at the dataset definition level). Be default in every dataset every number is marked as a measure. You have to change the type of column for all the numbers that aren't measures (like year numbers etc. )

Hi, Just to make sure I understand what you are asking: you would like to have a stacked bar chart instead of your current bar chart? So the "single" bar with a value of 12 should instead be a stacked bar for the 4 values of "knowledge level" and the values 2, 2, 5, 3 for a total of 12?