Thanks Joel - log has been checked. The BI server log doesn't have an error log since the reports work fine however an error log shows in the WebCenter portal logs. Snap attached. Let me know if you have ever run into this yourself. Much appreciated.

Thanks for your reply Christian. They are all under the same SA. I know that it will pass the filter value into the analyses but my problem is having the values from the dashboard prompt to automatically pass into 6 analyses. Eg - Select "Northeast" under region prompt, and the expectation is to have the dashboard display…

I agree and this was my initial thought, but I'd like for the user to be able to see reports based on multiple action links provided. I think for now I may have to go with Pedro's suggestion. Thank you both!

Solution - Found out there is a specific logic on how the built in "reset" button executes. It does not reset the values as I'd like for it to. If had 3 different reports (e.g. Sales, Accounts Receivable, Monthly Bills) and selected "Sales" report and this report has its analysis prompts which can be Year, State, City,…

I completely understand your perspective Christian. However, customers would like to set it up this way and I truly feel that is throwing the engine off. After research it seems there are workarounds (hiding the reset button and creating a new one using HTML markup), but now I am stuck trying to style the new reset button…

obiee_architect -- Thank you this is precisely what I was looking for. I knew some manipulation needed to be done and you routed me to the right direction for this novice OBIEE user. To everyone else, thank you for your insight as it helped me understand my question more and will do my best to explain clearer in the future…

The numbers were just an example -- I was expecting OBIEE can execute conditional formats against 2 fact tables e.g. 'FACTS.McDonalds' = 'FACTS.Burger King'.

Hi Gianni, I am on 11.1.1.19. 

LOL, I was thinking the same. A bold move but worked out due to the technical advice provided on this thread regarding unnecessary changes! Cheers to all !

Thank you all, we were able to efficiently convince our customers this unnecessary cosmetic change will lower performance and was able to keep it in the same format as a year should!

Gianni, I wasn't able to figure out the exact problem per say, but I did go in iteration and took an existing working analysis and built on top of that while deleting the columns 1 by 1 in the criteria section. This work around seemed to do it. Thanks!

I thought so initially, but I don't think that is the case considering the other 2 are set up exactly how it should and working fine. I then suspected it might be a cast function as a double on a column, but that also works for the other 2 analysis. I'll come back and post if a solution is found.

Gianni, it is. Sorry about the duplicate. I was just wondering if anybody had any other inputs considering the logs didn't help to much. Sorry for the redundancy

Absolutely correct Gianni, as imperative it is to have legends, it didn't make sense for us to spend too much time on such a task. It would be great to have one, but we ended up hiding the legend. The problem stemmed from having 2 facts not rolled up to the same level.

I'll have to check those out. I'll update if I find anything useful there. Thanks Gianni

Thanks Gianni, so here is the full error I am getting Thank you.

Gianni, I think your idea with the extra column just might make it work for me. As always, thanks for the great insights, you've helped me come a long way ever since I have been using OBIEE. Best, Andrew

I was in the same boat a while back. I believe setting it at level 2 lets all users call database functions in OBIEE. If I find my reference from my notes, I'll post it over here.

Gianni, thank you for your helpful answer. This is exactly what I was looking for! One last thing - I have a master child detail detail so that when you click "XYZ" it will show the users buying that product, it doesn't seem to be working and I'm assuming it is due to the newly calculated item, is there a way around this…

Christian, thanks so much for your prompt reply. I will give that a shot here soon and will keep you posted.