While Christian is right and the answer is "yes", you are maybe overthinking what you need. Because keeping it simple: why a same "report" (do you mean analysis? dashboard page?) would be sources from different places based on a role? Wouldn't that be more 2 different analysis and so the need would be covered by showing…

Hi employee, Thanks for letting us know that. Do you also have a question? If yes, you maybe should consider providing a context, a full product name and version and the question itself. Keep in mind nobody else than you see your screen or know what you did.

You need to carefully evaluate who "Authenticated User" is, because having this as member of BI Consumer could give you a serious licensing issue. Authenticated User is anyone with a valid username and password, if you connected to your enterprise AD or LDAP, this can be many more people than the number of licenses you own…

Where are you writing that query in OBIEE? The error message (probably ORA-00909: invalid number of arguments ) is your database telling you that you are passing too many arguments to LOWER, the function only take one single parameter, not a list of values.

"Microsoft Windows x64" and what version? Because that's actually what can easily explain the issue...

Double post, please avoid doing it, it's pointless and gets you even less replies. https://community.oracle.com/tech/apps-infra/discussion/4504457/unable-to-execute-start-config-exe-in-obiee-12c-installation#latest

What exact version of OBIEE 12c? What OS are you installing on? By the way: double posting is against the rules of the forum, avoid doing it... https://community.oracle.com/tech/apps-infra/discussion/4504455/unable-to-start-obiee-12c-configuration-due-to-config-exe#latest

Just a quick check: if you connect as one of your PCCD users and go on "my account" (top-right icon) and check what application roles you have, what do you see? Inheritance can be a sneaky thing and keep jumping in messing what you have in mind, mainly when you try to add security on top of an existing situation little by…

Not something the tool does (out of the box). DV in the new OAS gives you much more flexibility for these things, but then if you want to export these things, you can't expect much...

Of course! Take your last backup and restore the piece you need.

OBIEE doesn't need to accept large files, because OBIEE is the sender. You need to ask your company mail server administrator the details for your SMTP server. If your company SMTP accept large files as you say, the emails will just be sent (or you will have a different kind of error). The thing is that if you have SMTP…

You say you checked Outlook (and that for me is just a mail client, not a mail server), but your SMTP is configured to me localhost (and I doubt you did call your server "Outlook"). SMTP servers don't generally send big files by default, and "5.3.4 Error: message file too big" is a SMTP error message, OBIEE just received…

How can you have OAC locally knowing that OAC is Oracle Analytics Cloud, a cloud-only product not existing anywhere else than on the cloud and as a managed service with no access to the OS where it is installed, that is anyway a linux OS? Assuming you are using OAS at the best, it looks like you installed on your own…

In the BMM both Dim A and Dim B has multiple tables under LTS. Now i navigated to the two physical tables and created a join between one of the source table of Dim A and a source table of Dim B. Are you sure that this new join isn't going to generate different queries with wrong results for existing analysis? The way you…

You are taking the problem from the wrong side... Think about the meaning of the data inside Dim A and Dim B : how can a value of Dim A share the same row as a value of Dim B if there is no connection between the 2? If you had to write a SQL query by hand, what would it be like? And again, if your answer is that you can't…

You said it yourself: Dim A is not connected in any way to Dim B, not even indirectly via a Fact table. By selecting a column from Dim A and Dim B in the same analysis: how is the tool supposed to build a query for the 2 tables if they don't have any form of connection? If Dim A and Dim B can't have any kind of connection,…

Technically usage tracking isn't enough for what you ask: what if the user never logged in the system at all? The user will not exist in the usage tracking table. To get where you want with the usage tracking table you need a filter that isn't about selecting users but about excluding them. The easier will be to use an…

Remembering that I can only add OBIEE application roles to the folders. And why is it like that? OBIEE does allow a lot of freedom on the security model you want to use. Application roles can represent a functional access, a content access or a mix of both. It just depends on the security model you decide to implement...…

Did you look at the documentation? All these things are written in there...

Did it ever work? Does it work when added to a dashboard page (where it maybe already is) or when navigated to (as it maybe it is used)? Aren't you just lacking default filters when opening it from the catalog vs. the real usage of the analysis that always filter things based on some values?