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…

I would say you can't customize that, mainly because it's managed by the system. The Error code is generated by OBIEE and has a meaning, you aren't supposed to need to edit that at all. The error message without the details is anyway quite explicit.

Hi, What does "customize" mean for you? Changing the look of the message? Changing the message on screen?

Hi, If double posting was against the forum's rules, you can imagine that triple posting isn't any better ... If you plan to post the same thread daily, please stop.

Double posting is against the forum's rules: Close one and keep the other open.

Could you please avoid double posting? Close one of the 2 at least, to avoid people losing time answering the same thing. 3612780 wrote:Can anybody advise how can I export "<" symbol from obiee 12c report to excel asap. If you need something "ASAP" open an SR or hire a consultant. People invest their own free time in…

In the physical layer the data type is the type you get, if it's a string it must be VARCHAR. If you don't define it as a VARCHAR you can't use string functions on it. Just keep in mind this is a workaround: you will pay the price for it every time you use that column. The solution is to have the database giving you the…

It is working as expected, you are just seeing a problem where there isn't one. 3913018 wrote:....changes has to be done in RPD. You asked to turn a string into a date in the RPD, once you do that the column is of type date or timestamp. The visualization of a column of type date or timestamp has to be configured in the…

You must keep in mind that the fully qualified name of objects aren't just the name you see. Your "address_d" isn't really named "address_d" but depends on what other object it is child of etc. That's why it's possible to safely merge 2 RPD which would have different business models and different subject areas and…

You can do a SUBSTRING to get the date part out of that string, and on top of that you use TO_DATETIME to convert it to a date. TO_DATETIME("Time"."Calendar Date",'yyyy/mm/dd mm:ss') And in the same time raise a request to have a proper date in the database, because that will perform poorly as you can imagine (executing…

You are correct that you can open both files locally, but as you say you opened them "offline", for that all you need is the file itself. OBIEE has a single repository at any point in time. You can deploy A, use it and after a bit deploy B and use it. But it's either A or B and you will not have both on the server. You can…