Adding to Mr. Berg's solution, it all comes to just adding to users to Roles: Let's say there are 2 users: USER A- Creator of these reports USER B- Who will be seeing these reports, but cannot edit these reports Create two custom Roles (ROLE A and ROLE B) and add BI CONTENT AUTHOR (Role A) and BI CONSUMER (Role B)…

Thanks Robert... Seriously how can I miss that record... my bad. I would go with Joel's solution of using Rank function... simple and effective as the requirement is to get just the top record by date for each ID..

Hello GSR, I think you can also use max(date) and then group by all other attributes...

@Charles M Exactly my point to keep it OPEN (read Only) Thank you @Christian Berg Sir for confirming the same...

Dear Charles, You will have to give Read-Only (OPEN) access to the catalog to make this go away.

Hii 3051209, Where are you trying to filter out the records - At RPD Level or at Analysis/Report Level? Also, is this filtering based on the inputs the users will provide? If yes, I think you can get the help of Session Variable in RPD and Request Variable in Analysis to achieve this. I hope this link will help you…

Dear 3063133, Can you please start the components separately and check what error message you are getting? Go to <Oracle_Home>\user_projects\domains\bi\bin\startNodemanager.cmd If above step is success, Go to <Oracle_Home>\user_projects\domains\bi\startWeblogic.cmd Most probably you will get some relevant errors in this…

Hello Masu, We are also upgrading from OBIEE 12.2.1.3 to 12.2.1.4, but the steps are failing at pre-requisite checks only. Request you to kindly share any step-by-step docs that you might have created for your environment. Thanks in Advance.

Dear GSR, How are you starting the services? If you are using start.cmd directly, I would suggest you to paste the entire log so that we can see what all have started and what is failing.

So sorry, got busy in a few back to back issues. I will try to close this ASAP. Thank you all for your time and help.

Hello Martin, Thanks for clarifying that the issue is other way around. I was assuming the fix was to include negative values in Pie Chart... Hello Robert, Thanks a lot for the suggestion. I would like to inform that I have to plot the graph on basis of 2 values only (smaller graphs in my original post). Also, the problem…

Thanks Martin for all your support. Really appreciate your views for PIE Charts... As you said, it was fixed using some patches in 11G, however, I am using 12C and yet I cannot see a fix of this previous version's issue.

Hello Martin, I have updated my users that negative Pies are not possible, but, came across some Oracle link (in the original post) saying this is possible. I just wanted to understand if that is possible (though it doesn't make any sense to me)... ? Also, just a quick check from unrelated topic... Can I do Conditional…

Dear MARTIN, Thanks for replying back... I am trying to achieve the functionality similar to EXCEL, where the negative PIE chart is plotted using the Absolute value. Our users are currently using EXCEL for plotting the Pie charts, which is a mix of positive and negative values. The model is something like above: 1 PIE…

Hello Joel, This is not working for me either. When I am clicking on the graph, it is not passing the values to the Pivot reports. All these reports are in separate SECTIONS...

Hello Joel, Thanks for the quick response... As far as I understand, Master-Detail linking is used in the same report/analysis. I am not sure how to use it for multiple reports... Do you have knowledge of any documentation that explains this with multiple reports? Also, what will be my column for creating the channel as I…

Thanks a lot Martin... I think this will pretty much solve the issue. Although, I have taken a different approach as the data is very limited and will not grow much, I have included some null records to cover all the required data from the dimension table. @Robert, Yes, my final option was to create some views and then…

Hello Robert, Thanks a lot for the reply. I'm sorry, I missed to mention that the model is purely STAR Schema.. Saying that, I have to apply a filter where "T619423.pqr = 1" ... I cannot use any other values as suggested (like NULL), because then some other unwanted values will come and definitely, there is no way I can…

It will be really nice if you can post an example of your requirement. @Chris, As far as I understand, your solution will fetch the records for that particular date only. Instead, we can extract the month and Year using TIMESTAMP function to get the previous month using the SYSDATE.

Hello Gianni, I am trying to customize the default login page that comes post installation of OBIEE 12.2.1.3. Please see below the screenshot of my login page: Here I want to change the logo "ORACLE" with my customized organization's logo. Also, I am trying to change the blank background with some images from my…