You can't see any filter section because it's a DDR: you wrote a SQL query, you want to filter it? Add a WHERE condition to your query. You can reference existing variables with the usual OBIEE/OAS syntax, for example @{variable_name} .

Aggregation are an attribute of a logical column. If you create the 2 with their needed aggregation and then create a 3rd logical column being derived from the first two (something like col1 + col2) ? A derived logical column doesn't have a physical mapping, it has a formula based on other logical columns, therefore it…

You have Windows 10 Pro: why don't you use WSL for these things? It will at least be on a certified OS while still being "local". Oracle even released Oracle Linux 7 and 8 in the Windows Store, all you have to do is do your installs.

What did you try so far? Because if you tried, you definitely had it right after few attempts... LOCATE tells you where the ',' is in your string, then you need to take what is on the left and on the right. For the XXX part, if you use LEFT() it's easier, because you can use the result of LOCATE() -1 to get the number of…

By the way, you were asking for BI Publisher in a MOSC forum, and now you posted this in a public forum with content of a MOS document: it's borderline with the rules, MOS documents content can't be posted in the public forum (because MOS documents are a resource you need to pay support to have access). If you have…

The syntax you posted isn't for BI Publisher but for an analysis in OBIEE. When you create an analysis you have various kind of visualizations (table, pivot, bar chart, pie chart etc.), one is called "narrative" and support the syntax you posted. It's a way to generate content with the result of the query of the analysis.…

Isn't there a TRIM function? Or maybe it's still split between left and right trim. Just find where the space come from (is it because of the year, the month or an implicit conversion from numbers to chars?).

You already found what is the reason: your 2 users have different roles. Take that role and explore what permissions & privileges it has. Some permissions are stronger than other, so having an additional role can explain that the user sees less things.

Was the date column you used with a display mask of YYYY-MM of a lower granularity than your Year or Month column? Because a display mask doesn't change the real value of a column: if it was at the day granularity, you probably have multiple days in your dataset for every year and month, and despite displaying only YYYY-MM…

Why the physical query is different than the logical one? Because that's what you paid for when you bought the tool. I know this answer is not something you will like... OBIEE does generate queries for you, as you see you don't write physical SQL anywhere. You model things, you write logical queries (you did it clicking…

The connection isn't technically impacted, but what makes your OBIEE work is what makes almost any existing online resource not work: if you try to act like being 5 years ago, most sites or resources using SSL will have certificates that aren't valid (because too recent). You can turn on the date/time synchronization with…

If "grant total" is the automated totals you enable at the view level, the aggregation works in a single way for all the rows. If you use something like Essbase where you defined your accounts dimension, you can set aggregation rules for every account at any level of the hierarchy. If you don't have that kind of source,…

Ah, got it now. So your logic is something like: for a report run today you want to have the date of Friday of this week and the date for Friday a week ago. What happen if you run the report on a Tuesday? Do you still get the date of this week's Friday (so a date in the future)? Or do you want the date of the last 2…

https://community.oracle.com/tech/apps-infra/discussion/comment/16824476#Comment_16824476 Schema of what? OBIEE doesn't have any data, doesn't have any schema. If you expect a proper reply you should invest more than 10 seconds in asking the question. Put words to define what product you talk about, what version and what…

Reply to this thread, don't open a new one. If you "run your report" on January 7 you expect the "last two week" to be January 25 and February 7? What kind of calendar is that? How come that end of January and beginning of February are the "last two week data" for January 7?

Hi, Honestly I don't understand much of what you are asking... Mainly because today is mainly Feb 3 still (except for Australia and some places there around), still I don't know where the Friday jump into your logic. The rest of your example is about end of February date that should be between Jan 21 and Jan 28). Maybe you…

Hi, you maybe don't know that questions get more attention when some effort is provided in asking them. Remember that nobody else can see your screen or know what you are thinking, trying to do and what you are working with. What you don't describe is unknown, and when there is too much unknown no reply is posted. On a…

Because it is in a dashboard prompt, what behavior do you expect? Your prompt could have various visual appearances but in the end only 2 possible values: why to write a query that will perform an operation to only return a long list of only 2 possible values? Not even going into the logic of the query, what you are trying…

Also a last note on something you posted earlier: I used to apply skin same way in On-Prem OBIEE application same version but never got into such issue. The fact you are now installing OBIEE 12.2.1.4 on a compute instance in OCI doesn't change anything compared to an install on a server in the basement of your company, or…

The way you deploy your custom style & skin isn't supported. Never ever touch analytics.ear, there is nothing there for you. Just the fact that at every bundle patch your customization is gone is a hint that it shouldn't be done there. The documentation cover how to customize a style & skin with a EAR file. A template EAR…