What data type is your "dimension"."START_DATE" column? Because the LIKE %...% syntax only works on strings, if it's a real date you can't just expect it will work with some magic conversion from date/time to text.

Also worth knowing that DV has its own CSP apparently, if you go in DV, Console, Safe Domains you can add domains to set in CSP directive, and the "Embedding" checkbox is the one for frame-ancestors .

How to change the frame-ancestors for the bi-security-login deployment? No idea, if it isn't a checkbox somewhere in WebLogic but it requires to change a file in the WAR archive (like web.xml or anything else), you would be outside of the supported scope I believe. I imagine this problem doesn't happen when you have a full…

I did just try in a new OAS 6.4, without '<InIFrameRenderingMode>allow</InIFrameRenderingMode>' by default it is: frame-ancestors 'self'. Without '<InIFrameRenderingMode>allow</InIFrameRenderingMode>' and with a CSP directive: frame-ancestors 'self' https://mywebsite.com . With…

Ok, so in OAS there is a setting (in instanceconfig.xml) named "InIFrameRenderingMode" (<ServerInstance><Security><InIFrameRenderingMode>): As you can see you will need to set this one to "allow" and then you also have a reference telling you that you also need to set the CSP settings. As you can see they say that you…

My desired goal is to allow my "HomePage" to render the OAS dashboard inside Microsoft Edge (Chromium-based) in an iFrame What is inside what? You want your personal/corporate website ("HomePage") to display OAS inside an iframe or do you want external content to be displayed in an iframe in an OAS dashboard? It's a bit…

4.3.2 The maximum number of concurrent server connections has exceeded a per-source limit, closing transmission channel This is not an OBIEE/OAS error message, the issue is not here, you are looking in the wrong place.... This is a mail server error message. You should speak to your mail server administrators giving them…

Hi, Could you please maybe start with the exact product name and version? What you describe doesn't really sound like OBIEE/OA...

The Sample App VM has been removed because being too old and using a version of OBIEE not supported anymore.

You mean if you can have your Apache HTTP Server answering to a domain name that is different than the hostname as the proxy? Sure, that's actually the situation I had at my customer: the hostnames are different than URLs used for the OAS SSO.

The documentation is very detailed and provides 2 MOS documents about how to have a Kerberos SSO in OAS. Keeping it simple: Kerberos SSO is managed outside OAS in Apache HTTP Server that acts as proxy in front of OAS. It does work well and fairly simple to setup (either with an interactive wizard or by adapting a sample…

As far as I know BVT is dead, no current plans to bring it back (because it would have been pretty simple to adapt it for the current OAC authentication system etc.). Your alternative solutions are doing by hand what BVT does, you can script it but it's up to you to decide what is worth the effort: a basic solution for…

Nope, it has been fully removed because the products it was developed for are not supported anymore (the versions to be precise). BVT can't work on OAS, and BVT is also protected by a patent owned by Oracle, and that's why there is also no chance to get its code or build the same tool.

Hi, You should look for any gap in your data and also at how you "use only the 'mm/dd' part" of your date. If your data provide a contiguous set for all the days of the year, the chart will plot a proper line, if there is a granularity issue or gaps, the line can break or be just dots. Ignore the chart and focus on your…

Hi, In the RPD you make a single logical fact table, having 2 logical table sources pointing to Fact_1 and Fact_2 and you define the fragmentation rules to tells OBIEE what LTS does contains what data. The tool will do the job by queries one, the other or both depending on the fragmentation rules you set and the analysis…

I have the impression you are using a tool that isn't fully OA/OBIEE but some pre-built content, something that you maybe can't change. Because changing the column property to display 3 decimals it's 3 clicks and job done. If you aren't allowed to edit the analysis and change that because it's some pre-built content, you…

Hi, While not knowing the exact case (OA/OBIEE doesn't have any content out of the box), is it a "visual rounding" (the measure is set to 2 decimals vs 3 or is it rounded at the query level? Did you try changing the column properties to 3 decimals?

Hi, The BETWEEN comparison has the following syntax: xxx BETWEEN value1 AND value 2 Write your CASE WHEN with this syntax and you should be getting there. If your presentation column is a real date, you should also compare it to dates and not strings.

There are a few ... You aren't referencing any column, because a presentation column should at least have the format "presentation table"."presentation column". You are comparing to AP and SS: you must define them as static strings with quotes. Same apply to your Travaux de construction, that should be a static string with…

Sure you can, but it's something that has good chances to give you issues in the future, when everybody forgot it was there. Your fiscal year is a basic information that should be part of your time dimension as Christian said. If you still want to use formulas, in OBIEE you have functions to give you the current date, the…