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…

The question has already been asked various times over the last years, the answer never really changed. The recipients of an agent are stored inside the agent itself. So there you go, you can do whatever you need to do with it. PS: in the future when you have a question you should create it as such and not as a discussion…

Hi, Oracle Analytics Server or OBIEE isn't certified for Windows 10, it isn't supposed to work (many spent hours if not days to finally have to accept reality). Install Virtualbox and setup a VM with a supported OS for the product you want to install. A linux VM will be smaller.

What you call "Extra header" is the presentation table name, rename it for all your column (in the analysis) and it's supposed to merge automatically. You then can align it the way you want.

Keeping it short: you can migrate content across versions and a change of OS, it does work. Just don't expect anything to work directly with 2 clicks and no manual intervention: that is the idealistic case and only work with sample content (= no content more or less). In a real situation there is always something requiring…

https://community.oracle.com/tech/apps-infra/discussion/comment/16837236#Comment_16837236 Are you asking us about your migration process? Because you are the one who decided on the process and the steps for the job, not us. You can't use the the existing RCU schemas because you have mismatching versions.

https://docs.oracle.com/middleware/12212/biee/BIEMG/GUID-F1204007-2846-425D-8BF1-A05CF153CA7B.htm#BIEMG3104

Set a repository variable containing your fiscal year, and then populate the variable with the correct logic for the need ("your" fiscal year follows your own rules, you should have a business logic defining how the fiscal year is defined, so implement that in a piece of SQL). In your formula use the variable and done.

I would first setup the authenticators and the whole security realm before to import the BAR, because if you import the security model of the BAR it will map groups to approles, and if your groups do not exist it will maybe not like it much. Also another thing to do anyway, because it's jump between 4 versions from your .0…

Go into the logs and find the real reasons for the very generic error you see on screen. Logs tells you everything...

What's the point of randomly trying things in a product without first understand how it works? OAS is not OBIEE 10g or 11g The linked thread doesn't apply: you are on OAS, that thread was probably OBIEE 11g. So many things changed about how the RPD is used, manipulated and persisted. You don't have to take my reply as…

At the best you can move the SDD, and that's documented: https://docs.oracle.com/en/middleware/bi/analytics-server/administer-oas/change-singleton-data-directory-sdd.html The linked thread doesn't apply: you are on OAS, that thread was probably OBIEE 11g. So many things changed about how the RPD is used, manipulated and…

Kind of ... You can create an analysis that only check the value of one or multiple prompts. Ages ago I did write about this, it wasn't exactly your use case, but all the logic is still valid and easily adapted to your needs: https://www.rittmanmead.com/blog/2014/03/obiee-dashboard-prompt-at-least-one-mandatory/ The idea…