You can probably use D3js to do that. Lots of resources on the net on that, for instance : https://www.rittmanmead.com/blog/2013/06/embedding-a-d3-visualisation-in-obiee/ and https://www.clearpeaks.com/adding-javascript-libraries-obiee/ The thing is, how badly do you need this? It may be a lot of work to do this in D3js so…

This in not out of the box functionality unfortunately. Do you want to grey then out because it would result in no data? Or do you need to restrict the report from showing data on these days? In the latter case you could create weekend/holiday indicators in your period dimensions to be ale to exclude weekends and holidays…

Create a dashboard with a main page, a page for CI Adoption and Sonar Adoption and a page for Release and Incident On each page place the reports that you want to display. You can hide thendashboard pages in the dashboard properties: The main page is not hidden, it contains either separate action links or a action link…

How many different layouts do you need? You could also create a invisible Dashboard Page for each layout and create Action links to navigate to them. I still think the presentation variable / conditional section approach is not preferable because it involves a lot of trickery.

DollyG This is a duplicate question, you already created one for the same question: Filter the reports on OBIEE 12c dashboard based on user selection Please create only one post for any question you have.

The pivot table would likely not fit your specific need on hindsight, because the dimension values in the rows (QPH...,.QSM.... Etc) are different for each section. Although if by "Use pivot table?" you mean that you do not know how or when to use pivot tables you should definitively look into those!

Probably the most simple solution is to use a pivot table by the way. If you're short on time, go for that!

Are you looking for this? : https://bintelligencegroup.wordpress.com/2010/08/31/horizontal-pivot-sections-in-obiee/ That's not out-of-the box functionality, I didn't test that myself so not sure if it (still) works.

Make all sections collapsible. That way the user can collapse all the sections he/she doesn't need to see. The user can save this customization and make it the default for this dashboard.

For one of the SR's I raised the rep assigned to it was called Nissu (or something similar) which pretty much read as 'An Issue' So...No thanks...

Interesting.. we also had this issue on all environments on 16/01/2018. Not sure if I can find out the previous failure date... EDIT: Previous failure 28/11/2017 ...

You probably get the results you want using a pivot table presentation. BUT: Why is this data divided over more then one table? As Dimensions and Measure seem to be the same (from functional POV) If you model this correctly you wouldn't have to do a union (which limits flexibly of your analysis) in the first place. Please…

Did you notice that the amounts are equal to the right columns multiplied by 144 (or 12*12)? That might give you a clue what is happening. Other then that not much to add to the help Robert is already providing.

Hth,I would appreciate if you mark our answers as such! :-)

Did you check this document?: https://support.oracle.com/epmos/faces/ui/km/DocumentDisplay.jspx?_afrLoop=211650537315642&id=1462776.1&_afrWindowMode=0… EDIT : That link doesn't seem to work correctly, try this one instead:…

See: https://businessintelligence.technology/2013/03/05/report-based-total-pivot-table-calculation-option-in-obiee/

True, that happens sometimes. Also, you will have to deal with similar problems if your physical model is not a star model. BTW, I just wanted to provide some more information not invalidate your answer in any way.

Case 1 Probably means your model is not correct or at least not optimally modeled (as it should probably be a single fact table and that is how you should model it in the BMM). So you should model conformed dimensions (Case 2) , That you can even join facts that are on different dimensional level if you set the content…

You can create a column prompt for year, right? Then limit the other prompt by that and you should be fine.

Gianni is right, use limit by if you want to limit one filter on the selection of an other