Why are you asking us? MANAGEMENT wants the new system - management therefore has the criteria and requirements for making the decision ... I often say "You can confess to one or both of the following 2 sins - incompetence or inconsistency; there's no opting out of either - pick one or both..." Incompetence - management…

Total miss on the intent and design of the OBIEE tool ...

I'm referring to the database ... use drives physical data model design.

Why don't you have a single surrogate key that takes into account the data source, integration and other key values? Simplify ...

MVP - minimum VIABLE product

You've got an issue showing numbers on the chart -- you are also compounding the issue with using 3D charts ... remove the 3D charts - remove the red coloring (unless you are meaning to convey an alert) ... leave the default with the mouse over ... as non-3D will be easier to read the relative sizes a simple move of the…

"Percent of" in OBIEE pivot-tables - Andreas Nobbmann - Blogs - triBLOG

That's a data governance issue ... users making changes after the fact (why spend the money on a modeling tool like OBIEE? just dump data sets via queries straight to Excel).

Need more info to be able to help you ... what does your logical model look like?

I'm a hybrid guy ... there are some parts of the discipline that go 'waterfalling' to success ... there are other parts however where the iterative and keeping in mind the Minimum Viable Product at the forefront do wonders!

I recognize the tables ... it's OBI Apps ... adding hints makes it worse ... are you following the proper customization techniques for Apps? You've purchased a product that does perform - don't go making changes so that it doesn't. I have implemented Apps on very large instances of the Apps warehouse ... before you fiddle…

This is the issue with 'mock ups' in excel ... I arrived at a client once and they handed me an excel workbook with tabs for all of their 'mock ups' ... no true vetting of any requirement in the destination tool! Rather spend the time getting the information model right, then you can BUILD the visualizations live with the…

There is absolutely no analytical value in the color scheme presented ... in fact it deters from anything else you've ever colored green (for good) ... @Robert Angel is correct -- this isn't the intent or proper use of the tool. I also support the suggestion of using BI Publisher and you can 'host' that report on your…

ascetic - characterized by or suggesting the practice of severe self-discipline and abstention from all forms of indulgence, typically for religious reasons. ^ that made me crack up! -- but maybe that's what people who want to data dump form OBIEE need aesthetic - concerned with beauty or the appreciation of beauty

On OBIEE 11g: * Oracle recommends that Oracle BI Presentation Catalog groups be used for backward compatibility only and that Application Roles be used instead for new installations. Catalog Groups as a way of doing things went away a long time ago ... do you have a mix of them and application roles (due to moving from 10g…

"The group who set up the tool for my company aren't around to assist unfortunately." ^ this is a 'living' tool ... not a set-it-and-forget-it tool ... your company absolutely has to get a BI program going and appoint someone to administer and develop this tool IN CONJUNCTION with the changes in the business. The problem…

You will run into a management nightmare with the general user population having the ability to generate Direct Requests .. I'd rethink displaying these requests on a generally available dashboard.

It's faster and reusable if you do your Previous Year -1 in your variables as well ... if you do it in the report header - then you have to do it for every report ... SQL developer does a lot to 'hide' conditions of data types given you can set up formats for your sessions (I often get people coming to me with this issue -…

"huge data" - OBIEE is not a data pump ... what's the end game? what are the individual pieces that drive an action? Any data that doesn't drive the decision on how to act is noise ...

I'd reply: How would such a requirement after being vetted and agreed upon ever get passed to a developer? A request is not a requirement ... the issue is not 'how?' (that's easy join the keys where the granularity matches) - but the 'why?' (the rules of dimensional modeling are thrown out) YOU are interviewing them too…