Hi, What debugging and analysis steps have you done for this? Because I can easily imagine you are fully into this issue for some time and therefore everything you posted make sense for you. But from an external point of view, there is just nothing on which to even guess what you are really seeing or doing. What product…

For Option-1, if you plan to only add that column in the presentation layer, nothing forbid you to create a new presentation table and put your column in there. If you didn't mean to say "presentation", you can model it as a degenerate dimension: physically coming from the fact table, but logically in it's own dimension to…

but we were uncertain if that could affect the catalog integrity, if it could be corrupted or with missing things on it. The catalog only recognize objects having a .atr file with the same name. If you don't have a .atr file, the object doesn't exist for the catalog. That's why when deleting content from outside OBIEE, you…

Hi, The catalog in 11g is on disk, you can just delete the content of the folders (I would leave the folder as it doesn't take much space) on disk (by a script or a find + delete at the OS level) and job done (always delete the file and the corresponding .atr, to not confuse the catalog with ghosts).

Valid point Steve, but it's still a change of default that was set for the past 10 years, from the very first OBIEE 12c release. They will not call it a bug, but that's how it feels to anyone who had the product before OAS 8.2 (2025). And this kind of things is quite annoying for an "enterprise" solution. Mostly because…

Confirmed: port 9515 works for online connection with the Model Administration Tool. @Chad Williams , you could raise a SR to report this as a bug. It isn't documented, therefore at least a documentation bug, but I don't see why this port has been changed, because it breaks an in-place upgrade of OAS. Therefore, in my…

Thanks for all these details Chad. I didn't try connecting online so far, and your post made me test: same issue, can't connect. Then I looked into EM for the ports, and … surprise… Apparently obis1 is now listening on 9515 instead of 9514 where it has been for many years. It doesn't seem to be documented, therefore it's…

Hi @Chad Williams, I just tried on my install and, same issue. Do you mind starting a new thread for this? Because it does definitely look like an issue that more than one person will face soon or late…

Absolutely, it's a parallel forum and therefore content can't be moved across the two. Your only option was to post again there. And because that one is the place of the product your data is from, they should have the ability to provide you a valid answer.

Hi, The tables you name sounds like Fusion tables. Even if you use Publisher to report on those tables, Publisher isn't the owner of those tables, they are owned by your Fusion App. Publisher is only the technical solution running the query for you. You should consider posting in the forum covering Fusion applications, as…

Hi, In OAC March 2025 you have a new feature named "Create and save multiple personalized workbook states". Watch the video below for details on what it is. You can't rename anything in the UI that isn't defined by a user. The word "Workbook" is part of the product, because those are workbooks. It's maybe easier to teach…

When looking at the physical query generated with the CASE WHEN formula, you see that it's a very complex query for what should be very simple. The query start doing the right thing, in a very complicated way, then go into analytical functions for summing over partitions and it finally decide to only take the first row for…

The simplest way to find the best syntax, is to use the UI window to make the expression. It looks like parentheses is what makes the composed condition work: a set of ( ) after USING and there inside you define your expression. But use the UI to build it and you get a valid expression to start with.

Some info to get you started with the OAS catalog in the database. Everything is in the BIPLATFORM database schema. The table css_si_files contains the list of files in the catalog (and other things as well), filter by column namespace = 'content:catalog' to have only catalog objects. You can use full_path to have the…

Hi, Not aggregate meaning that it force the granularity to a detail level and will generate many more rows than expected, or how the screenshot show just empty? If it's just empty, what does the generated query look like? Is your condition correct? (is the year a string and not a number?) The query should point you in the…

Hi, I don't remember having seen official documents on how to handle translations in DV. In "classic" (/analytics) it is fully documented as it's something done for more than 10 years. DV is built in a very different way and with little to no customization in mind. You can't change the top-right Oracle logo and product…

Here is where Oracle said there wasn't a need to document the details of the permission sets… The doc only cover the permission set itself: https://docs.oracle.com/en/middleware/bi/analytics-server/security-oas/grant-or-revoke-permissions-assignments.html But, there are WLST commands that allow to work "inside" the…

This is what I meant with looking into the policies linked with DV Content Author. In OAS you still have full access to the permission sets, and you could look into the resources and permissions linked to the application role via the permission set, and try to find something matching your needs (by name and guessing only:…

Pas de soucis Boris, je comprends bien ce que vous essayez de faire :) What version of OAS are you using? (they should be mostly the same, but just to be sure) I didn't look into the DV policies and various privileges recently, I will look at what is in there once I find an OAS around…

Hi Boris, Do you mean the labels on the left of the 3 on-off switches? That's, sadly, poor UI design… How to fix it? Raise a SR reporting the bug: they need to take all their translation and test their windows with the longest labels. Now it looks like it has been developed with English in mind only. Also, that fake popup…