By sum by year I mean; - sum (your_measure_here by Your_Year_Dimension_Here) Without the graph, straight table, do your results look valid?

I could be misunderstanding your requirement and grossly simplifying, but have you tried in the formula using sum by (year in your case)? Also, when you say the numbers go crazy, have you tried changing the formula control to 'server complex aggregate'?

Hi Lee, I have been on a lot of projects with OBIEE.... At some point in every project you hear the words "I need to export 600,000+ rows"... At this point my heart invariably sinks. Why? 1. Export of large volumes is usually indicative of a 'cottage industry' where people spends large amounts of time manipulating data…

Hi, this would be achieved by creating BI Agents. BI Agents can run conditionally, based on the results of another analysis and the reports can be generated in pdf, excel etc etc format. So not identical method but similar result. Trigger tends to be a dirty word in Oracle DB circles....

The only hits I have been able to find on this is fairly old, but seems to match your experience. I would recommend logging a service request with My Oracle Support to get the definitive on this. I found a hit on My Oracle Support that was a dead match, but I no longer have the internal rights to see it as it was an…

You might want to look into evaluate, this allows you to use any functions in your underlying database. Though per the manual replace should work for you; - SELECT REPLACE('JACK and JUE','J','BL') "Changes" FROM DUAL; Changes -------------- BLACK and BLUE

On creation of the table this would be down to your ETL / data warehouse developers as like all things it will not stand still, the joins that the table provides will be dynamic. Alternatively you could achieve the same by creating an opaque view, but I would not recommend this as it would not be nearly as performant.

Also => http://sudiptachowdhury77.blogspot.co.uk/2017/02/enable-clob-field-in-obiee.html http://jinexobiee.blogspot.co.uk/2015/05/handling-large-data-objects-in-obiee11g.html

See also=> https://www.kimballgroup.com/data-warehouse-business-intelligence-resources/kimball-techniques/dimensional-modeling-tech… for a brief explanation on the principal of bridge tables. And, for another worked example=> Brent Greenwood's blog: Bridges

I am not points grubbing for Pedro or myself, but good forum etiquette is if you get an answer then at least mark your question 'Assumed Answered', then others don't waste their time trying to answer your question. Also, if the answers are genuinely useful then marking correct or helpful will help other users of the…

On service account you should really use the client's, get them to set you up, they are the customer!

Thanks - I always wonder why people want to consume vast swathes of rows, usually it comes down to 'because we can in excel', but there you still have to scroll / page down - even if you could the brain to process 1000s of rows by 1000s of rows (1000,000 combinations) end users still cling to the comfort blanket of the…

Pedro's suggestion is good, but depending on your exact requirement you may also want to look at master / detail functionality, there the detail report 'listens' to a channel which is set by the click on the master report, with both remaining visible.

Hi Lee, I don't have a fix / cause, but I do have a useful workaround. Create a substring based formula on one of the descriptor lead columns and then you can give the user a prompt selector for A,B,C slices of the total pivot. Not perfect, but it does actually make massive pivots easier to navigate than the default…

If your demo matches another environment that has everything for the users except the afore mentioned favourites then you could copy it over, having backed up first...

Mea culpa - apologies, I seem to be bold blind

See => User are faing issue in run the report

Hi, you might want to search down the boards for a nearly identical post on the exact same subject. Also, you don't say what version of OBIEE and you don't say what browser / browser version

You might want to start with this. https://docs.oracle.com/cd/E14571_01/bi.1111/e10541/configmap.htm#BIESG1340

I think the advice would be use an ETL tool or other data pump of choice. Really, OBIEE isn't the droid that you are looking for.