Aren't you having a "modelling" issue? Your reason for concatenating things in the prompt seems to be "the user has a clue of what they are picking up": why is it like that? Can't you use the "Descriptor ID column" in your RPD? So that the human-readable column has the "technical" 2 characters column set as descriptor ID…

LEFT isn't applied to every single elements of the variable (if multiple values) before to add ' ' and add them as options in the IN but it is applied to the final string itself, which means you are breaking it. To use it with LEFT you must make your variable single value only and change your IN into a = .

As Christian said, you are just looking to install a very old tool on a recent OS. Why don't you also update OBIEE at the same time as your OS? If your IT asked to update to a newer OS, there is no reason the same doesn't apply to OBIEE. RHEL 7 and 8 didn't exist when OBIEE 11.1.1.7 has been released (it was April 2013,…

3516041 wrote:But in one of my dashboard my query is getting different. Any idea why it is behaving like this. Yes, the idea is quite simple: 11.1.1.7 vs 11.1.1.9 11.1.1.9 changed various things compared to 11.1.1.7, therefore the queries can also be generated in a different way. It's part of the activities of an upgrade…

"out-of-place" means that you aren't going to upgrade the domain you have already, but that your OAS is a fully independent install and you move content there and you have to redo yourself the security config in weblogic and those things. As you anyway will have to do that even if you move to 12.2.1.4 first before to be…

mchorazy wrote:But can I migrate directly form 11.1.1.9 to OAS? Yes, from the last 11.1.1.9 you can do an out-of-place upgrade. Seeing where you are coming from (11.1.1.5) there isn't really one being better than another: you will probably have a lot to clean-up and fix because you come from quite far away.

Hi, OTBI isn't OBIEE (OBIEE has ODBC and web services for that). You must ask in the OTBI forum in https://cloudcustomerconnect.oracle.com/pages/home .

There is a WSDL describing all the "classic" analysis (Answers). There is a service for Publisher as well but it's maybe more to execute existing reports (didn't look at it for some years). AFAIK there isn't a proper web service for DV (the new name of VA). There are REST APIs in DV but most of them aren't public and…

If instead of concatenating 'a, b, c' you concatenate '<a href="...">a</a>, <a href="...">b</a>, <a href="...">c</a>' you still get a string as value. The difference is that this string is an HTML string and you can kindly ask OBIEE to shows it as HTML instead of just a string. The HTML contained in your string will turn…

Does your source really store "a, b, c" , "f, g", "10; 20", "40; 50; 10" as values? (so a single string) "a, b, c" doesn't mean Product ID "a", Product ID "b", Product ID "c", it means a string "a, b, c". If somebody somewhere is making up those strings (and I'm quite sure they are: somebody discovered the power of LISTAGG…

Hi, 3999508 wrote:I tried with the below filter but its showing error.(DESCRIPTOR_IDOF("Sales - CRM Opportunities and Products Real Time"."Business Unit"."Business Unit Name")) <> (DESCRIPTOR_IDOF("Sales - CRM Opportunities and Products Real Time"."Opportunity Extension"."Extension Attribute LOV 005")) Do you mind posting…

If I understand you correctly, you are saying that you granted to your users that privilege but the button isn't visible? And that if your user is an admin he does see the the icon? If it's the case, it would be against the solution of Doc ID 1488865.1 which is still supposed to apply to 12.2.1.4, and you will have to go…

OBIEE doesn't speak SQL but LSQL. Every place letting you enter a formula as selectors to show you what formulas exists. The forum doesn't let me upload a picture right now (something must be wrong). If you look into String function you find one called "Position", have a look.

Raa.BI wrote:... facing issue to convert To_date function was there any different syntax I have use in OBI. In your first post you used TO_DATETIME, so you probably have to use that function as OBIEE doesn't have a TO_DATE function.

Raa.BI wrote:We have to convert these data in MM\DD\YYYY format in RPD, issue we are facing is You don't want that, at the best this is a workaround waiting the fix to be done where it has to be done: database. In the RPD it means the formula will be applied on every single row of your queries, no need to look any further…

2711084 wrote:if i pull "$ sales" column from the fact table, then i should see sales amount of only current month. This is something you generally want to do with filtering or you are going to have many side effects you don't really want. "current month" doesn't exist, it has no meaning, OBIEE doesn't know what your…

Hi, Sorry to ask but .... what is a page? What do you mean? An email doesn't have pages, so I struggle to understand what the problem is ...

User294199 wrote:so at year level there isn't difference between Quantità and Quantità YTD? You still didn't show us what the formula of "Quantità YTD" is like, so I can only answer based on the meaning of 'year to date': a year to date figure at the year level is the same as the sum of the 12 months of the year, therefore…

The 288.950.856 you look for is January * 12 + February * 11 + March * 10 + ... + December * 1 This isn't the definition of YTD and it also make little (if not no) sense.

What OBIEE return is correct, that's the meaning of YTD. You posted many things but not the formula of your "Quantità YTD" column, what is this one like? I guess it uses TODATE(<your measure>, <the year level>). YTD is simply the sum of all the months from the beginning of the year level till the present month. If you…