If your source column has a time component, in your SQL query do a TRUNC() on it. It will remove the time component and DV will maybe stop doing timezone manipulatons on something not having a time.

Hi, Isn't it a timezone thing? What you see as date is maybe a full date & time field, and DV does apply some timezone offset to translate it into your own timezone. If you were to see the time part of the field, it would be more obvious, but when seeing only the date you maybe see it 1 day later before it did add a bunch…

The navigation passing parameters works well even if you have a CASE WHEN formula or whatever else in the target analysis. Of course the filter should still be on the column itself, even if it isn't part of the selection criteria. The navigation URL is quite simple (also documented in the documentation) ?Go => navigate to…

You have to write the URL with the filter expression yourself because of using 2 different columns. https://datacadamia.com/dat/obiee/obips/url_filter Here you can see the format of passing a filter to an analysis. The receiving analysis can use "is prompted", because it will not see the value comes from a different column…

https://community.oracle.com/tech/apps-infra/discussion/comment/16844645#Comment_16844645 If you do as described above, you get what you are after: you have a LOCATE function, you have basic arithmetic operators, you have the SUBSTRING function. With these you get what you want, it's all about simple logical formulas. Get…

Create an analysis with the filter on the day of the week (there is a function returning that from a date), schedule it with an agent to be executed and delivered on Monday.

If you use the aggregation functions MIN and MAX in the RPD for a column without setting any "scope", they will work across the whole dataset returned by the analysis. This means that a MIN(date) will not be the minimum date for a given job number, it will be across all the rows retrieved. You can use content levels to…

What do you mean? Is a "report" a BI Publisher report or an analysis? What you mean by "generate"? If you add a filter and pick the 3 days of the week, it should do what you need...

Use Catalog Manager in offline mode, it gives you access to the whole catalog without enforcing security, find what you need, move it somewhere else, set different permissions allowing new users to do what they need. Don't start messing around by giving user B permissions on user A personal folder, move the content of A…

If user A is still a valid user, give user B the "act as" privileges to behave as user A: she will be able to act as user A, archive the needed things and unarchive them in a shared folder location.

Hi, You are on a track to get the forum building an analysis matching an Excel spreadsheet something gave you. First of all: no need to write the French version of the question, the community uses English to stay accessible to anyone (and that's why I do reply in English despite speaking French). Second point: what you are…

It's just there on your column "Mode de sollicitation contrat publié", click the total icon and select the position where you want it.

A business model is a star-schema model (it can be multiple stars as well). But it is only a logical representation, it has nothing to do with the physical structure of your data. A physical snowflake you turn it into a star schema by joining together the 2+ tables being the snowflake into the logical table source of one…

Hi, You don't need to create columns, you just need to write the join expressions in your join. The joins should be defined in the physical layer, if you want to create columns to make your joins simple "columnA" = "columnB" then you need to create views of your physical tables either in the database or use SQL queries…

You said you have 3 logical table sources, not 3 logical tables. If you have 3 logical table, each having different LTS pointing to the different physical tables, it's impossible that selecting a logical column from C you get a column of D instead.

Windows 11 is a desktop version of Windows and it isn't certified and not supported for OAS. Use a supported OS and it will work without problems: https://docs.oracle.com/en/middleware/bi/analytics-server/administer-oas/certification-systems.html

Well, if you have a single logical table merging your 3 fact tables, you should either decide if the 3 facts provide data for the same measure or if they all provide different measures. All in all you don't give enough info to know exactly how your model is built, what is the expected behavior etc. Keeping it simple: if it…

If you don't have something making those splits (like a column attribute) you will need to add calculated items defining by hand what should be inside. If your dimension is well defined for the business need, it will be a one-click action of adding totals on that column.

If you look at functions there is one being the day number in the week: by using that you can write a logical expression dealing with what you want.

What is the exact name and version of the product you try to install? What is your OS version?