Yes, I have understood the details. Thanks for checking again.

Hello Gianni, Please allow me sometime to check on this, maybe a day or so. Will update with my findings.

Hello Gianni, Does your source really store "a, b, c" , "f, g", "10; 20", "40; 50; 10" as values? No, this is a UI and the UI is showing multiple values for a specific field; which again stores the data in column format (and not row-wise). We are using PIVOT to convert the data in ROW Wise format and in the same process,…

I did and the proper solution was re-design rather than hacking. It's perfectly do-able but the question is SHOULD it be done. How did you re-designed? This is the data coming from the source and we do not have any control over there. Plus, the customer is not in agreement to show multiple rows if there are multiple values…

My initial response was the same... But I can't help as this is the data we are getting and the requirement is like that only. I even don't know how many values can come in a column, so cannot use substrings as well. Unfortunately, this is the scenario. Let's see if there is some other Genius mind who have already…

Hello Christian, It seems the image was not pasted somehow after posting the question. I have updated the original post with the image. The problem is that I have to create links in such a manner that the column holding multiple values, should get links for each of the values.

Hello There, The question is: why would you change the port to 80? This port is pretty common one is used extensively for other services? Is this port 80 getting used anywhere else? These are reserved ports and should not be used elsewhere, like port 1525 is for Oracle DB.

+1 to Christian Sir... deniska If you are running the command directly from the server where the RPD resides, then -S switch is not required.

Did you checked the OBIS1 log as well?

Hello There, Did you tried with both the users? Try weblogic user as well.

Hello There, Did the solution worked? Can you please close this thread marking the correct answer?

Hello There, Please mark the question as Answered as people here take a lot of effort to answer the questions. Also, this helps other guys who are in dire need of some pointers. HTH.

Hello There, With Christian's solution, you can use Priority Groups to define the Fact that should be selected for the query. You'll have Multiple LTSs mapped to conformed dimension columns. By defining the Priority Groups, you can force OBIEE to select the LTS that you want to query on. Thinking out aloud, this should…

Hello Jerry, The problem is: 1. There are other measures as well for which this calculation is required. 2. This is part of a self service and similar reports will be created by end users, who barely know OBIEE. They are now trying their hands on OBIEE, so I don't expect them to be able to understand or create such reports…

Hello Jerry, This looks good for point #2 (for getting the delta values). Allow me sometime to check on that. Do you have any solution for the point #1 where I want to get the count of all the open issues week by week. In short, the query will pass the weekend date and will get all Open issues till the weekend date. If the…

Hello Jerry, Apologies for coming this late. The main problem that I am facing is: Point in-time data is required. I want the analysis to be generalized instead of hard-coded. I have to pass week-end dates in above condition so that it calculates all the open issues from start till the weekend date (instead of the…

Hey Robin, You can definitely achieve this using CASE Statement with TIMESTAMPADD function. Before that, I would like to understand what you have done so far, like what formula you are using currently, filters, etc.

Atleast provide some details as people trying to help you are not aware of your system configurations or the steps you are following.

Generally, when you get a certificate, you extract the Root, Intermediate and Personal Certificate, install them and then import them into your identity. You should see 3 entries in your identity: 1 for Root, 1 for Intermediate and 1 for Personal. Once all the steps have been covered, you should start the NODEMANAGER…

Also, try setting up the decimal places (or divide by 10000.00). BTW, when you say, you are getting incorrect output, what do you mean? Can you post an example of the input and output that you are getting,please?