The ideal solution is to have a proper time dimension containing your own business rules for dates, because start and end date of a week is a something which must follow your own rules and is going to be different for other companies. If you want to do that in OBIEE itself you can calculate things by using the date…

You maybe misread what Joel was saying: what does the physical SQL looks like? It must be a valid query as you get something back, but what is it like? Because if the physical query is correct the result can't be wrong (ok, it can if you have selection steps or other things happening at the BI Server level, but you didn't…

The 10g piece of code was hand-made by somebody who shared it. For 11g somebody did it for sure, but they didn't share it (or maybe they did, no idea where).

And if you change the aggregation to count distinct in the front-end? Or create a new calculated column in the analysis?

Set your measure as a COUNT DISTINCT aggregation in the RPD and job done, no? Even if you display it multiple times because that's the reality (the same number exist in multiple dates or weeks), the totals for higher levels will do a count distinct and will work just well.

It has been asked and it has been answered, at least 4-5 times (these are those I answered myself :P ). Just like you found, there isn't something out of the box for that. You have to write you own piece of CSS & JS for that. A hand-made piece of code you have to write and maintain for your needs.

Use a narrative view to display a column of your analysis in which you have the logic. Or the same narrative to have a piece of javascript to display or hide a static piece of text. There are many ways to get there....

Do you mind writing all the pieces you forgot in your thread? Like product names, context and what you try to do? "Oracle 11" isn't really a product as Oracle has about 100+ products which have a version 11...

As Christian said I was staying away of this because OBIEE in French just doesn't work (not technically): all the messages and errors have little to no meaning in French as things have been translated fairly random (and I do speak French fluently!). That error is a fairly common one, mainly when adding a new LTS and…

It's simple logic, if you don't store the right format in your database, you just have to build it by yourself. So with some basic logic you could multiply YEAR(date) by 100 and you sum it with MONTH(date) and you can finally turn the resulting number into a char if that's the format you are after.

If you look at the available functions in OBIEE there is a whole set about dates, including extracting components from a date. Just look in the UI and you will see the list of functions available.

In the RPD you should set the sort order column for your text month logical column. Pick a column which can be sorted correctly for months (like the month number or something like that) and use that one as sort column for the text versions of months.

I used "LIKE pattern" in prompts and created a presentation variable and used this as a filter with the same "LIKE Pattern" criteria in the filter.It is not working. And why it isn't working? What does the generated SQL query looks like? What should be different in that query to make it work? You are maybe just 1 step away…

Keeping in mind the known differences between OAC and OAS/OBIEE, it should work. Of course being all custom content/code, you have to try it to discover if you used something which is known to not be supported in OAC.

Hi, With a SQL filter you can write the filter condition you want.

Wrong category and you double posted in the correct one (https://community.oracle.com/tech/apps-infra/discussion/4482433/odi-12-2-1-4-problem-in-connect-with-odi-agent#latest). So you can close this one and let people of the ODI category use your other thread.

Turn it into a join of your table with the mapping manager-city to the cities dimension, in that way you can set the security on the manager column and the join between the 2 tables will automatically filter the cities even if they are millions.

Doesn't the documentation says to use 7-zip? Did you try with that? Did you check the the checksum of the 5 files, are they correct?

Conditional formatting is a row-level thing. Your logic is across multiple rows. You are back to the previous thread trying to "align" different rows.

How? That exact behaviour you describe will take you some HTML and JS and some time writing the required pieces of logic.