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?

Assuming you are talking about OBIEE agents, everything is possible because OBIEE has a quite flexible security model. Agents that aren't about personal content should be owned and executed by a "system" account (not an employee that could leave the company). You can then use "act as" and things like that to behave as this…

It depends ... The person leaving the company has no impact on your OBIEE if nothing is done. If the user's account is dropped and the agents are running as that user, they will not run anymore. And if they are delivered to him, not sure that still make sense... Sounds like a good occasion to clean up things and adopt some…

Did you install the latest bundle patch? There has been in the past few reports for variables not refreshing etc. But it was quite some time ago (I believe earlier 12c versions) and the fix was supposed to be in one of the bundle patches. If you are at the latest bundle patch already you should probably raise a SR.

Ok, so that's definitely BI Apps. The concept of "global currency" as far as I know it's also a BI Apps thing as I don't remember having seen something for it in OBIEE (other than setting display options and be able to use a variable to retrieve the correct currency or something like that). Still, the best way to prove…

Hi, So you are on OBIA and not a simple OBIEE? And I'm not fully sure what you are looking for... You say that some reports become slower: are they really BI Publisher reports or is that OBIEE analyses? Could be analyses but always better to be precise with wording... So, are you trying to confirm that what the developers…