@mayank_tripathi I'm not able to open the link in the comment, it says bad request. Delete your cookies for support.oracle.com, or use a different browser, and try again. It's a known issue with a cookie that keep growing every time you visit Oracle websites, but some of them do not accept it anymore when it's too big…

@Vijay Kumar Kotagoda , the HTTP-400 error when visiting MOS (and some other Oracle sites) is because of your cookies. Delete the cookies for that domain (or use a different browser) and the page will work. Oracle is working on a fix for that (there is a cookie that keeps growing when visiting any Oracle site, and some of…

Yes, there are things happening behind the scene at some point when you change those settings (almost anything in that screen). In the past it was just saving the new state and then there was a “restart” button appearing on screen to restart the required components (BI Presentation service mostly, sometime the BI Server).…

It isn't as binary as you say… An "ORDER BY" in the query, is respected, at least in a table view. I just did a quick test in OAS 2024 to validate this: Without the ORDER BY, the months wouldn't be in chronological order but in A-Z order. And as you can see the "calendar_month_number" used to sort the query isn't even part…

This is a 2 years old discussion migrated from a different forum that was abandoned by OP. If there are question on a similar, related, topic please post a new question (with all the required details like product name and version etc.).

The MOS document I was thinking at is this: LDAP Integration Using Active Directory Only Lists Few Users in WLS and EM Console (Doc ID 2531914.1) It is for WebLogic 12.2.1.3, which is exactly the WebLogic you are running with OBIEE 12.2.1.4 if you didn't reinstall it freshly recently when OBIEE 12.2.1.4 supported WebLogic…

Ok, so you need to see the users to add them to an approle or things like that. In MOS there is document saying that by default AD only return 1000 users, and that WebLogic doesn't make paginated requests and therefore there is a setting to tell AD to return more users per request. Did you try that? The fact you see your…

Hi, Are you able to quantify a bit more precisely the issue? You see more than 1000, but how many is that? (If you see 1050 users it is different than seeing 15000) How many are missing? Are they always the same users missing? Can those users connect to your OBIEE or not? And also, is that an issue? Not seeing AD users in…

Do you have extended support for Oracle Linux? If not, why did you chose 7.9? Basic support will end in 3 months. You should really consider OL 8 if you don't have a real strong reason for 7.9.

Great to hear it's back to working as expected @PeteSiekierski ! To be fair, it's maybe not your fault at all… It happened to me a few times in the past that changes in the Semantic Model did save, but when I clicked to deploy it, despite a confirmation it was done, I never saw the changes when building an analysis. Even…

If the model is really as simple as described, the default behavior without setting anything should already be enough. No need for dimension based aggregation: you have a single dimension, and even if you had more, they all use the same aggregation. Another thing to maybe check is the content level: your Dim - Supplier is…

In what piece of the product? And, why? Excel has it, but you don't need it: do a count and take the TOP1 of the count measure, job done. If you want to suggest that as an improvement, go to and post an idea (that's where ideas for new features or improvements are collected).

Yes, that's the plan. Creating Skyros as a full style/skin, with all it's files, and deploy it as a custom style. Because it doesn't exist anymore in 7.6, you will not really have issues (duplicate name etc.). And from 7.4 to 7.6, I don't think you will need to adjust anything: it will just work fine. I'm not fully sure of…

You would probably have more chances by building a full custom style/skin, and not mixing up things in the CSS. As Federico mentioned, most styles/skins work by inheritance: there is a base one on top of which some customization are deployed. If you want Skyros, then you should create a full skin/style for Skyros by coping…

Well, dropping is maybe "extreme" (ok, you said you cloned the database, therefore somewhere else you will still have the real 12c schemas). Can't you just use a different prefix? And yes, when picking a prefix keep in mind what you just said: future upgrades in-place mean the schemas will stay, therefore don't add the…

I'm maybe missing something, but it sounds like you are doing a out-of-place upgrade while trying to perform an in-place upgrade. It's one or the other. You are moving to a new server, therefore forget in-place upgrade. Your 12c schemas will not be upgraded, you can't upgrade them, they don't belong to a product being…

You should not set dimensioned based aggregation when not trying to have different aggregation rules by dimension (like SUM for any dimension but LAST for time dimensions etc.). By default the aggregation rule of the measure is used. The semantic model works just like the RPD and the same rules as OAS and OBIEE do apply…

Hi, Are you sure your semantic model is fully correct? Because by default, when having hierarchies, all the measures are aggregated all the time. As the picture posted below, you can see that enabling the "Grand Total" is even pointless because by default the measures aggregate all the time and therefore on the "Total…

@Antariksh Kar-Oracle , that's great, but it's better to not resurrect 7+ years old posts that have been migrated across a few forums. If a question is old (2 years or more), let's leave it where it is, how it is… If somebody has the same question they better post a new one, so they can also provide all the details…

Double post: