Our Client querying for almost 12 years Date range, that was around 470 columns. Delete that analysis fully and nobody will see it's missing. Because who is actually able to analyse data in a pivot with with 470 columns? Nobody! And for data extraction you should advise your client there are better tools than export an…

Hi, It's actually a lot simpler than what said above (so forget all the previous replies)... You can't alias your ROW_NUMBER() ... as rownum , because rownum is a reserved word for columns name:…

Hi @User_DCJG6 , While the concept of customization is still the same, and depending on what your custom style was like it just works without changes between 12c and OAS, there can be changes in the pages structures making your custom style CSS selectors miss the target. As Federico said, use the browser develop tool to…

Where did you add that line? Because it comes with a ' , ' at the end, but you should add one at the beginning if you are adding it right before the FROM. You just have a syntax error in your query, look careful at your list of columns and fix the wrong ' , '.

Taking a step back before jumping from previous replies... How is your environment customized? Is it a custom style/skin that you migrated from 12c to OAS? What OAS version? Is your custom style/skin a full one or one based on another one? And in that case, what style is it based on? Well ... tell us more about how you did…

It looks like you didn't pick the "best" approach at designing the dashboard for the target it has, and this is what Federico is pointing at with his suggestion of making it a single page with "smart" logic in each acting differently based on the user opening it. Alternatively, if you set security on your pages to only…

we are migrating their reports from 12c to OAC, The error report has only 30k records and it is working fine in 12c. Working fine in OBIEE 12c doesn't mean anything: in OBIEE you have full control on config files, allowing you to remove any limit on number of rows, columns, cells. OAC is a "black box" for configuration:…

Jean-Pierre, I would raise an SR reporting a bug. You are using a feature that other users will probably use, and this lead to a suboptimal (to say the least) query generation. It can be an issue with the database features, but if you didn't change the defaults, it should already work at the best with the default…

You are playing with something that doesn't sound like "supported" officially (OAS did reduce massively the list of certified authenticators and authentication sources). The lightweight SSO login deployment is just meant to be a simple login form and nothing else. You work for Oracle, you should consider taking this…

What is your webservice call supposed to do? Is that your login/authentication mechanism? As far as I know, in OAS the lightweight SSL must not be touched. It is required, it must be there the way it is and should not be turned off. Maybe you can do what you need with your web service somewhere else? Or get the same result…

You aren't trying to embed content in OAS, you are customizing the lightweight SSL login page. Don't confuse that with OAS ("classic", aka /analytics, or DV). It is an independent deployment that isn't affected by anything that is documented on how to customize OAS. I'm not even sure if customizing that WAR is officially…

Hi @ScottHillier , I don't know if the forum "push" you to accept or reject every reply you get in a post. But even if it does, the focus should be on the "accept" of the valid answer (when it does exist) more than rejecting everything else (it gives a kind of negative feeling, even if all you wanted to mark is that it…

Moved to the OTBI category.

The login page of the lightweight SSO is not part of the DV deployment and it is also not part of the "classic" deployment. The CSP settings you defined in 3. and 4. only applies there inside. You should look at the WebLogic level what kind of settings exists to manage CSP. It could be something to be configured inside the…

@Jean-Pierre Hoedenaeken , In the picture you posted at the beginning, is that the LSQL for something where you selected to see only the "last 3 days" ? Because to me, if the 2023-11-22 you select last 3 days I would expect a filter being "date" > 2023-11-19 (19 being 3 days before 22) and not that kind of filter. Because…

I would use the same user, because it is in-place, existing folders/files will be reused. By using the same user you avoid any permission issue that you will probably have with a different OS account. It's anyway meant to be a technical account used for OAS, it does make sense to use it for all your OAS products (which…

Hi, What product (full name and version) are you asking about?

The question has been moved to the right category, no need to post it again.

Please avoid double posting.

+1 What Rajesh said: there just isn't valid reasons to still be on OBIEE 12.2.1.2 ... If your question is about what linux versions are certified with 12.2.1.2, the easiest is to look at the certification matrix: https://www.oracle.com/middleware/technologies/fusion-certification.html Look for the matrix of Fusion…