Eimis Pacheco wrote:...Note: I have read the now Community Posting Etiquette and How to Ask Questions in OTN Spaces . I think I have not been disrespectful, I have been professionally honest, from my point of view I have not broken any rule, according to what I read. well, I thought my question was easy to be understood…

If you're using an Oracle database, you can use Oracle Text to do that for you, it isn't really that complicated and you can easily create a table that counts the number of occurrences of each word in a specific database column. In this example here, it's shown how it's done against documents but you can do it using…

No, the error you're getting it's normal. The filter is expecting to receive a date value and instead is getting the value 'vTest'. Like I said, in the screenshot that you put there where you set the filter, fill in the box for (default) (just below the one where you put the variable name) and the variable will assume that…

What do you mean by exactly by this: "This is working when I open the answers but when I look at the results it is giving an error "date value was expected"" ? It's normal that you can only see result for your analysis when you have it in a dashboard with the dashboard prompt that sets your presentation variable @{vtest}.…

Have you checked the NQServer.log? It may be the case that's something was correctly configured and you'll most likely find information there that may guide you to the issue.

Hi, If you had done a quick search in the forum you would've found the same question you have already answered, for example, here Anyway, if you download the public Sample App (v607), you'll find there examples that already deal with what you want to do.

By default you can only put the legend at right, left, bottom or top of the bar (you can also not show it). For what you want to achieve, the best option may be to create a legend view where you have more control over the display, you can choose how many values you want to show per row, customize labels, colors, etc.

Just to add something to what @FTisiot just said. In order for you to be able to rename an object, you need to check the box "Edit presentation names" in Tools -> Options

Hi, That's happening because the use of the EVALUATE function needs to be enabled before you can use it. See here item 7.35. Also, if you have a time dimension defined, you can use the time series function AGO to achieve what you're probably trying to do with the EVALUATE function.

Try changing your formula to ifnull('@{p_c1}',"None"."None") Putting the single quotes around the presentation variable may solve your issue

Hi Saro, If I understood your situation correctly, I think you're overcomplicating your analysis. You want an analysis where the 1st column is "Pha Vendor Name" and the 2nd column is either "Fact - PO"."Line Based Amount", "Fact - PO"."Pda Amount Billed" or an hidden column. If that's what you want, just build an analysis…

Hi, You don't really have to make your presentation variable return null, you can just set the default value of your presentation variable in your column formula be null with something like this: ifnull(@{p_c1}['@']{cast (null as char)}, "None"."None")

Hi, Are you sure you're performing that action with an user with dba privileges? The error message leads to believe you aren't. Take a look at the documentation here. (To create schemas with RCU on Oracle databases, you must possess the DBA privilege and be logged in as SYSDBA (for example, as user SYS, with the SYSDBA…

Hi, I don't you just add the original Gross Revenue metric to the analysis as well, add a sort to that column and in the column properties hide this column (checkbox). That way, you can add this column to your table and the sort will be applied.

If all services are running as you say then yes, check your sawlogX.log and nqserver.log

Check the logs, otherwise you won't be able to solve the issue and we won't be able to help you since we can't really guess what went wrong with your system. Besides, even if you solve the issue by trying multiple things, you'll never know what went wrong.

You have the all logic there, you just had to work the other way around. If you have a date such as 01/01/2016 02:52:48, you can simply do: HOUR(date) = 2 MINUTE(date) = 52*60 (seconds in a minute) + SECOND(DATE) = 48 = 3168 Divide that value by 3600 (seconds in a hour) and you get 3168/3600 = 0.88 Finally, just put…

Hi, Your CASE works even though it could probably be improved, didn't read it carefully. You're right when you say that if you also want to consider seconds the logic will become even more complicated. So, as you said, you can probably try to follow a logic as you have for your 2nd option and just see if 16.1245 > 16:01:00…

Hey, Post here what you've tried to do with minutes. If you just say you tried to do and it has to many CASES without posting anything, we can't really help you. Just describe the logic you're trying to implement and how exactly you're trying to do it and I'm sure you'll get help.

Ok so based on your example, it seems like using the hour doesn't work out for you. What else can you add to the logic to make it work?