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?

https://community.oracle.com/tech/apps-infra/discussion/4503497/recover-deleted-folder-in-catalog-obiee-12-2-1-4 Short answer: no Longer answer: how should you be able to recover something deleted without using a backup? You would need the "thing" (in this case it's the OBIEE catalog) to have a kind of trash folder just…

You can't, HTML doesn't have conditional logic, it isn't a scripting language. You either have to find another way, or use JS for the job.

And did you enter the same exact password? Because there aren't 10 different password: you set it with the download command and that's it. Nothing else influence that password...

How did you try to open it? And are you having the right versions of all the tools? If you are in offline mode I don't really see why there is even a logon attempt...

If you use that expression to populate the options in a prompt, aren't you overdoing it? Just write the 2 static values in the prompt, don't disturb the server by running an expensive query (because it needs to go down to a data source and do some cooking) to have 2 values back, mainly if you are asking yourself why don't…

https://community.oracle.com/tech/apps-infra/discussion/comment/16846497#Comment_16846497 Sure, go in the OAC forum, in the idea space, https://community.oracle.com/customerconnect/categories/idealab-oracle-analytics-cloud-and-server , and open an idea asking for an equivalent of "act as". The functionality is flagged as…

And not only it's called "Act As", but what you try to do will just not work. Don't try to hack the security implementation of your OBIEE/OAS. There are other ways to "see what the user has access to", well documented and officially supported like Act As, or simply by being in control of your security model. You are…

And my reply will still be the same... You can decide to ignore 95% of what the product is by using a DDR, but at some point you either follow the product rules or just don't use the product.

If you compare '<' or '>' to IS NOT NULL : what is the operator and what is the value? '<' or '>' == IS [NOT] , value == NULL (it isn't exactly that because IS [NOT] NULL is an unary operator, but it gives you an idea of the behavior of your variable and the default value). Your variable is replaced in the query, what does…

How do you imagine this to work? OBIEE isn't a database or a data warehouse able to independently store data forever. Kafka is all about streams: when a consumer read data, the data is read live and gone. So what kind of behavior would you expect? What should OBIEE do exactly? Keeping it simple: OBIEE has a long list of…

https://community.oracle.com/tech/apps-infra/discussion/4502786/could-you-please-tell-me-the-steps-of-obiee-12c-catalog-delpoyment-process You have a backup procedure and not a restore one? There isn't such a thing as a catalog deployment process because it all depends on how you do your backup in the first place: a unique…

How to solve the error? Uninstall everything and restart on a supported OS: https://docs.oracle.com/en/middleware/bi/analytics-server/administer-oas/certification-systems.html The list has a good number of options, but a desktop OS isn't certified for an enterprise server application. If you use a supported OS it just…

Setting the agent to run as a specified (static) user doesn't mean adding new recipients (more than one). And when you do that, it isn't you who needs to be able to find in the catalog the content delivered by the agent, but that user you specified. When you set an agent to run as a specified user, the tool will create a…